Page 1 of 1

Sending Multiple Attachment from Notification Activity

Posted: Fri Aug 13, 2010 10:48 am
by arnabbora
Hi,
I am trying to send two attachments from my Notification Activity from inside my job sequence.
But the problem I am facing is that I am able to send only one attachment, It is sending only the first file. For the second one it is saying
"WARNING - MISSING ATTACHMENT: Cannot open attachment file" .But the file is present in the specified path. I am separating the files by a comma(,).
If I use space or semicolon to separate the attachment files then it is sending none of the files.

If I interchange the position of the two files, than again the first one it is sending but not the second one.

Could any body please help me on this.
I hope sending multiple attachment is possible through Datastage Notification Activity.


Thanks in advance,
Arnab

Posted: Fri Aug 13, 2010 12:37 pm
by chulett
Not sure that is supported, we would always zip any files to be sent so we could send it out with a single attachment. :?

Posted: Fri Aug 13, 2010 12:52 pm
by kris007
Sending multiple attachments from a single Email Notification Activity is not supported.

Posted: Fri Aug 13, 2010 10:11 pm
by arnabbora
Thanks Craig and Kris.
If it is not supported, then I will create a single file and then send as a single attachment.

Regards,
Arnab

Posted: Fri Sep 10, 2010 12:59 pm
by phonseau
You can create another notification activity with the second file as the attachment. If the user doesn't mind getting two e-mails.

Posted: Wed Sep 15, 2010 1:24 pm
by phonseau
It is supported. You need to separate each file path by comma. I tried it and it works..
e.g
/opt/IBM/~/data/XXFile.csv,/opt/IBM/I~/data/SupplierMatchedFile.csv

hope it helps!

Posted: Wed Sep 15, 2010 3:05 pm
by chulett
They noted that they've already tried that and had issues. From what I recall, it can depend on your platform and mail server, they don't all work the same way. Some want a comma between the files names, some want a "comma space" and I believe I had one where it took a semi-colon. Still, zipping up everything and sending a single attachment (regardless) was what most of my clients seemed to prefer.

Posted: Thu Dec 08, 2011 11:45 am
by pandeesh
Craig,

Do you remember the platforms which support multiple attachments.(like separated by comma or comma space)?

thanks

Posted: Fri Dec 09, 2011 7:13 am
by chulett
I don't recall one that doesn't, it was just a matter of figuring out how it wanted them to look.

Posted: Fri Nov 30, 2012 3:24 pm
by drexeljoe
I had this same issue and after reading phonseau's suggestion I realized that the root cause was that I initially had a space after the commma separating the filepaths. Removing the space corrected the issue. This is on DataStage 8.7

Causes Error:

Code: Select all

/home/dsuser/File1, /home/dsuser/File2
Sends both attachments succesfully:

Code: Select all

/home/dsuser/File1,/home/dsuser/File2