Post reply

Load table in AS400 using SSIS

  • May 12, 2009 at 3:18 pm

    #130850

    I am using SSIS to load table in AS400. Its just a few columns one to one mapping. While loading the table I am getting following error: I even tried to cast each source field to varchar before loading to AS400 table but still getting this error. Can anybody please help?

    Microsoft DB2 OLE DB Provider" Hresult: 0x80040E14 Description: "Character in CAST argument not valid. SQLSTATE: 22018, SQLCODE: -420"

  • May 12, 2009 at 7:23 pm

    #993373

    Just a shot in the dark...try nvarchar()?

  • May 13, 2009 at 6:37 am

    #993629

    Can you post the code you are using?

    Jack Corbett
    Consultant - Straight Path Solutions
    Check out these links on how to get faster and more accurate answers:
    Forum Etiquette: How to post data/code on a forum to get the best help
    Need an Answer? Actually, No ... You Need a Question

  • May 15, 2009 at 2:02 pm

    #995661

    Ok...Connection is made...Mapping done between SSIS and AS400...package runs sucessfully..In the debug mode, it shows there were about 17 records inserted...But I am getting a warning

    "[OLE DB Destination [16]] Warning: Cannot retrieve the column code page info from the OLE DB provider. If the component supports the "DefaultCodePage" property, the code page from that property will be used. Change the value of the property if the current string code page values are incorrect. If the component does not support the property, the code page from the component's locale ID will be used. "

    And the following message: [DTS.Pipeline] Information: "component "OLE DB Destination" (16)" wrote 0 rows.

    Nothing got written at destination....

    Can anybody help?

    Thanks a lot.

  • May 18, 2009 at 8:54 am

    #996399

    Any suggestions or advise I can use?

  • December 9, 2011 at 6:28 am

    #1419265

    SSC Journeyman, here is how you can get rid of the warning message. On the OLE DB Destination that maps data to the as/400 do the following.

    Right click and select advanced editor

    go into component properties

    scroll down to "AlwaysUseDefaultCodePage" and set it to "True"

Viewing 6 posts - 1 through 5 (of 5 total)

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