DTS package was created in SQL Server 2k. The package runs an ActiveX script to check if a file exists in a directory. If so, it moves the file to a new location, creates the result table from a sql stored proc, exports to excel and then mails the excel attachment to end users. Everythign is working fine with the exception of the Send Mail Task. Whenever I run the package it fails on the send mail and states: Error Sending Mail: Mapi Error: Could not open attached file.
Not sure why it would try to open the attachment?
The creation of the export only allows me to specify a destination of Excel 97-2000 even though i am running 2007 on the server. I can open the attachment on the server without any problems. I can attach other items that were not created by the DTS Package and they are mailed without any error (only seems to be effecting attachments that are created during this process). What could be causing this?
Start Free Trial
