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


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


USE [Test]
GO

CREATE TABLE [dbo].[Customer](
    [CustomerID] [int] IDENTITY(1,1) NOT NULL,
    [CustomerName] [varchar](100) NULL,
    [RegionCode] [varchar](100) NULL
)

Select * From [dbo].[Customer]


Delete from [dbo].[Customer]
where customerNAme=?
and REgionCode=?



Delete Records from a Table by using OLE DB Command Transformation in Data Flow Task in SSIS Package



  Related Posts / Videos on OLE DB Command Transformation