Hi,

Thanks for your reply. its source file. so its not opened by filesystemobject. the file operation will be handled by the DTS itself. only in some situation its not releasing...

Hi Carter,

If that is the case what you mentioned, it should fail all the time when it runs right? but when i rerun the process, its working fine....

Thank you very much

Hi Michael,

here is the query and code i have used. pls let me know

Query:

SELECT Name FROM emp WHERE (Sal = ?)

DTSLookups:

Dim myName

Set myName = ...