March 30, 2015 at 12:18 am
I have an SSIS package which creates a simple text file then later attaches that file to an email in another SSIS task.
The problem is that the attachment first has to persist to the hard drive. Because of security changes this option is no longer allowed.
I've seen a EXEC msdb.dbo.sp_send_dbmail command line that appears to generate a query and add these results as a file attachment all in one step.
Is something like that possible in SSIS ?
I can't use the sp_send_dbmail because I believe there is an issue with the uni-code/non-unicode output format.
April 1, 2015 at 12:39 am
If the content that you are writing in the text file does not require tabular representation or any indentation, you can use a SSIS variable to store the final resultset and later bind the variable to send an email.
If this is not possible, you will have to use a persistent store such as a database table to store the result and later query your table to extract data bind the result set to downstream tasks
Raunak J
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply