In this video we will learn how to use Multiple Statement in OLE DB Command Transformation with parameters.
We will learn
How to read the data from Flat file source in SSIS Package
How to Write Insert statement with Parameters for OLE DB Command Transformation
How to Write Update Statement with Parameter/s for OLE DB Command Transformation
How to Write Delete Statement with Parameter/s for OLE DB Command Transformation
How to Execute Multiple Statements in OLE DB Command Transformation in SSIS Package
How to Map Multiple Statements Parameters to Input Columns in SSIS Package
Blog post link for the script used in this video
http://sqlage.blogspot.com/2015/05/execute-multiple-statements.html
Check out our Full Step by Step SQL Server Integration Services(SSIS) Tutorial
http://www.techbrothersit.com/2014/12/ssis-videos.html
Download
0 formats
No download links available.
SSIS Tutorial Part 50- Execute Multiple DMLs with Parameters in OLE DB Command Transformation | NatokHD