MS SQL Server DTS - Informix to SQL

Author

Informix to SQL

Ken

2005-05-20, 1:23 pm

I'm trying to create a dts package to load data from Informix to SQL. I
created two connections - one for SQL and one for Informix (IBM OLEDB for
Informix). I then chose the data transform task and clicked Informix as
source and SQL as destination. But when I double click the connection line,
I get "Unspecified error".
I cannot go to the properties of data transform task. What am I doing wrong?

Thanks!

Ilya Margolin

2005-05-20, 8:24 pm

Ken,

IBM OLEDB for Informix is not supported by DTS provider. Try ODBC driver
instead.

Ilya

"Ken" <Ken@discussions.microsoft.com> wrote in message
news:6F4A4FFD-C367-46C2-8DB8- C8FCBDFCF7B3@microso
ft.com...
> I'm trying to create a dts package to load data from Informix to SQL. I
> created two connections - one for SQL and one for Informix (IBM OLEDB for
> Informix). I then chose the data transform task and clicked Informix as
> source and SQL as destination. But when I double click the connection
line,

> I get "Unspecified error".
> I cannot go to the properties of data transform task. What am I doing
wrong?
>
> Thanks!

Ken

2005-05-23, 11:23 am

Thanks for the reply.
Is there any OLEDB driver that is supported by DTS?
Thanks,
Ken

"Ilya Margolin" wrote:

> Ken,
>
> IBM OLEDB for Informix is not supported by DTS provider. Try ODBC driver
> instead.
>
> Ilya
>
> "Ken" <Ken@discussions.microsoft.com> wrote in message
> news:6F4A4FFD-C367-46C2-8DB8- C8FCBDFCF7B3@microso
ft.com...
> line,
> wrong?
>
>
>

Ilya Margolin

2005-05-23, 1:23 pm

Ken,

Yes, there are, but not for Informix.

Ilya

"Ken" <Ken@discussions.microsoft.com> wrote in message
news:AEAF261C-FB5C-4F0A-BD32- FB4FECF85C12@microso
ft.com...[color=darkred]
> Thanks for the reply.
> Is there any OLEDB driver that is supported by DTS?
> Thanks,
> Ken
>
> "Ilya Margolin" wrote:
>
I[color=darkred]
for[color=darkred]
as[color=darkred]

Sponsored Links