SSIS Tutorial Part 133-Load Text Files,Zip them to Zip File with DateTime & Delete in SSIS Package- скачать в хорошем качестве

SSIS Tutorial Part 133-Load Text Files,Zip them to Zip File with DateTime & Delete in SSIS Package-

SSIS Video Scenario: We get text files in our Input Folder and we need to run our SSIS Package multiple times a day and load those files to table/s and then zip those files in a file with datetime in Archive Folder. Here are the items you will learn in this video How to read multiple Text files with same metadata and load to SQL Server Table, we will make use of Foreach Loop Container to loop through files How to Create Package Parameters in SSIS Package for Input Folder and Archive folder path How to use Package Parameters in Script Task How to change .NET Framework in Script task from 4 to 4.5 so we can use ZipFile Class How to Add reference to Assembly System.IO.Compression.FileSystem How to Zip the Files to folder with Datetime and then delete them from input Folder in Script Task Blog post link for the Scripts used in this video http://sqlage.blogspot.com/2015/06/lo... Check out step by Step SQL Server Integration Services(SSIS) Tutorial by TechBrothers http://www.techbrothersit.com/2014/12...