connection thread does not close after tranfer

• bhattpranav

  SSC Eights!

  Points: 831

  More actions

  July 20, 2004 at 9:02 am

  #65211

  Hi Guys!!,

  I am transferring data from .mdb file to sql server db using DTS scheduled task on a daily basis. The job runs successfully, but the connection threads remain open even after job completion. It also generates .ldb files. When I try to delete those files from the drive, it gives me access violation error.

  Can anybody help??

  Thanks

  Pranav

• AJ Ahrens

  SSC-Insane

  Points: 20676

  More actions

  July 20, 2004 at 9:43 am

  #515297

  the .ldb is autocreated by Access when an Access DB is opened.  Sounds like the Access DB is not being closed upon completion of the DTS package.

  I would check the SQL server and see if the Access DB is open the next time this happens and end task on Access and see what happens (last resort).

  Try adding the below into an ActiveX step as the last thing your DTS package calls:

  Function Main()

  Main = DTSTaskExecResult_Success

  End Function

  This may help close the connection....

   

  
  
  Good Hunting!

  AJ Ahrens
  
  
  webmaster@kritter.net