Executing/calling stored procedures in SSIS - part3 - SP with parameters that returns a dataset

Executing/calling stored procedures in SSIS This channel is to discuss the real-time scenarios implementations, In this video we will see how we can call or execute the SQL stored procedures with different scenarios 1. Calling stored procedure without parameters 2. Calling stored procedure with parameters that returns a scalar value 3. Calling stored procedure with parameters that returns a dataset If you are interested to learn the different real-time scenarios implementation in a systematic and consolidated manners, you can visit my Udemy course. https://www.udemy.com/course/ssis-rea...