December 21, 2010 at 11:23 am
Greetings. I have a send mail task that sends status information at the completion of my package. Previously it sent the input file as a file attachment. The file name is in a package variable. I am now enhancing the package to also include a reject file. I would like to attach this file to the same status email message.
The original attachment expression contained this:
@[CFG::FlatFileLocation]
My new one was created like this, based on some troubleshooting I did to get the format correct:
@[CFG::FlatFileLocation] + ";" + @[CFG::RejectFileLocation]
However, when I execute the package I receive the following error:
[Send Mail Task] Error: Either the file "F:\GSIS\Ftp_Incoming\INC_ACN_DBT_MEMO ; F:\GSIS\Errors\FlatFile_OpenDebitMemo_Rejects.csv" does not exist or you do not have permissions to access the file.
Both files exist and are accessible. I have been searching for awhile for a solution for this so if anyone has any ideas I would appreciate hearing them.
Thanks!!
-Helen
December 21, 2010 at 11:52 am
I found out after I posted this that the expression wants a pipe ( | ) as the delimiter. That appears to have worked.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply