Solved

capturing resultset of stored procedure and sending results through email in ssis

Posted on 2008-06-12
3
1,403 Views
Last Modified: 2012-06-22
Hi Experts,
i need help in SSIS. I want to capturing results of a stored procedure and send the result set using send mail task. i know that i should store the resultset values in a global variable and then call the variable in send mail task.
i am not able to capture the results into a variable. please help
give me some idea  
0
Comment
Question by:kgadde
3 Comments
 
LVL 8

Accepted Solution

by:
sbagireddi earned 125 total points
ID: 21773767
You can put the result in a table variable or temp table, call that using the send mail task.

Maybe this will help:

http://www.sqlteam.com/article/stored-procedures-returning-data
0
 
LVL 8

Assisted Solution

by:i2mental
i2mental earned 125 total points
ID: 21773859
Assuming your SP returns a table. (if not, just change your variable type accordingly)

create an "object" variable.
Add a SQL Script task
Edit the SQL Script task to have the SP in the sql query field
Change the "result" field to "Full result set"
In the "Results" section on the left, add a result line.
Make that result name "0" and assign it to the object variable you created.

The results will be pumped to that variable.
0

Featured Post

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Advice on encrpting some store produces on MS SQL  sql 5 30
Script to randomly create characters in MS SQL 6 31
SQL query bug 3 28
grouping logic 6 47
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
As a trusted technology advisor to your customers you are likely getting the daily question of, ‘should I put this in the cloud?’ As customer demands for cloud services increases, companies will see a shift from traditional buying patterns to new…

910 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

21 Experts available now in Live!

Get 1:1 Help Now