Post reply

Import txt file with first character of each row is ''NUL'' - DTS

  • April 20, 2007 at 8:43 am

    #116722

    SQL 2000

    Hi All,

    I have a txt file to import. The first character of each line is 'NUL' - ASCII 0 00

    Does anyone know how I can go about getting SQL (DTS) to reconise this? The only way I have managed to do it is to physically find and replace it to another character (1), then importing it is no problem, otherwise SQL does not reconise this character and therefore does not see any of the data.

    Any help will be greatly appreciated.

    Michael

     

  • April 20, 2007 at 9:42 am

    #701764

    NUL chars will cause errors in DTS when you try to configure Text File. NUL is not settable as a delimiter and it will terminate reads as well.

    Your only option is to translate the data as you suggested.

    You could use an ActiveX task prior to the transformation task and use FileSystemObject to read FileA, convert NUL chars and write FileB, then use FileB in the transformation task.

    Far away is close at hand in the images of elsewhere.
    Anon.

  • April 20, 2007 at 9:59 am

    #701767

    Hi David,

    Thank you so much for the input, I am now much clearer on what the problem is.

    Much appreciated.

    Michael

     

     

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

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