May 6, 2009 at 3:06 pm
I need help with the following situation:
Error in ssis: CLI0100E Wrong number of parameters. SQLSTATE=07001
Situation:
We are currently in the process of upgrading our UDB and DB2 databases to 9.0. Since we are going to have a mixed environment of version 9.0 and version 8.0 database we started to start our testing with the SSIS platform. Whenever we try to insert into a version 9.0 database all goes fine but if we try to insert data through SSIS from IBM V9.0 provider to V8.0 database we get the above error.
Test that we have done:
1. Insert of data into the tables with out using parameters
- from db2 client (db2cmd...) inserts without issue
- same command using SSIS - Error from above
2. Insert of data into the tables using parameters
- from db2 client - no issues
- from SSIS - Error above
The is no transformations going on in the SSIS package this is a straight E->L. Since we can insert fine when using the db2 client this has to be an ssis communication issue between IBM v9.0 provider and SSIS.
Again this only happens when going from V9.0 client to V8.0 database. We can go V8.0 client to V9.0 database without issue, and we can go from v9.0 Client to v9.0 database without issue.
Any help would be appreciated
May 6, 2009 at 7:10 pm
How are you connecting to the DB2 databases - OLEDB or ODBC? It sounds like IBM is using a different driver version for 9.0 that is incompatible with 8.0. This does not appear to be an SSIS issue. It is the IBM driver.
May 8, 2009 at 12:56 pm
we are using the ole db driver.
I would agree that it would be a IBM provider if the same query would fail when ran by DB2 command line.
How can SSIS 64bit 2005 with DB2 9.0 client work good talking to DB2 V9.0, also SSIS 64bit 2005 with DB2 9.0 client works with db2 8.0 database when run via DB2CMD. The only time it fails is with SSIS 64bit 2005 with DB2 9.0 client talking to DB2 Database 8.0 through SSIS.
I am wondering if anybody else is having this issue and how they resolved it?? It seems to me not many shops are migrating from 8.0 DB2\UDB to 9.0, and even fewer are using SSIS as there ETL platform.
Here is the complete error: Description: " CLI0100E Wrong number of parameters. SQLSTATE=07001". End Error Error: 2009-05-05 22:22:57.45 Code: 0xC0202009 Source: DFT EGL_HUB_ZIP_MEX INS Q EGL_HUB_ZIP_MEX [3677] Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "IBM OLE DB Provider for DB2" Hresult: 0x80004005 Description: " CLI0100E Wrong number of parameters. SQLSTATE=07001". End Error Error: 2009-05-05 22:22:57.45 Code: 0xC0202009 Source: DFT EGL_HUB_ZIP_MEX INS Q EGL_HUB_ZIP_MEX [3677] Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "IBM OLE DB Provider for DB2" Hresult: 0x80004005 Description: " CLI0100E Wrong number of parameters. SQLSTATE=07001". End Error Error: 2009-05-05 22:22:57.45 Code: 0xC0202009 Source: DFT EGL_HUB_ZIP_MEX INS Q EGL_HUB_ZIP_MEX [3677] ...
September 4, 2009 at 12:24 pm
Update:
I have refined the problem. The error is with SSIS(64bit). We can run a package succuessfully if we use DTEXEC (32bit) mode.
We will be opening a Microsoft ticket for a bug in SSSI(64bit).
Error:
Source: "IBM OLE DB Provider for DB2" Hresult: 0x80004005 Description: " CLI0100E Wrong number of parameters. SQLSTATE=07001".
DB2 Client Provider:
DB21085I Instance "DB2" uses "64" bits and DB2 code release "SQL09054" with
level identifier "06050107".
Informational tokens are "DB2 v9.5.400.576", "s090429", "WR21450", and Fix Pack "4".
SSIS Version:
9.0.3228
TEST Results:
Test 1
Ran SSIS using Sql agent (64bit) = failure
Source V9
Client V9
Destination V9
Error: Source: "IBM OLE DB Provider for DB2" Hresult: 0x80004005 Description: " CLI0100E Wrong number of parameters. SQLSTATE=07001".
Test 2
Ran SSIS using Sql dtexec (32 bit) = pass
Source V9
Client V9
Destination V9
* In SSiS when a job is run via the DTEXEC tool it always runs in 32bit mode
Test 3
Ran SSIS using Sql agent cmd line DTEXEC = pass
Source V9
Client V9
Destination V9
_______________________________________________________________________________________________
Test 4
Ran SSIS using Sql agent (64bit) = failure
Source V9
Client V9
Destination V8
Error; Source: "IBM OLE DB Provider for DB2" Hresult: 0x80004005 Description: " CLI0100E Wrong number of parameters. SQLSTATE=07001".
Test 5
Ran SSIS using Sql dtexec (32 bit) = pass
Source V9
Client V9
Destination V8
Test 6
Ran SSIS using Sql agent cmd line DTEXEC = pass
Source V9
Client V9
Destination V8
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply