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  

• Create Load Summary Email logic in SSIS Package
• How to Configure Send Mail Task and Send Email in SSIS Package
• Attach Multiple Files Dynamically in Send Mail Task in SSIS Package
• Send Error Email with Error Code, Error Description by using Send Mail Task in SSIS Package 
• Send List of Files from A Folder as Email by using Send Mail Task
• Use Send Mail Task with Precedence Constraints in SSIS Package
• Read Subject,Recipient and Body from SQL Server Table and Send Email by Using Send Mail Task 
• Read EmailTo,EmailFrom,Subject and Body From Text File and Send Emails by using Send Mail Task in SSIS Package
• Send Load Summary Email by using Send Mail Task in SSIS Package