I am having an issue with exporting a multiple sheet workbook created through
the DTS wizard, and getting it to attach to an email.

The DTS will export successfully. When it comes to the send mail function,
I receive an error associated with the file is not at the location specified.
The file is there, however, it cannot be accessed because the Jet driver has
the file opened exclusively.

Once the process has failed, I can go back to the DTS and execute the send
mail function and it works successfully.

It does not matter if I am using my desktop or the SQL server console.

I need to know how to close the connection in order to send.

I am using SQL Server 2000 SP3.

Thanks, Brad

Hi Brad,

"Brad Scott" wrote:
there is a workflow property of the transform task that lets the connection
close on completion.
When you use the wizard to create an export, this option is disabled by
default, because there can be independent exports to the same connection.
To solve this, you have to define a workflow for the exports, and define
the close connection option for the last export transform task.

Helge

On the workflow properties of the DataPump task there is a "Close
Connection On Completion" option.

If you check that dos it work?

If not and running this as a scheduled job then simply create another
step after the export and use that to do the sending of the mail

Allan

"Brad Scott" <BradScott (AT) discussions (DOT) microsoft.com> wrote

Thanks, Brad.

"Allan Mitchell" wrote: