How to Call a Stored Procedure in OLE DB Command Transformation with Input Parameters in SSIS Package - SQL Server Integration Services(SSIS) Tutorial

In this video we will be learning how to use a Stored Procedure with input parameters in OLE DB Command Transformation in SSIS Package.

We will be learning below Items in this video

1. How to Create an SSIS Package 
2. How to Read Flat File Data by using Data Flow Task
3. How to Create a Stored Procedure with Input Parameters
4. How to call a Stored Procedure in OLE DB Command Transformation in Data Flow Task
5. How to Map the Input Columns to Stored Procedure Parameters in OLE DB Command Transformation
6. What are the Advantages of using Stored Procedure instead of using a Query with Parameter in OLE DB Command Transformation

Script used in this video to Create Stored Procedure with input parameters for OLE DB Command Transformation.

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]

Create procedure dbo.DeleteCustomer
@CustomerName VARCHAR(100),
@RegionCD VARCHAR(100)
AS
BEGIN
Delete from [dbo].[Customer]
where customerName=@CustomerName
and RegionCode=@RegionCD
END

EXEC dbo.DeleteCustomer ?,?

How to Call a Stored Procedure in OLE DB Command Transformation with Input Parameters in SSIS Package

  Related Posts / Videos on OLE DB Command Transformation 

• Introduction to OLE DB Command Transformation( Perform Update/Delete)
• How to use Stored Procedure Output Parameter in OLE DB Command Transformation in SSIS Package?
• OLE DB Command Transformation - Insert Operation Demo
• OLE DB Command Transformation - Delete Operation Demo
• OLE DB Command Transformation - Update Operation Demo
• OLE DB Command Transformation - Use Sub Query with Parameters in OLE DB Command Transformation to update records in a Table
• OLE DB Command Transformation ( Use Common Table Expressions to Delete Duplicate Records in OLE DB Command Transformation with Input Parameters)
• OLE DB Command Transformation ( How to Call Multiple Stored Procedure with input parameters in OLE DB Command Transformation in SSIS Package)
• OLE DB Command Transformation ( How to Run Multiple Statements Update/Insert/Delete with parameters in OLE DB Command Transformation in SSIS Package)
• OLE DB Command Transformation ( How to build Dynamic SQLCommand for OLE DB Command Transformation in SSIS Package)