Update Records in a Table by using OLE DB Command Transformation in SSIS Package - SQL Server Integration Services(SSIS) Tutorial


In this video we will learn How to perform Update Operation in OLE DB Command Transformation in SSIS Package.
We will learn the disadvantages of using OLE DB Command Transformation for Update Operation and what other options we have to perform Update 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 Update statement with Input Parameter for OLE DB Command Transformation
  4. How to map input Columns to OLE DB Command Transformation Parameters for Update Operation


Script used in Video: How to use OLE DB Command Transformation for Update Operation


USE [Test]
GO
--Create Table for Update Records
CREATE TABLE [dbo].[Customer](
    [CustomerID] [int] IDENTITY(1,1) NOT NULL,
    [CustomerName] [varchar](100) NULL,
    [RegionCode] [varchar](100) NULL
)

Select * From [dbo].[Customer]

--Prepare Update Query for OLE DB Command Transformation in SSIS Package
Update dbo.Customer
set RegionCode=?
WHERE CustomerName=?




Update Records in SQL Server Table by using OLE DB Command Transformation in 
SSIS Package



  Related Posts / Videos on OLE DB Command Transformation 


1 comment:

  1. TODAY I GOT MY DESIRED XMAS LOAN AMOUNT $520,000.00 FROM A RELIABLE AND TRUSTED LOAN COMPANY. IF YOU NEED A LOAN NOW EMAIL CONTACT drbenjaminfinance@gmail.com

    Hello, I'm here to testify of how i got my loan from BENJAMIN LOAN FINANCE(drbenjaminfinance@gmail.com) 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: drbenjaminfinance@gmail.com

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

    ReplyDelete