I need to do a simple task. I have a oledb source which pulls data from sql server, creates an excel file abc.xls and dumps it with the Excel destination at remote location.
I need to create this file at runtime. However, when i give the location, the Excel Destination expects the file to be there for the Mapping of the source columns with destination ones.
My tasks are
1. Creating a table for the worksheet in Excel connection
2. Select from source table and write in Excel Destination
Will appreciate your response.
You can create the xls file at run time without problem; but the file need to exists at design time as SSIS needs to get the metedata from it.
I have a couple of posts that show some examples using excel files; I hope you find them helpful
http://rafael-salas.blogspot.com/2006/12/import-header-line-tables-into-dynamic_22.html
No comments:
Post a Comment