Solved

Sending Excel file through SSIS

Posted on 2008-06-25
2
516 Views
Last Modified: 2008-07-03
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
Comment
Question by:tuckandroll
[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
2 Comments
 
LVL 5

Accepted Solution

by:
catherinelouise earned 50 total points
ID: 21872471
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
 

Author Comment

by:tuckandroll
ID: 21877804
thanks for the tip catherinelouise. I'll give it a try and let you know!
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

732 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