using sql server 2000, sp3
Hi all. I have a DTS package that saves the results of a query to a global variable as a recordset. An ActiveX task then reads through the results of the recorset and writes them to a text file. If I close the recordset object in my vbScript code, I encounter errors when trying to save the package. If I remove the close statement (objRS.Close) from my vbscript code, I can save the package without any problems. Has anyone else run into this? Is there any downside to not closing the recordset in my code?
Hi all. I have a DTS package that saves the results of a query to a global variable as a recordset. An ActiveX task then reads through the results of the recorset and writes them to a text file. If I close the recordset object in my vbScript code, I encounter errors when trying to save the package. If I remove the close statement (objRS.Close) from my vbscript code, I can save the package without any problems. Has anyone else run into this? Is there any downside to not closing the recordset in my code?