• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 520
  • Last Modified:

Sending Excel file through SSIS

Hi there family,

How do I create a SSIS package in SQL Server 2005 to 1) create an Excel file  from a stored procedure and 2) send this Excel file to a specific file directory (i.e., C:\My Documents\Misc\) all in one fell swoop?
0
tuckandroll
Asked:
tuckandroll
1 Solution
 
catherinelouiseCommented:
Hello, try:
On the Control Flow tab add a Data Flow task.
Edit this, you will be taken through to the Data Flow tab.

Add a Data Reader Source task, in the Connection Managers tab you will need to create a .NetProvider\SqlClientDataProvider connection and configure a connection to your SQL Server and db where the stored proc resides.  In the Component Properties tab, type in the SQL statement that will execute your stored procedure in the SQL Command field.  You may need to change the timeout value depending on how long your sproc takes to complete.

Finally add an Excel Destination task, here you can configure the destination and name of the excel output file.

0
 
tuckandrollAuthor Commented:
thanks for the tip catherinelouise. I'll give it a try and let you know!
0

Featured Post

Free recovery tool for Microsoft Active Directory

Veeam Explorer for Microsoft Active Directory provides fast and reliable object-level recovery for Active Directory from a single-pass, agentless backup or storage snapshot — without the need to restore an entire virtual machine or use third-party tools.

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