ActiveX file infrequent copy failure when running as job

• Tania Davies

  SSC Journeyman

  Points: 98

  More actions

  January 30, 2007 at 9:04 pm

  #171198

  Hi,

  Please can anyone help me with an error I am getting when copying large .csv files (some are over 2Gb) from one folder on the server to another using activeX in a DTS.

  I am using

    oFSO.copyFile strDownLoadPath & strInFileNameDate, strProcessingPath & stroutFileNamedate

  The copy runs fine within the DTS but it fails infrequently when running as a job.  It manages to copy some files out of the 15 but fails part way through.  It does not always fail on the same file.  I am only getting the following error from the job which is not very helpful.

  DTSStep_DTSActiveScriptTask_3   DTSRun OnError:  DTSStep_DTSActiveScriptTask_3, Error = -2147220482 (800403FE)      Error string:  ActiveX Scripting encountered a Run Time Error during the execution of the script.      Error source:  Microsoft Data T...  Process Exit Code 1.  The step failed.

  The  only ways I have found to start this working again once it happens is to reboot the server or by sometimes waiting several hours.  Then it can work again for weeks or a few days.

  I would be extremely grateful if someone could guide me with this problem.

   

• DiMac

  SSC Veteran

  Points: 215

  More actions

  January 30, 2007 at 9:48 pm

  #686709

  No, the error codes from DTS are not helpful at all...

  I would look at some things:

  **What other processes are running on each server at the time the job is run?

  **Is other process trying to gain access to the folder at the same time the job is run?

  **Did the package work fine at one time, but now you are having problems? If so, what has changed?

  **When the package fails, do you try to copy over the files manually?

  **Is the ActiveX task doing anything else but copying over the files?

  DTS errors can be a real headache...I feel your pain.

  ---

  Cheers,

  Diane
  

• Tania Davies

  SSC Journeyman

  Points: 98

  More actions

  January 30, 2007 at 9:58 pm

  #686716

  Thanks for your help.  Yes it is a real headache trying to figure out what is causing the issue.

  I have checked these areas.

  --There are no other processes running at the time or trying to gain access to the folder.

  --Nothing has changed in the DTS recently and as soon as we have done a reboot or we wait for a few hours the same DTS runs ok from the job.

  --The copy runs ok manually and so does running the DTS manually (using the server name in the path).

  --The Activex includes a loop for the file copy with nothing else in and it gets through it normally about 5 times before it fails but this can vary.