Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

loading data from SQL 2008 to AS400 - getting error, please help! Expand / Collapse
Author
Message
Posted Friday, April 9, 2010 4:20 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, July 16, 2013 2:48 PM
Points: 262, Visits: 1,503
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.
Post #900880
Posted Sunday, April 11, 2010 3:26 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, July 16, 2013 2:48 PM
Points: 262, Visits: 1,503
How to trouble shoot where the problem is? Any ideas. Thanks.
Post #901305
Posted Tuesday, April 27, 2010 9:52 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, July 16, 2013 2:48 PM
Points: 262, Visits: 1,503
Any body can help on this, I need this urgently. Thanks!!
Post #911254
Posted Tuesday, April 27, 2010 9:56 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 11:32 AM
Points: 5,257, Visits: 12,185
Mh-397891 (4/11/2010)
How to trouble shoot where the problem is? Any ideas. Thanks.


Check the source data in row 45. There must be something 'different' in it which is causing the error ...



Help us to help you. For better, quicker and more-focused answers to your questions, consider following the advice in this link.

When you ask a question (and please do ask a question: "My T-SQL does not work" just doesn't cut it), please provide enough information for us to understand its context.
Post #911259
Posted Tuesday, April 27, 2010 9:58 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, July 16, 2013 2:48 PM
Points: 262, Visits: 1,503
There is no difference in the data. I am very frustrated with this error.
Post #911264
Posted Tuesday, April 27, 2010 11:46 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 11:32 AM
Points: 5,257, Visits: 12,185
Mh-397891 (4/27/2010)
There is no difference in the data. I am very frustrated with this error.


Understandably. Does it always process exactly 44 rows? If so, can you try reading in the data in a different order, just to make sure that this is not data related? If you do this and the answer is still 44, I shall be extremely puzzled!

Is your package doing any complex processing or manipulation?



Help us to help you. For better, quicker and more-focused answers to your questions, consider following the advice in this link.

When you ask a question (and please do ask a question: "My T-SQL does not work" just doesn't cut it), please provide enough information for us to understand its context.
Post #911332
Posted Wednesday, April 28, 2010 7:41 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Sunday, September 14, 2014 3:17 PM
Points: 1,118, Visits: 2,224
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/

Post #911947
Posted Wednesday, April 28, 2010 10:25 AM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, January 7, 2013 2:22 AM
Points: 43, Visits: 56
I agree with Phil.
There must be some character like " ' " or something thats not allowing the transfer.

Can you give us a snapshot/column & their datatypes of the 2 tables in both sql server and as/400?


Rex Smith
Post #912174
Posted Thursday, May 13, 2010 8:24 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, February 6, 2012 2:49 PM
Points: 1, Visits: 14
Hi.

Have you been able to resolve this problem? I am getting the same error.
Does not always fail on the same row.

This is very frustrating --- this is just a simple import into the iSeries.
Post #921306
Posted Tuesday, April 15, 2014 4:15 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, October 30, 2014 1:40 AM
Points: 2, Visits: 146
I understand this is an old thread but for who are faicng this issue, this might can help them

you can map upto a maximum of 5 columns and it will execute successfully.(it worked for me)
Might be this can be a bug not sure

Use multicast if possible in your scenarios

Hope this helps !!

Thanks
Post #1561801
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse