In this video we will learn How to perform Insert Operation in OLE DB Command Transformation in SSIS Package.
We will learn the disadvantages of using OLE DB Command Transformation for Insert Operation and what other options we have to perform Insert in SSIS Package.
In this OLE DB Command Transformation Demo , we will learn
How to Read data from Flat File Source in SSIS Package
How to Create Table in SQL Server Database
How to write Insert statement with Input Parameter for OLE DB Command Transformation
How to map input Columns to OLE DB Command Transformation Parameters
Script used in Video: How to use OLE DB Command Transformation for Insert Operation
Blog post link for the video with scripts
http://sqlage.blogspot.com/2015/04/how-to-use-ole-db-command.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 43-OLE DB Command Transformation Insert Operation and Parameter Mapping | NatokHD