SolvedPrivate

Excel output in SSIS

Posted on 2014-04-09
6
26 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
  • 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
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

 
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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

My client sends a request to me that they want me to load data, which will be returned by Web Service APIs, and do some transformation before importing to database. In this article, I will provide an approach to load data with Web Service Task and X…
Here's a requirements document template for an integration project (also known as Extract-Transform-Load or ETL) based on my development experience as an SQL Server Information Services (SSIS) developer over the years.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

867 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now