How to use OLE DB Command Transformation for Insert Operation in SSIS Package - SQL Server Integration Services(SSIS) Tutorial

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

  1. How to Read data from Flat File Source in SSIS Package
  2. How to Create Table in SQL Server Database
  3. How to write Insert statement with Input Parameter for OLE DB Command Transformation
  4. 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

--Create Table in SQL Server Database for Load 
CREATE TABLE [dbo].[Customer](
    [CustomerID] [int] IDENTITY(1,1) NOT NULL,
    [CustomerName] [varchar](100) NULL,
    [RegionCode] [varchar](100) NULL
)

Select * From [dbo].[Customer]


--Prepare Statement for OLE DB Command Transformation
insert into dbo.Customer (CustomerName,RegionCode)
Values (?,?)



How to write insert statement with Parameters in OLE DB Command Transformation in SSIS Package



  Related Posts / Videos on OLE DB Command Transformation 


7 comments:

  1. We, being one of the best Hadoop training institutes in Delhi, provide Hadoop corporate training just as Hadoop placement training Delhi with Hadoop Training online for students. One of the fundamental points of giving this sort of Hadoop certification course is to assist the participants with better placements.
    For More Info: Hadoop Training in Delhi

    ReplyDelete
  2. keep up the good work. this is an Assam post. this to helpful, i have reading here all post. i am impressed. thank you. this is our digital marketing training center. This is an online certificate course
    digital marketing training in bangalore | https://www.excelr.com/digital-marketing-training-in-bangalore

    ReplyDelete
  3. Good job! Fruitful article. I like this very much. It is very useful for my research. It shows your interest in this topic very well. I hope you will post some more information about the software. Please keep sharing!!
    SEO Training in Chennai
    SEO Training in Bangalore
    SEO Training in Coimbatore
    SEO Training in Madurai
    SEO Course in Chennai
    SEO Course in Chennai
    SEO Course in Bangalore
    SEO Course in Coimbatore

    ReplyDelete