I have a Data Transformation Task that loads data into a Spreadsheet. One of the steps includes updating the existing Spreadsheet and emailing several recipients the spreadsheet.

The scheduled Job fails because of the following error: "Error string:  Error sending mail: MAPI error: Could not open attached file."

I have Microsoft outlook 2007 setup as my mail source of email, but no exchange server is being used. Is there a way to link sql server to my existing outlook account? I don't understand why it is doing this as I've had scheduled DTS packages excuted in the past; though that was sql 2000 and i'm now using SQL Server 2005.  Any reference or help is greatly appreciated.

Thanks

 

Simple resolution: if you make a change in the DTS package, you have to remove the old scheduled job and create a new one because the old job is still pointing to the old version of the DTS package and not the updated one. I'm sure Microsoft will fix this in the future, so you don't have to always recreate a scheduled job...well i hope they fix it in the future.