I've created a DTS that creates and mdb file, creates tables in the mdb fle and then pumps data from the SQL server to the mdb file. When I execute it inside Enterprise Manager it works perfectly. When I schedule the DTS it leaves the mdb file locked.

Is there any setting that I can set for SQLServerAgent to release the mdb file once the DTS has finished successfully.

Thanks,
Lourdes