I'm trying to make a DTS package that will export data to an Access 2000 db
then email that db to someone. When it gets to the emailing step, the
package fails with a "MAPI call failed" error. I think I remember reading
something here about a week ago from someone else with the same problem. The
solution was to tell DTS to close the connection when it's done with it (I
think). I can't remember exactly, can't locate that post, and don't see any
settings in the connection properties to set this.
The package will email other files, so I know sql mail is working correctly.
Can anyone help?