?
SolvedPrivate

Excel output in SSIS

Posted on 2014-04-09
6
Medium Priority
?
34 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 600 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
Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

 
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

Moving data to the cloud? Find out if you’re ready

Before moving to the cloud, it is important to carefully define your db needs, plan for the migration & understand prod. environment. This wp explains how to define what you need from a cloud provider, plan for the migration & what putting a cloud solution into practice entails.

Question has a verified solution.

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

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
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…
Suggested Courses

765 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