How to Run multiple Stored Procedure in Execute SQL Task with Input Parameters - SQL Server Integration Services(SSIS) Tutorial

In this video we will learn how to run Multiple Stored Procedures in single Execute SQL Task and map their parameters to different variables.

You will be able to learn following Items from this video
  1. How to create an SSIS Package from Scratch
  2. How to create variables in SSIS Package
  3. How to create Sample Stored Procedures with input parameters
  4. How to map Stored Procedures input Parameters to variables in Execute SQL Task


Script to Create Sample Stored Procedures with Input Parameters

use Test
go
--drop table [dbo].[Customer]
CREATE TABLE [dbo].[Customer](
    [CustomerID] [int] identity(1,1),
    [CustomerName] [varchar](100) NULL,
    [RegionCode] [varchar](100) NULL
)

Select * from [dbo].[Customer]


Create procedure dbo.InsertCustomer_EU
@RegionCode VARCHAR(100)
as
BEGIN
Insert into dbo.Customer ( CustomerName,RegionCode)
values ('Aamir',@RegionCode)
end


Create procedure dbo.InsertCustomer_NA
@RegionCode VARCHAR(100)
as
BEGIN
Insert into dbo.Customer ( CustomerName,RegionCode)
values ('Aamir',@RegionCode)
end




Execute Multiple Stored Procedure in Execute SQL Task with Input Parameters in SSIS Package



 Related Posts / Videos on Execute SQL Task 

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