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 

9 comments:

  1. Awesome blog thanks for sharing While choosing your perfect ride for driving, Accord Cars comes with and the best packages for you to pick from. Self drive cars in Chennai are done the easier. Just pick out your plan from hourly, daily, weekly and even monthly plans available.

    ReplyDelete
  2. Very interesting blog thanks for sharing At Pearl’s - The best Bridal Makeup Parlour in Chennai, we take personal responsibility in making sure that you look as flawless and beautiful and the marriage that you have been dreaming of. With around 16,000 successful brides in our books, you can be confident that we know our art intimately and deep.

    ReplyDelete
  3. Great blog thanks for sharing Looking for the best creative agency to fuel new brand ideas? Adhuntt Media is not just a digital marketing company in chennai. We specialize in revamping your brand identity to drive in best traffic that converts.

    ReplyDelete
  4. Nice blog thanks for sharing Is this a special day for you? Beautiful and fragrant flowers are sure to make it even more amazing of a day no doubt. This is why Karuna Nursery Gardens offers you the best rental plants in Chennai that too at drop dead prices.

    ReplyDelete
  5. Excellent blog thanks for sharing Pixies Beauty Shop is unlike any of the other cosmetic shops in Chennai. With tons of exclusive imported brands to choose from and the best value, this is the best shopping destination for your personal and salon needs.

    ReplyDelete
  6. Awesome blog thankks for sharing 100% virgin Remy Hair Extension in USA, importing from India. Premium and original human hair without joints and bondings. Available in Wigs, Frontal, Wavy, Closure, Bundle, Curly, straight and customized color hairstyles Extensions.

    ReplyDelete
  7. Very useful blog thanks for sharing IndPac India the German technology Packaging and sealing machines in India is the leading manufacturer and exporter of Packing Machines in India.

    ReplyDelete