How to Use Insert Query with Parameters in Execute SQL Task (Log File Names with Record Count) in SSIS Package - SQL Server Integration Services Tutorial

Scenario:

The demo " How to Load File Name and Record Count after loading each file to SQL Server Table".  To tell you more details about scenario, you can think of getting multiple files during the day. You want to create an SSIS Package that loads the file/s and then log file name, record loaded and time to the dbo.FileLoadInformation Table.

In this video we will learn how to use Insert Query with Parameters in Execute SQL Task. We will be learning following items


  1. How to Create an SSIS Package
  2. How to Load Data From Flat File to SQL Server Table
  3. How to use For-each Loop Container to Loop through set of Flat Files
  4. How to use Row Count Transformation in SSIS Package
  5. How to use Execute SQL Task in SSIS Package to insert variable values to a Table




How to use Insert Query in Execute SQL Task with 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