• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1431
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

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