Solved

Sending Excel file through SSIS

Posted on 2008-06-25
2
513 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
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

I am showing a way to read/import the excel data in table using SQL server 2005... Suppose there is an Excel file "Book1" at location "C:\temp" with column "First Name" and "Last Name". Now to import this Excel data into the table, we will use…
INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

911 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

22 Experts available now in Live!

Get 1:1 Help Now