Informix Ole db and SSIS 64 bit
I am trying to connect to an IBM Informix database from SQL Server 2005
SP1 (64 bit) SSIS and I haven't succeeded yet. This is what I do.
I have created a connection using "IBM Informix Ole db Provider"
selected in the drop down box. I can test the connection successfully
against the Informix database. Then I create a "Data flow task"
with an "Ole DB Source" using the Informix Ole db Connection. I
also create a SQL server destination. In the "Ole DB Source" I do
get data from the Informix database when I preview the data, but when I
try to execute the "Data Flow task" I get this error message:
SSIS package "Package.dtsx" starting.
Information: 0x4004300A at test, DTS.Pipeline:
Validation phase is beginning.
Error: 0xC020801C at test, OLE DB Source : The
AcquireConnection method call to the connection
manager firstname.lastname@example.org failed with error
Error: 0xC0047017 at test, DTS.Pipeline: component
"OLE DB Source" (94) failed validation and returned
error code 0xC020801C.
Error: 0xC004700C at test, DTS.Pipeline: One or more
component failed validation.
Error: 0xC0024107 at test: There were errors during
SSIS package "Package.dtsx" finished: Success.
Does anyone have an idea why this happens? Has it something to do with
the fact that the SSIS is running on a SQL Server 2005 64 bit?
BTW, what is the best/fastest method to get data from an IBM Informix
database on a unix server into a SQL Server 2005 64 bit.
Thanks in advance.