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 10:57 am

    #1679446

    sql crazy kid (1/12/2014)

    Phil Parkin (1/12/2014)

    Columns are not missing here . I have 5 column here ,looks like this.

    [Just a sample data ,but this is the format we load]

    col1 col2 col3 col4 col5

    USD1542.5214536xxxx

    1542.5214536

    EUR 1542.5214536xxxx

    What would this sample data look like if there were no problems with delimiters?

    I am getting output as like below when i do bcp command on unix.

    C1 C2 C3 C4 C5

    USD1542.5214536xxxx

    1542.5214536EUR|1542.52|14536|xxxx

    I understand, but that is not the question I am asking.

    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.