SSIS Tutorial Part 83-Create file with Date From SQL Server Table & Send as Attachment SSIS Package

SSIS Video Scenario: We need to create a file with Date on daily basis and then send to our client in email by using SSIS Package. Solution: In this video we will learn how to solve above scenario, we will learn following components How to create Parameters in SSIS Package How to use Data Flow Task and read data from SQL Server Table and load to Flat file How to write expression to create file with Date How to use expression on Flat file Connection Manager in SSIS Package How to Send a file as attachment by using Send Mail Task in SSIS Package How to use Expressions in Send Mail Task in SSIS Package Link to blog post for expressions used in the video http://sqlage.blogspot.com/2015/06/create-file-with-date-from-sql-server.html To follow Step by Step SQL Server Integration Services(SSIS) Video Tutorial By TechBrothers, please open below link. http://www.techbrothersit.com/2014/12/ssis-videos.html