Post reply

Error while trying to Bulk Load

  • October 3, 2012 at 9:11 am

    #262499

    Hi all,

    I am using Talend software to move data from COBOL files into SQL Server 2008. For one customer I am getting this error message and cannot figure out what is wrong. this works at many other customer sites and in our development environment. I assume it's something specific with their data, but I cannot see anything wrong.

    I am using Talend to write the data from the COBOL files into a text file located on the C:\drive. I am then using Talend also to do a bulk load of that text file into the SQL Server DB.

    The field separator is ";"

    Row Separator is ""

    Code Page "RAW"

    Here is the error message I get...

    : Bulk load data conversion error (type mismatch or invalid

    character for the specified codepage) for row 20336, column 9 (UnitWeight)

    and here is the specific row 20336 in the text file.

    20630;1;S;;C;;FT-1.315X.047;1 3/8 X .047 ALLIED FT SW (CUT 1/2;364PC @10'6");0.628467;182;PCS;182;;3822;669;21';;252;;182;FT;;252;;0.2946;;R;;;FT;;;;;0.47;FT;1796.34;FT;2402;1125.9612;N

    The Unit Weight field is the 0.628467. I tried to load just the one row into their SQL DB and it loaded fine, but when I try Bulk Load the entire file, it errors out every time with the same row, 20336.

    Any help I can get would be great, this customer has been waiting for awhile to get this fixed.

    thanks!

  • October 3, 2012 at 10:33 am

    #1545055

    How to effectively ask for help[/url]

    going to need more details and context here, browse the link above and repost when you get a chance.


    SQL Tips and Scripts
    SQLWorks Blog

  • October 3, 2012 at 4:19 pm

    #1545256

    adiehl (10/3/2012)

    Hi all,

    I am using Talend software to move data from COBOL files into SQL Server 2008. For one customer I am getting this error message and cannot figure out what is wrong. this works at many other customer sites and in our development environment. I assume it's something specific with their data, but I cannot see anything wrong.

    I am using Talend to write the data from the COBOL files into a text file located on the C:\drive. I am then using Talend also to do a bulk load of that text file into the SQL Server DB.

    The field separator is ";"

    Row Separator is ""

    Code Page "RAW"

    Here is the error message I get...

    : Bulk load data conversion error (type mismatch or invalid

    character for the specified codepage) for row 20336, column 9 (UnitWeight)

    and here is the specific row 20336 in the text file.

    20630;1;S;;C;;FT-1.315X.047;1 3/8 X .047 ALLIED FT SW (CUT 1/2;364PC @10'6");0.628467;182;PCS;182;;3822;669;21';;252;;182;FT;;252;;0.2946;;R;;;FT;;;;;0.47;FT;1796.34;FT;2402;1125.9612;N

    The Unit Weight field is the 0.628467. I tried to load just the one row into their SQL DB and it loaded fine, but when I try Bulk Load the entire file, it errors out every time with the same row, 20336.

    Any help I can get would be great, this customer has been waiting for awhile to get this fixed.

    thanks!

    So according to what you posted, column 8 should look like the following, correct?

    1 3/8 X .047 ALLIED FT SW (CUT 1/2;364PC @10'6")

    Do you see any special characters in that data that might make things go haywire for you?

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

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

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