March 29, 2010 at 8:12 am
Hello,
Problem: SSIS Dataset to export to seperate worksheet in single Workbook to Excel 2003
I need to group my data on a particular column name and generate as many worksheet as number of distinct column data in single worksheet.
Raunak J
March 29, 2010 at 9:31 am
Use a execute SQL task to get distinct Column data and Then use a FEL to loop on that column data, Place a execute SQL task and a Data Flow task.. so that you can create your sheet names dynamically using FEL and the DFT can be used to insert your column data into that sheet.. Also, store your SQL statements in variables using Expressions
The link below might be helpful
http://rafael-salas.blogspot.com/2006/12/import-header-line-tables-into-dynamic_22.html]
March 29, 2010 at 11:36 pm
Yes it helped...trying to customize more...
Thanks a lot
Raunak J
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply