SSIS Tutorial Part 49-Multiple Stored Procedures w/ Input Parameters in OLEDB Command Transformation

In this video we will learn how to call Multiple Stored Procedures in OLE DB Command Transformation. First Stored Procedure will be used to Insert the values in a SQL Server Table and Second Stored Procedure will be used to Delete the record from History Table.

What you will learn in this video

How to read data from flat file in SSIS Package
How to Create Stored Procedure with input Parameters for Insert Operation
How to Create Stored Procedure with Input Parameter for Delete Operation
How to Call the Multiple Stored Procedures in OLE DB Command Transformation
How to Map the input Columns to Stored Procedures Input Parameters in OLE DB Command Transformation
Learn if it is possible to map single input column to Multiple Parameters in OLE DB Command Transformation
Learn about the error if mapping is missing for a parameter in OLE DB Command Transformation

Blog post link with scripts used in this video

[krismaly]

I will keep this video for all my reference in my work place

[krismaly]

Awesome
Amir bhai you are awesome.
To tell ten things you need time and taken to explain was extremely reasonable.
I love this video.
I enjoyed watching this video.
Multiple procedures executing
Two procedure separately executing
Telling hints

I learned a lot.

Thanks for educating the community and recommend others to watch.

I want to know Error handling, error descriptions, information, warning, failure and so on... If you could make a video with your experience what kind of mistakes developers do would be good. Also how to over come or fix such errors.
Probably you may have to deliberately make a mistake and demonstrate.

In this video if the procedure fails then how to handle?

Thanks abunch

[trolldicker]

I am new to the SSIS. I am trying to load multiple source tables from my staging database to corresponding destination table in the data warehouse. All the source table have diffrent number of column. I am having 100 of SSIS package of 100 source Tables and 100 destination table. I want to make single SSIS package to load all the 100 tables using single DFT. I have a master table which containing the list of source table and destination table name, and input will be the filename, on the basis of filename my DFT will take the source and destination table and change the source and destination table using variable at run time dynamically. Please suggest some ideas on above concern Regards, Vipin Jha

[JP-tdgt]

What if I want to use ? for parameter inside CTE at the beginning of the query? before the main SELECT Query?

[trolldicker]

can you do a video on using BIML xml coding to perform this dynamic loading