Post reply

DTS Erro while importing data

  • March 4, 2005 at 11:09 am

    #164802

    Hi,

    I have created a DTS package which will import the data from an external csv file. when I'm trying to run the package I'm getting the error "Error Creating Datafile Mapping: The volume for a file has been externally altered so that the opened file is not valied". How could i remove this error? Please let me know.

    Thanks,

    Sridhar!!

  • March 4, 2005 at 12:36 pm

    #545556

    I know that this sounds bizarre but, try turning logging OFF for the package.  Also, make sure that the .CSV has at least a carriage return in it...



    Good Hunting!

    AJ Ahrens


    webmaster@kritter.net

  • March 4, 2005 at 1:18 pm

    #545568

    Hi AJ Ahrens,

    I have worked it out like this. I opened the file and saved it with other name. And when I ran it, it ran without errors.

    I still don't know why the error occured. Thanks for your help.

    Thanks,

    Sridhar!!

  • August 15, 2005 at 12:51 pm

    #582257

    I have the same error.  I am using .DAT files for importing into SQL2000.

    When the Dat file has a length of 0 bytes, I am getting this error.

    Any insight appreciated.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply