I have created a DTS package the exports information to an Excel
Spreadsheet. The last task is an Outlook task but I get a mapi error, could
not open the attached file. If I run Outlook Task in another DTS, it's
fine. I tried using xp_sendmail but is expecting parameter @user which
isn't part of the parameters for xp_sendmail. People in the forum suggest
using active X. What are the commands for sending a attachment using active
X or is there something I can fix in my previous 2 attempts?

Thanks
Mike

perhaps the connection to the Excel file is still open. Look in the
Workflow properties of the datapump to task to close it.

--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"Mike" <mdunlap (AT) nospam (DOT) com> wrote

Thanks

I would have never found that. Spent 8 hours trying different things, sent
an email to the newsgroup and get an answer in 45 minutes

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote