Excel output in SSIS

need to time stamp an Excel ouput file everytime SSIS package is run.  The excel file is located at c:\customer.xls
I want the output to look like todaysdatetimestamp_customer.xls.  The data is coming from a database (OLEDB Source) to Excel Source
Nana HemaaAsked:
Who is Participating?
 
Nana HemaaAuthor Commented:
I saw this link before consulting experts.  I ended up using a VBScript to resolve the issue
0
 
Brian CroweDatabase AdministratorCommented:
Use a File System Task.  Below is a tutorial on how to do that.

http://www.rafael-salas.com/2007/03/ssis-file-system-task-move-and-rename.html
0
 
Nana HemaaAuthor Commented:
I am not using a for loop container
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Nana HemaaAuthor Commented:
I have a simple select statement and sending the output to an excel
The data is coming from a database (OLEDB Source) to Excel Source
0
 
Brian CroweDatabase AdministratorCommented:
Then don't add one the intent was to highlight the File System Task.
0
 
Nana HemaaAuthor Commented:
ended up using a VBScript to resolve the issue
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.