Home Forums SQL Server 2005 SQL Server 2005 Integration Services loading data from SQL 2008 to AS400 - getting error, please help! RE: loading data from SQL 2008 to AS400 - getting error, please help!

  • April 28, 2010 at 7:41 am

    #1158914

    Mh-397891 (4/9/2010)

    We are using ADO net connection for both SQL 2008 and AS400,

    when I am trying to insert all the data from the sql 2008 table(about 66k rows), only about 44 rows are getting inserted into the AS400 file and then it errors out with below error:

    [ADO NET Destination [457]] Error: An exception has occurred during data insertion,

    the message returned from the provider is:

    ERROR [07002] [IBM][iSeries Access ODBC Driver]Wrong number of parameters.

    This looks like buggy IBM ODBC driver. I have one suggestion to try, but it requires third-party commercial component. I'm talking about CozyRoc's ODBC Destination component. It supports both regular and bulk-load insert.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/