Microsoft VBScript runtime error :File already exists in DTS

[Guest GaneshParamasivan]

We have a DTS (Data transformation service ) which is scheduled to execute every 15 minutes ,intermediately DTS is getting failed due to the Microsoft VBScript run-time error but in the next run it is executing successfully

 

 

DTS is designed to generate a new text file and transfer to a specific folder, we have checked the folder when it triggers the error but i couldn't find any duplicate files in the folder

 

 

so can any one help me to fix this issue

 

 

Below is the error DTS triggered

 

 

DTSStep_DTSActiveScriptTask_9, Error = -2147220482 (800403FE) Error string: Error Code: 0 Error Source= Microsoft VBScript runtime error Error Description: File already exists Error on Line 61 Error source: Microsoft Data Transformation Service... Process Exit Code 2. The step failed.

 

Continue reading...