April 26, 2010 at 5:06 am
Hi All,
I need to export 2 sets of data to the same Excel sheet. The first set has a fixed number of columns (say col A-F), and I need to add another set of data beginning from col G; the number of columns in this case varies. How do I do that? (Unfortunately Excel application is not available on the server, so I can't open the file with VB)
Any help is highly appreciated.
Thanks.
K.
April 26, 2010 at 5:20 am
SSIS is not good at dynamic columns - you are going to struggle.
In principle, it would be better to marshal all your data together in the SSIS pipeline and then write it out to Excel in one pass, not two. If you can somehow come up with static columns, which may or may not be populated, you should be able to do it.
Do you have the option of writing to a CSV file instead? These are much more reliable and, if necessary, you could write a script task to give yourself all the dynamic-ness (excuse the made-up word) you need.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply