Back to Browse

SSIS Tutorial Part 50- Execute Multiple DMLs with Parameters in OLE DB Command Transformation

10.8K views
May 6, 2015
18:56

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