ETL and Data Integration tools - Modern ETL software for everyone

Hello,

One of the first things I check is a simple package I have that executes a report and sends an email with the report attached. The package completes and the email is sent but the report is not attached. I have had this problem with all of the newer versions. The package log states:

Information 5/28/2011 4:10:31 PM Preparing to execute Daily Enrollment Load Summary Report
Information 5/28/2011 4:10:31 PM Package Started
Information 5/28/2011 4:10:31 PM Executing Report: Report-Daily Enrollment Load Summary_1
Information 5/28/2011 4:10:31 PM File: G:\itg\Business Intelligence\ETL\Reports\Daily Enrollment Load Summary_1.pdf
Information 5/28/2011 4:10:53 PM Finished Execution Report
Information 5/28/2011 4:10:53 PM Sending Email: Email Report
Information 5/28/2011 4:10:53 PM To: stevex@me.com
Warning 5/28/2011 4:10:53 PM Attachment 1: "G:\itg\Business Intelligence\ETL\Reports\Daily Enrollment Load Summary_1.pdf" not found

If I go back to the previous version and run the same package, it works great.
I receive the email with the report attached. I can’t determine why this is happening. Any suggestions?

Steve

This might have something to do with the fact that you have spaces in the file name

Try removing double quotes around the file name

Peter

Peter

Thanks. The file name being in quotes was the problem. However, when I created the package and selected the file for the email attachment, the Advanced ETL Processor Pro application put the quotes around my file name.

Version 3.2.0.8 attaches the file to the email regardless if there are quotes or not. It seems like a modification to the new version of the application should be made to either attach the file regardless of the quotes or the application should not put quotes around the file name.

Steve