I enjoyed watching this video and recommend others. Well explained Return Value InPut params Output params with simple stored proc Explained creating variables watching variables setting break points Explained ADO and OLEDB with params Thanks for educating the community and appreciate your volunteership Please please keep educating the community Thanks a lot
This video might be more relevant for you: th-cam.com/video/W7gUYWsQEWc/w-d-xo.html Each row is loaded into a bunch of SSIS variables which can be used one row at a time to feed into other tasks. But remember - processing one row at a time can be a slow operation for anything more than a few hundred rows. More conventional SQL commands might make more sense.
I enjoyed watching this video and recommend others.
Well explained
Return Value
InPut params
Output params
with simple stored proc
Explained creating variables
watching variables
setting break points
Explained ADO and OLEDB with params
Thanks for educating the community and appreciate your volunteership
Please please keep educating the community
Thanks a lot
Thank you sir! Exactly what I needed, rare to find a clear explanation of this.
Clearest instructions through this process I have seen, great work.
Great explanation, thanks
Nice video. Thanks.
Thank you
Hi Sir
Very nice explanation.
I have one question my execute Sql task returning 500 rows. How and where to manage result set.
Please explain
Thanks
This video might be more relevant for you:
th-cam.com/video/W7gUYWsQEWc/w-d-xo.html
Each row is loaded into a bunch of SSIS variables which can be used one row at a time to feed into other tasks.
But remember - processing one row at a time can be a slow operation for anything more than a few hundred rows. More conventional SQL commands might make more sense.