Excel Destination - Want to preserve the Excel Workbook after loading and Save to a LOcation for User Access

Question

Excel Destination - Want to preserve the Excel Workbook after loading and Save to a LOcation for User Access

Welsh Corgi

SSC Guru

Points: 116520
More actions
November 3, 2011 at 6:23 pm

#390761

I have an SSIS Package with a SQL DataSource and An OLEDB Excel Data Destination Object.
After I load the Excel File it gets to about 90 MB.
I want to preserve the Original Excel Template File and Save the Results to a Delivery Location accessible by Users using the most easist approach.
Any help would be greatly appreciated.
Many Thanks.:-)
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

kramaswamy SSCoach Points: 18181 More actions · Answer 1

Create a blank template file, and a blank output file. As the first step in your process, use the File System Task, choose Copy File, choose Overwrite Destination, and select your template file as the source and your output file as the destination.

Go through your process, choosing the output file as the destination for your data flows.

At the end, use the File System Task to Copy File, choose the destination as your folder that you want to store for people to view it, append a date or whatever if you want. If you want to make the file name dynamic, then you can through an Expression.

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 2

kramaswamy (11/4/2011)
Create a blank template file, and a blank output file. As the first step in your process, use the File System Task, choose Copy File, choose Overwrite Destination, and select your template file as the source and your output file as the destination.
Go through your process, choosing the output file as the destination for your data flows.
At the end, use the File System Task to Copy File, choose the destination as your folder that you want to store for people to view it, append a date or whatever if you want. If you want to make the file name dynamic, then you can through an Expression.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 3

kramaswamy (11/4/2011)
Create a blank template file, and a blank output file. As the first step in your process, use the File System Task, choose Copy File, choose Overwrite Destination, and select your template file as the source and your output file as the destination.
Go through your process, choosing the output file as the destination for your data flows.
At the end, use the File System Task to Copy File, choose the destination as your folder that you want to store for people to view it, append a date or whatever if you want. If you want to make the file name dynamic, then you can through an Expression.

Thank you!

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/