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. even we can try python!
      Cab service in hyderabad
      White Cabs is renowned for its dependability and top-notch customer support. Experience our reliable cab services in Hyderabad when you book now. For local or out-of-town trips, reserve a white cab in Hyderabad.Employ a radio taxi or a tourist taxi. Travel inside the boundaries of the city of Hyderabad. Get car rentals in Hyderabad for airport transfers, Secundrabad railway station, and local taxi needs.

  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. Very nice job... Thanks for sharing this amazing and educative blog post!ExcelR Digital Marketing Class In Pune

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

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

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

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

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


  9. This comment has been removed by the author.

  10. Nice blog post,
    Digital Marketing Training in KPHB

  11. we are bangalore based SEO company services provider in bangalore
    since 2018. We focused on getting your website to the first page
    and more traffic & leads
    80955 38194


    Hello, I'm here to testify of how i got my loan from BENJAMIN LOAN FINANCE( I don't know if you are in need of an urgent loan to pay bills, start business or build a house, they offer all kinds of loan. So feel free to contact Dr. Benjamin Owen he holds all of the information about how to obtain money quickly and painlessly without cost/stress via Email:

    Consider all your financial problems tackled and solved ASAP. Share this to help a soul right now THANKS.

  13. This type is exceptional. These sorts of minuscule realities are utilized a wide assortment of confirmation skills. My accomplice and I favor the hypothesis much.
    Volvo bus on rent in Delhi

  14. This command often gives many bugs which one need to understand. shimla taxi service

  15. Got a good information and thanks for sharing

  16. Nice reading, I love your content. This is really a fantastic and informative post. Keep it up and if you are looking for Job Agencies in Bangalore then visit

  17. Integrated Risk Management provides a comprehensive view of risk across an organization by integrating different risk management functions, enabling organizations to identify, assess, and manage risks in a coordinated and integrated manner.

  18. This blog post truly astounded me! The shared knowledge and advice are unquestionably priceless. I'd want to express my heartfelt appreciation for this wealth of knowledge! asset inventory management software

  19. Senior living marketing involves promoting and raising awareness of senior living communities, services, and care options to older adults, their families, and caregivers. The goal is to attract and engage prospective residents, establish trust, and showcase the benefits and amenities of senior living communities.

  20. Are you planning a group outing, family trip, or corporate event ? Make your journey memorable and hassle-free by hiring a Tempo Traveller from TEMPO TRAVELLER INDIA. We offer a fleet of well-maintained vehicles to cater to all your travel needs.
    Tempo Traveller in Gurgaon
    Tempo Traveller in Ghaziabad
    Tempo Traveller in Noida
    tempo Traveller in Faridabad

  21. In the realm of creativity and aesthetics, the concept of design dimension unfolds as a captivating exploration into the intricate world of spatial design. The term "design dimensiondesign dimension" encapsulates not only the physical measurements and proportions but also the depth and complexity that breathe life into any artistic endeavor.

  22. Unlock the joy of seamless travel in Delhi with our exclusive Tempo Traveller rental services. Say goodbye to transportation woes as you embark on your journey with comfort and style. Our fleet boasts top-notch vehicles equipped with modern amenities, ensuring a smooth and enjoyable ride for you and your companions. From family vacations to group outings, our Tempo Travellers cater to all your travel needs with utmost convenience. Trust us to provide unmatched service and affordable rates, making your Delhi exploration a memorable experience. Contact us now to reserve your Tempo Traveller and embark on a journey filled with unforgettable moments.+919999029051
    Tempo Traveller in Delhi