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?
Free Windows Admin Tool Kit Click here and download it now
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
Free Windows Admin Tool Kit Click here and download it now
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
Free Windows Admin Tool Kit Click here and download it now
October 24th, 2010 4:45am

Thank you...
October 24th, 2010 6:21am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics