DSXchange

Hi,

I want to attach a file in mail which I am sending from Datastage.I am using DSsendmail Routine.
There When I am explicitly giving Attached file path then the file is going in mail.
But when I am using Parameter in file path it is showing Cannot open file.

Arg:

"From:me@here\nTo:you@there\nSubject:Hi ya\nAttach:test/reject/AFile.txt\nBody:Line1"

when I am giving this the file is attached with mail,

But when I am giving the Argument in below foramts it is showning error Cannot open file

"From:me@here\nTo:you@there\nSubject:Hi ya\nAttach:$para_Rej/AFile.txt\nBody:Line1"

"From:me@here\nTo:you@there\nSubject:Hi ya\nAttach:#$para_Rej#/AFile.txt\nBody:Line1"

Can't it be parameterized.

Please suggest.

Thanks
Shaonli

Sorry the job is Parallel

I have also tried and failed to pass parameters in the fields From and To Addresses to DSSendmailTester Routine Activity and I feel that it can't be parameterized.

In case of notification stage also..viewtopic.php?t=121727

shaonli wrote:Sorry the job is Parallel

Sorry, the job is Sequence.

I've had no issues using Job Parameters in the Notification Activity for either email address, the subject nor the attachment, all happily support them. As noted and AFAIK the body doesn't but it's been a long time since I've tried that.

Your problem is the fact that you are passing in a literal string so none of your parameters get resolved. You can build the string outside of the call itself, concatenating the strings to the parameters so the resolved values get incorporated into the final string.

Yes it has been possible by passing paramter outside DSsend Mail routine.The Argument is passed from Unix script.
in the argument if routine I am giving that value as Command Output.

So it has been possible to parameterized.

Thanks a lot..
Shaonli

Yes it has been possible by passing paramter outside DSsend Mail routine.The Argument is passed from Unix script.
in the argument if routine I am giving that value as Command Output.

So it has been possible to parameterized.

Thanks a lot..
Shaonli