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 http://sqlage.blogspot.com/2015/05/call-multiple-stored-procedure-in-ole.html