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 

25 comments:

  1. Replies
    1. IEEE Final Year Project centers make amazing deep learning final year projects ideas for final year students Final Year Projects for CSE to training and develop their deep learning experience and talents.

      IEEE Final Year projects Project Centers in India are consistently sought after. Final Year Students Projects take a shot at them to improve their aptitudes, while specialists like the enjoyment in interfering with innovation.

      corporate training in chennai corporate training in chennai

      corporate training companies in india corporate training companies in india

      corporate training companies in chennai corporate training companies in chennai

      I have read your blog its very attractive and impressive. I like it your blog. Digital Marketing Company in Chennai

      Delete
  2. 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
  3. 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
  4. 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
  5. 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
  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
  8. Thanks for the interesting blog that you have implemented here. Very helpful and innovative. Waiting for your next upcoming article.
    Java training in chennai
    Java training institute in chennai
    Java course in chennai
    Java training classes
    Java training
    Java programming classes
    core java coure
    <a

    ReplyDelete

  9. It is amazing and wonderful to visit your site.Thanks for sharing this information,this is useful to me...
    http://chennaitraining.in/sap-rem-training-in-chennai/
    http://chennaitraining.in/sap-scm-training-in-chennai/
    http://chennaitraining.in/sap-sd-training-in-chennai/
    http://chennaitraining.in/sap-sm-training-in-chennai/
    http://chennaitraining.in/sap-srm-training-in-chennai/
    http://chennaitraining.in/sap-success-factor-training-in-chennai/
    http://chennaitraining.in/sap-tr-training-in-chennai/
    http://chennaitraining.in/sap-wf-training-in-chennai/

    ReplyDelete
  10. Thanks for the informative article About Java. This is one of the best resources I have found in quite some time. Nicely written and great info. I really cannot thank you enough for sharing.
    Java training in chennai | Java training in annanagar | Java training in omr | Java training in porur | Java training in tambaram | Java training in velachery

    ReplyDelete
  11. Also, there is nothing ethically wrong in attempting to tap clients for conceivable future dealings with an organization that is as of now offering great administrations to clients. There is no component of impulse or power connected to it. 24 hour call center

    ReplyDelete
  12. The student will need to be convinced that what he is doing is good in order to complete the course as well and as quickly as he can. machine learning training in hyderabad

    ReplyDelete
  13. I have bookmarked your website because this site contains valuable information in it. I am really happy with articles quality and presentation. Thanks a lot for keeping great stuff. I am very much thankful for this site. outsourcing call center

    ReplyDelete
  14. The website is looking bit flashy and it catches the visitors eyes. Design is pretty simple and a good user friendly interface. outsourcing services

    ReplyDelete
  15. Thanks for sharing we run a Facebook marketing agency, to stay connected in a huge global market place, serving to compete for the best social media marketing companies in Chennai.

    ReplyDelete
  16. 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
  17. Hello Everyone,

    Welcome to the future! Financing made easy with Prof. Mrs. DOROTHY LOAN INVESTMENTS

    Have you been looking for financing options for your new business plans, Are you seeking for a loan to expand your existing business, Do you find yourself in a bit of trouble with unpaid bills and you don’t know which way to go or where to turn to? Have you been turned down by your banks? MRS. DOROTHY LOAN INVESTMENTS says YES when your banks say NO. Contact us as we offer financial services at a low and affordable interest rate of 2% for long and short term loans. Interested applicants should contact us for further loan acquisition procedures via profdorothyinvestments@gmail.com

    Services rendered include:

    * Refinancing Loans
    * Car Loan
    * Truck Loans
    * COVID-19 Financing Loan
    * Home Loan
    * Mortgage Loan
    * Debt Consolidation Loan
    * Farm Loan
    * Business Loan [secure and unsecured]
    * Personal Loan [secure and unsecured]
    * Students Loan and so many others.

    For more info; Contact us via Email: profdorothyinvestments@gmail.com

    With Prof. Mrs. DOROTHY LOAN INVESTMENTS. you can say goodbye to all your financial crisis and difficulties as we are certified, trustworthy, reliable, efficient, fast and dynamic

    ReplyDelete
  18. You completed certain reliable points there.
    I did a search on the subject and found nearly all persons will agree with your blog.

    360DigiTMG data scientist course


    ReplyDelete