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

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

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
kgadde
Asked:
kgadde
2 Solutions
 
sbagireddiCommented:
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
 
i2mentalCommented:
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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

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