Email Out PDF Report
I am updating several SSIS packages. One of them contains a script task that first creates an Access table containing all of the data, then it creates several new PDF reports that are based on the customer names, and it adds the date the package was run to the file name. PDF FILE NAME EX:Chase-1-2-2011, Ford-1-4-2012 I already have the code for all of that but I am looking for a way to email the resulting PDF report as an attachment. I can't just add it as an attachment as the name changes everytime it is run. Any suggestions? I am new to VB so please dont complicate the soution too much. Thanks!
July 30th, 2012 2:53pm

Use the Send Mail Task with the parametrized path to the the attachment. You may choose to use a variable to set it up. Read more here: http://blogs.msdn.com/b/sqlblog/archive/2011/06/14/sending-several-files-to-several-individuals-using-ssis-send-email-task.aspxArthur My Blog
Free Windows Admin Tool Kit Click here and download it now
July 30th, 2012 3:55pm

I followed the steps in the directions you gave, and the package ran but it does not look like the script task actually ran. I am not sure why. Also the email was sent out but the attachments were not included. Everything is working except the attachments.
August 2nd, 2012 8:30am

The link that ArthurZ shared is pretty much it. If everything is working fine then double check every thing, including "For each loop Container" settings if: 1 - "Folder" path is correct 2 - "Files" field has proper wild card such as "*.pdf" 3 - "Retrieve File Name" is set to fully qualified. Also check the step 20 of the link, where you set the variable to the "FileAttachments" property of "Send Mail Taks".Please mark the post as answered if it answers your question
Free Windows Admin Tool Kit Click here and download it now
August 2nd, 2012 8:53am

It is up and running now the link was very helpful Thank you
August 2nd, 2012 11:18am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics