Hi,
I am using IBM Informix OLE DB Provider to create a OLE DB Connection manager. This connection managers is being used in OLEDB Command to update a table in informix database through a SSIS package.
I am having a parameterized query which updates a string data type column and have a where clause in which also there is a column with string data type.
When I run the package, it does not update the table neither it shows any error.
I have put a data viewer to see what is the data going, but it does not show any discrepencies.
I had read earlier, that the same problem exists for DB2 and it can be solved by putting "Derive Parameters=True" in the connection string. I think this property does not exits in for this Informix OLE DB provider.
Is there any microsoft oledb provider exists for Informix?
How would I update the Informix table with string data type? (without using Script component)
Any help would be appreciated
Thanks:)
Dharmbir