• Status: Solved
  • Priority: Medium
  • Security: Private
  • Views: 39
  • Last Modified:

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
0
Nana Hemaa
Asked:
Nana Hemaa
  • 4
  • 2
2 Solutions
 
Brian CroweCommented:
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
 
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
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

 
Brian CroweCommented:
Then don't add one the intent was to highlight the File System Task.
0
 
Nana HemaaAuthor Commented:
I saw this link before consulting experts.  I ended up using a VBScript to resolve the issue
0
 
Nana HemaaAuthor Commented:
ended up using a VBScript to resolve the issue
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now