• Hi Timothy,

    I have checked with the help of DBA for both SQL Agent a/c & my personal a/c. DTS is running fine whenever i am running it manually by clicking "Execute" option. But getting error when i am scheduling it as a job

    See the error message --

    The job failed. The Job was invoked by User IUSER\602336842. The last step to run was step 1 (ISDN30 - VDMT Extract Generation 1 2).

    Executed as user: IUSER\BTIS0402. DTSRun: Loading... Error: -2147024816 (80070050); Provider Error: 0 (0) Error string: The file exists. Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 713. Process Exit Code 1. The step failed.

    What could be the possible for this?