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 


  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

  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

  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 |

  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

  5. Thanks for the interesting blog that you have implemented here. Very helpful and innovative. Waiting for your next upcoming article.
    Java training in chennai
    Java training institute in chennai
    Java course in chennai
    Java training classes
    Java training
    Java programming classes
    core java coure

  6. 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

  7. 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


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

  9. 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

  10. 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

  11. 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.

  12. 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

  13. The establishments of promoting are moderately simple to clarify and get it. But acing these basic concepts can cruel the difference between success and disappointment. JivaITSolution

  14. Thank you for your articles that you have shared with us. Hopefully you can give the article a good benefit to us.
    SQL Server DBA Training in Bangalore

  15. Wonderful blog found to be very impressive to come across such an awesome blog. I should really appreciate the blogger for the efforts they have put in to develop such an amazing content for all the curious readers who are very keen of being updated across every corner. Ultimately, this is an awesome experience for the readers. Anyways, thanks a lot and keep sharing the content in future too.

    Digital Marketing training in Bhilai

  16. I see the greatest contents on your blog and I extremely love reading them. ExcelR Data Analyst Course

  17. Nice blog,
    <a href=">Digital Marketing Course in Hyderabad</a>

  18. Wow such an amazing content keep it up. I have bookmarked your page to check out more informative content here.

    SASVBA Provides Best Deep Learning Course in Delhi with Latest Development Environment and Frameworks. We keep Our Courses Up to Date with the Latest industrial trends. SASVBA Is One of the best training Deep Learning Institute in Delhi NCR Which Helps Students to Crack Interviews in Tech Giants. We train college students as well as school students.


  19. This comment has been removed by the author.

  20. Nice blog post,
    Digital Marketing Training in KPHB