May 18, 2011 at 12:17 pm
Hi All,
I have a ftp task that downloads multiple files in a forloop container. I have a send email task for each file download that failed to email the error msg and the file that failed.
But i need to modify it and send one email with all the files that failed instead of multiple emails for each failed download file.
I have a variable which stores each file that failed to be downloaded so i need to store all the failed downloads in one variable. The issue i have is the ftp task and the send email task are in the forloop container.
Any help appreciated!
May 18, 2011 at 1:26 pm
sounds like you wanto to Concatenate SSIS Variables?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 18, 2011 at 1:30 pm
That is correct. I might need a script task to do this
May 18, 2011 at 1:55 pm
It is relatively easy to do in a script task.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 18, 2011 at 2:11 pm
Can you provide me with any examples of script task to do this. I am not very experienced with vb coding
May 18, 2011 at 2:23 pm
ArtJC (5/18/2011)
Can you provide me with any examples of script task to do this. I am not very experienced with vb coding
Dts.Variables("gsFileName").Value = sFilePath & sFilePrefix & sDateTimeStamp & sFileSuffix
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply