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:28 am

    #1679455

    Phil Parkin (1/12/2014)

    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

    ?

    Thanks for getting into deeper

    Few of the rows , first column coming as empty . But do you think in SSIS or Excel this will be a issue as there is a column delimiter to treat the 1st column as empty.