Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Posts
    1

    Question Unanswered: dtsrun: datafile mapping error

    Hi need lots of help here.

    I have a dts package scheduled to run hourly as job since recent November. (Win2000 server, MSSQL2000 standard)
    Its been running fine, except last few days, SQL Agent shows it attempted to run it but fails
    Checking the history for the job i got this error message each time:
    ================================================== ======
    DTSRun: Executing... DTSRun OnStart: DTSStep_DTSDataPumpTask_2
    DTSRun OnError: DTSStep_DTSDataPumpTask_2,
    Error = -2147467259 (80004005) Error string: Error creating datafile
    mapping: The volume for a file has been externally altered so that the
    opened file is no longer valid.
    Error source: Microsoft Data Transformation Services Flat File Rowset
    Provider Help file: DTSFFile.hlp Help context: 0 Error
    Detail Records:
    Error: 1006 (3EE); Provider Error: 1006 (3EE) Error string: Error
    creating datafile mapping: The volume for a file has been externally altered
    so that the opened file is no longer valid.
    Error source: Microsoft Data Transformation Services Flat File Rowset
    Provider Help file: DTSFFile.hlp Help context: 0 DTSRun
    OnFinish: DTSStep_DTSDataPumpTask_2 DTSRun: Package execution complete.
    Process Exit Code 1. The step failed.
    =================================================

    The key information i think would be these few lines:
    Error creating datafile mapping: The volume for a file has been externally altered so that the opened file is no longer valid.

    I don't think its SQL Agent as its scheduling is running other jobs fine(backup)
    The DTS package runs fine manually.
    Such i suspect dtsrun.exe itself. But where do i go from here?

    Thks.

  2. #2
    Join Date
    Nov 2011
    Posts
    1

    Cool

    Hi

    The Csv or text file you are trying to access in the DTS must be empty. The empty file will cause this error.

    Hope this helps

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •