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 


20 comments:

  1. Replies
    1. Big data is a term that describes the large volume of data – both structured and unstructured – that inundates a business on a day-to-day basis. big data projects for students But it’s not the amount of data that’s important. Project Center in Chennai It’s what organizations do with the data that matters. Big data can be analyzed for insights that lead to better decisions and strategic business moves.

      Spring Framework has already made serious inroads as an integrated technology stack for building user-facing applications. Corporate TRaining Spring Framework the authors explore the idea of using Java in Big Data platforms.
      Specifically, Spring Framework provides various tasks are geared around preparing data for further analysis and visualization. Spring Training in Chennai


      The Angular Training covers a wide range of topics including Components, Angular Directives, Angular Services, Pipes, security fundamentals, Routing, and Angular programmability. The new Angular TRaining will lay the foundation you need to specialise in Single Page Application developer. Angular Training

      Delete
  2. 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
  3. 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
  4. 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
  5. Great efforts put to publish these kinds of articles that are very useful to know. I’m thoroughly enjoying your blog. And Good comments create great relations. You’re doing an excellent job. Keep it up.

    Magento Development Training Course in Chennai Zuan Education

    Selenium Training Course in Chennai Zuan Education

    ReplyDelete
  6. Nice blog, it’s so knowledgeable, informative, and good looking site. I appreciate your hard work. Good job. Thank you for this wonderful sharing with us. Keep Sharing.
    Digital Marketing Course In Kolkata

    ReplyDelete

  7. Very nice job... Thanks for sharing this amazing and educative blog post!ExcelR Digital Marketing Class In Pune

    ReplyDelete
  8. Thanks for the informative article About Java. This is one of the best resources I have found in quite some time. Nicely written and great info. I really cannot thank you enough for sharing.
    Java training in chennai | Java training in annanagar | Java training in omr | Java training in porur | Java training in tambaram | Java training in velachery

    ReplyDelete
  9. Wow What A Nice And Great Article, Thank You So Much for Giving Us Such a Nice & Helpful Information about Java, keep sending us such informative articles I visit your website on a regular basis.Please refer below if you are looking for best Training Center.
    Java training in chennai | Java training in annanagar | Java training in omr | Java training in porur | Java training in tambaram | Java training in velachery

    ReplyDelete
  10. Courses in Digital Marketing in Pune
    It's really nice and meaningful. it's really cool blog. Linking is very useful thing. You have really helped lots of people who visit blog and provide them useful information.

    ReplyDelete
  11. Due to digital market approach, there is a serious skill gap among the professionals. Thus, on experiencing such course will stay you ahead in terms of competition as well as provide enough market exposure. As per statistics concerned, we will go to experience a rapid increase in job opportunity in this field and the average figure may reach to approx 1,50,000 jobs by the year 2020. digital marketing training in hyderabad

    ReplyDelete