Back to Browse

SSIS Tutorial Part 43-OLE DB Command Transformation Insert Operation and Parameter Mapping

15.1K views
Apr 29, 2015
11:08

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