SSIS Tutorial Part 116-Insert File Names & Record Count in SQL Table after Loading in SSIS Package

SSIS Tutorial Demo 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

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

Blog post link for the video with scripts

Check out step by Step SQL Server Integration Services(SSIS) Tutorial by TechBrothers

[KiranKumar-cclu]

I have a requirement where i need to export my data to a flat file (.csv file) and at the end of the file i need to display the Total no of records

[yambasnet]

from two sources Flat file pull data using marge join after load different two sql table base on record now want to know how Insert File Names & Record Count in SQL Table (Audit table) after Loading in SSIS Package?