Post reply

DTS import error

  • May 17, 2004 at 9:10 am

    #59708

    Hi!

    I am trying to import a flat file into a table using the wizard.It is in fixed field format. I am able to go as far as "Select File Format" screen. When I choose the Fixed Field format it gives me an error "Could not find selected row delimiter.Is the selected row delimiter valid?"  What does this error mean? It is ANSI file type. Any help is greatly appreciated.

    Thanks in advance.

    Shree

     

     

  • May 17, 2004 at 1:20 pm

    #506692

    Try selecting <none> from the row delimiter dropdown box.

     

    Greg

    Greg

  • May 17, 2004 at 1:46 pm

    #506696

    I tried that but I am still getting the same error. Is there any other way for me to clean the txt file before I bring it in using DTS?

    Thanks

  • May 18, 2004 at 6:55 am

    #506773

    Did the file come from a non-Windows platform? If it came from Windows the row delimiter should be CRLF, if non-Windows (particularly Unix) it is most likely CR. You can check this with any editor or file browser that supports a hex view of the data. We use Ultraedit, but it isn't free. There are a few free utilities on the net that you should be able to find through Google or CNET Downloads that will let you look at the file to determine the appropriate row delimiter.

     

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

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