I have a DTS package that uses a st

[megmoo75]

I have a DTS package that uses a stored procedure to get a set of data and puts that data into a new Excel worksheet. Then, I have a VBScript that uses a Word Template to do a mail merge with the Excel file and saves the resulting Word document to the network.

The problem is that DTS seems to be holding a connection to both the Excel file and the Word document. My data pump for the Excel file is set to close upon completion and I am closing the Word object in my vbscript.

Any ideas how to release the connections?

Thank you in advance!

 

[megmoo75]

I ended up using the Quit method which seems to release the hold on Word.