SolvedPrivate

Excel output in SSIS

Posted on 2014-04-09
6
31 Views
Last Modified: 2016-02-10
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
Comment
Question by:Nana Hemaa
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
6 Comments
 
LVL 34

Assisted Solution

by:Brian Crowe
Brian Crowe earned 200 total points
ID: 39990779
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
 

Author Comment

by:Nana Hemaa
ID: 39991880
I am not using a for loop container
0
 

Author Comment

by:Nana Hemaa
ID: 39991884
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
Edgartown IT Case Study

Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!

 
LVL 34

Expert Comment

by:Brian Crowe
ID: 39991886
Then don't add one the intent was to highlight the File System Task.
0
 

Accepted Solution

by:
Nana Hemaa earned 0 total points
ID: 40005170
I saw this link before consulting experts.  I ended up using a VBScript to resolve the issue
0
 

Author Closing Comment

by:Nana Hemaa
ID: 40103686
ended up using a VBScript to resolve the issue
0

Featured Post

SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
A couple of weeks ago, my client requested me to implement a SSIS package that allows them to download their files from a FTP server and archives them. Microsoft SSIS is the powerful tool which allows us to proceed multiple files at same time even w…
Viewers will learn how the fundamental information of how to create a table.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

724 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question