SSIS Script task Call stored procedure with OleDB

Question

In SSIS Script task how to execute a stored procedure using oledb connection.

Answer 1

Why restricted to oledb?

• 1st Option: if you can use ADONET connection then you can use below solution in your SSIS script task.

• 2nd Option: Fetch and store records in some object type variable using SQL TASK (use OLEDB connection here) and then pass that parameter to Script task and perform operation like in the below screenshot. Then you have all records available in datatable to play around.