We are trying to move data from our SQL 2008 server to our as400 server. When creating the SSIS package we are using an ADO.NET Destination to the as400 server. The problem is that when we run the package the ADO.NET destination only writes one record to the as400 before failing the package with the following error:
[ADO NET Destination ] Error: An exception has occurred during data insertion, the message returned from the provider is: ERROR  [IBM][iSeries Access ODBC Driver]Wrong number of parameters.
We have tried to upload only one record and the process works succefully. Then two records which fails.
We have been banging our heads over this issue, any help would be appreciated.