Table to new excel file destination
Hi, I have a table and I need to dump those columns into the new excel file...how can I ..??
October 23rd, 2010 7:07pm
Use OLEDB Source to connect to the table and excel destination to connect to excel workbook. Is excel file ready or you want to create it?
October 23rd, 2010 7:17pm
I have to create it....actually I have like 76 columns in the table and how to move those columns to the excel file...??
October 23rd, 2010 7:19pm
Create the file using a file system task. Have a template excel file and use file system task to copy the template file to a required destination. Once the file is copied, use data flow task to pull the data from table (oledb source) and pump it to excel file (excel destination). To configure the data flow task, use the template excel file in excel connection manager so as to successfully create the data flow task. Set an expression for the excel connection manager's connection string property so as to use the excel file which is copied by file system task to some other location. Nitesh Rai- Please mark the post as answered if it answers your question
October 23rd, 2010 7:31pm
I have never used the file system task. can you please elaborate.
October 23rd, 2010 7:47pm
Check this: http://beyondrelational.com/blogs/niteshrai/archive/2010/04/05/creating-a-file-using-ssis-file-system-task.aspxNitesh Rai- Please mark the post as answered if it answers your question
October 24th, 2010 4:45am
October 24th, 2010 6:21am