Achievements

« Experts' Perspective Webcast: SSIS Tricks and Tips | Main | Statistics IO parser in Ruby & Python »

PrintView Printer Friendly Version

EmailEmail Article to Friend

Reader Comments (2)

Thanks for the post!
I used it successfully to allow me to call a T-SQL scalar function from within the data flow.
Works great!

June 14, 2013 | Unregistered CommenterMark

Hi Josef,

Excellent article, short and sweet. My personal experience, it is critical to enclose OUTPUT for the parameter(s) that is created as output in the stored procedure.

For example: exec ? = dbo.testoledbcmd ?, ? OUTPUT

Otherwise, no value will be return to SSIS for downstream use.

Thanks.
/Tommy

September 28, 2013 | Unregistered CommenterTommy

PostPost a New Comment

Enter your information below to add a new comment.

My response is on my own website »
Author Email (optional):
Author URL (optional):
Post:
 
Some HTML allowed: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <code> <em> <i> <strike> <strong>