October 11, 2012 at 10:27 pm
All,
There is already excel sheet is available in One common location, which contains all header rows alone.
My requirement is , i need to write the data into excel sheet dynamically. I may receive more then 1,50,000 record from database. In the first sheet i need to write 50,000 records(Here header row already exist). Inthe second sheet i need to write Next 50,000 records along the header row(same header row in first sheet). and same in the third sheet next 50,000 records .
Can you pleae guide me,how to achieve the above requirement.
October 12, 2012 at 2:42 am
You need to split the rows (for example with a conditional split) and use three different Excel destinations to write the data.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 12, 2012 at 3:27 am
We cant defined the excel sheet count . It may vary based on the record counts received from Database.
Another issue, Currently am able to create excel sheet and place the records dynamically.The issue is when creatign the column dynamically
Eg: - [Leader #] - it assigned in excel sheet as [Leader .] (followed by dot symbol,instead of # symbol).
The above activity done by script task only. (Excel Sheet creation, column creation, and record placed)
Can you please guide me, how to overcome this issue.
October 12, 2012 at 3:41 am
As it's dynamic, you can't use the dataflow, so you are stuck with the script task.
Regarding the column name, how do you create it?
The column name is just a cell in the sheet, so it should accept the # symbol.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply