Create a file with Date From SQL Server Table and Send as Attachment in SSIS Package - SQL Server Integration Services(SSIS) Package

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

Expression used in the video
@[$Package::OutputFolder]+"Customer_"+Replace(Substring((DT_WSTR,30)getdate(),1,10),"-","")+".txt"


How to Create a File with Date everyday and Send from an SSIS Package by using Send Mail Task



  Related Posts/Videos on Send Mail Task