ametuer999
asked on
Attachments for msdb.dbo.sp_send_dbmail
two csv files are generated from SSIS package ,dynamically named,which are assigned two variables.I am trying to email them using msdb.dbo.sp_send_dbmail in a sql execute task..but i could do only one attachment...how to attach multiple files to msdb.dbo.sp_send_dbmail using variables..
ASKER
I tried it like..@file_attachments = @attachment;@attachment1
But no use..
But no use..
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
THANKS A LOT...!
Delimit the filenames with a semicolon.
/peter