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 http://sqlage.blogspot.com/2015/04/how-to-use-insert-query-with-parameters.html Check out step by Step SQL Server Integration Services(SSIS) Tutorial by TechBrothers http://www.techbrothersit.com/2014/12/ssis-videos.html