I have a DTS package that transfers data from a SQL 2000 database to an Access 2000 database. I have created a process to loop through a table to pull the Access database location which is set to strFileLocation. The first time through the loop the connection is set properly but it never disconnects. How can I disconnect from the Access database?
Dim oPkg, oExecSQL, sSQLStatement