88 How to read data from Stored Procedure and insert into SQL table using SSIS

How to read data from Stored Procedure and insert into SQL table using SSIS
Download the file\script used in the Video from below link

How to read data from Stored Procedure and insert into SQL table using SSIS
How can insert stored procedure output to a table in SQL Server?
How can we use stored procedure in SSIS package in data flow task?
Can we use stored procedure in SSIS package?
How do I convert a stored procedure to an SSIS package?

Happy Learning.

[richnomorals]

Thanks, that was helpful and easy to implement

[subbuasup]

Hi Aqil Ahmed,
While sp exec command in oledb source For me it is giving error like
There is a data source column with no name .Each data source column must have a name

[ASIFALI-pnuv]

This was a handy implementation.It could have been better if you would have make the currency name passed through a variable and make it more dynamic. ✌️

[durgaprasadbandarla]

Hi Aqil,


Which is the better way in terms of performance tuning
While storing the table data into object type variable in execute SQL task with a full result set
a) using variable in SQL source type
b) using direct input to write SQL statement.


Please provide the best performance tuning option.

Regards
ETL developer

[simplethings]

Hi Aqil thanks for the video, the task looks difficult but how you explain things makes it really easy. I have a problem in which I need to move the Views & procedures using SSIS(server is on cloud). Can we do this by using above method ? but I need to make the parameters passing to the stored procredure dynamic, so that anyone passing any View name to the stored procedure and this stored procedure just pick the defination of that view using information_schema.views and return it to the another database. ( creating or overwriting the existing view in that database).

Update : Now watching the another Video in which you have make it dynamic. Thanks !!!