ssis

SQL Output to an Email Attachment
This is a quick example of how to take the output of a sql query and email it to someone. The above image shows a few of the pieces. �Create a variable, in this case filename . �You then open the properties editor for the sendmail task. �You select fileAttachments �and link the variable. �This will send the text file you create as an attachment. �Now we go to the DataFlow �task to see how to connect the output of your sql to that same textfile. You create a DataReader