Home Forums SQL Server 2005 SQL Server 2005 Integration Services File import to table in Unix RE: File import to table in Unix

  • January 12, 2014 at 11:16 am

    #1679453

    If there is no problem,output would be

    C1 C2 C3 C4 C5

    NULLUSD1542.5214536xxxx

    NULL NULL1542.5214536NULL

    EUR NULL 1542.52 14536 xxxx

    Great, that helps.

    Now my question is: why in the above is there a NULL after EUR in row 3?

    That, surely, is a missing column, if the source is

    EUR|1542.52|14536|xxxx

    ?

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.