SSIS Tutorial Part 119-Execute SQL Task (Full Result Set) Demo in SSIS Package

SSIS Tutorial Demo Scenario: We have created an SSIS Package to Load the Flat files to SQL Server Table and Archive them after load. But we got this new requirement. The vendors can place multiple files in the Folders but we should not be loading all of them at all. Instead of that the vendor will have access to a table in which they will log the FolderName and FileName those need to be loaded. We need to modify our SSIS Package to load files according to above requirement. In this video you will learn How to Create SQL Server Table to save Folder path and file name information How to use Data Flow Task to Load Flat File to SQL Server Table How to create variables in SSIS Package to hold values returned by Execute SQL Task How to return multiple values with Multiple rows and save that in Object Type variable by using Execute SQL Task How to Loop through Object Type variable in For-each Loop Container to use one row at a time How to write Expressions on Connection managers in SSIS Package Blog post link for the video with scripts http://sqlage.blogspot.com/2015/04/how-to-save-multiple-records-returned.html Check out step by Step SQL Server Integration Services(SSIS) Tutorial by TechBrothers http://www.techbrothersit.com/2014/12/ssis-videos.html