unable to send excel file as attachment -- sql server dts

idelsoq NO[at]SPAM gmail.com
5/22/2007 5:57:17 PM

I have this package that exports data to an excel file. At the end of
it I have an On Success workflow leading to a Send Mail task that is
supposed to send the excel file as an attachment. I keep getting a
message saying that the Mail is unable to open file. Apparently the
connection stays open regardless of the on success workflow check,
which prevents the file to be attached.
How can I close the connection before triggering the Send Mail task?

Thanks for the help

Idelso

Bob McClellan
5/23/2007 10:08:04 AM

I had a similiar problem.
My DTS would work fine the 1st time through but would hang the next day
complaining of a lock on the file.

I patched it as opposed to fixing it (for now) by adding
a routine that restarted SQL Server at 5am each morning.

Not sure if this helps but wanted to put it out there for you.
bob.

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server dts

sql server dts : unable to send excel file as attachment