I am getting this error in SSIS 2008 when I am trying to execute an SSIS pkg which
- Transfer data from a table in DB2 to a table in SQL 2008R2
- It pulls only the data which are newer than a specific date which is passed as parameter to OLE Source.
[Stable ] Error: 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".
[SSIS.Pipeline] Error: component "Stable" (1) failed the pre-execute phase and returned error code 0xC0202009.
Here is what I did.
Create 2 tasks, one is (Execute SQL Task) and the other is Data Flow Task
The Read date task will read the date from a table and inset it into a variable.
Here is how I set the output to variable
Now, I want to use this variable as parameter in OLE data source
So I created a data flow
Then use OLE source editor to set the query and the parameter.
When I execute the pkg it failed in OLE Source and give the above error, I attached the package as well.
If I don’t use parameter it run successfully, What I miss?