how to append rows to excel using SSIS
I know how to populate the data to excel from database and let the data sit in excel from second row . But if I have a template excel with 3 rows in the beginning, and I don't want to overwrite them, so I need to populate data from row 4, is that doable?
December 30th, 2011 1:02am
Since the Excel destination does not offer the OverwriteDestination = FALSE option you will need to employ some .Net MS Office interop code in a Script Task to achieve this.Arthur My Blog
Free Windows Admin Tool Kit Click here and download it now
December 30th, 2011 10:06am
Since the Excel destination does not offer the OverwriteDestination = FALSE option you will need to employ some .Net MS Office interop code in a Script Task to achieve this.Arthur My Blog
December 30th, 2011 6:05pm
This topic is archived. No further replies will be accepted.
Other recent topics
