Informix to SQL

#1

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!

#2

Ken,

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

Ilya

"Ken" <Ken (AT) discussions (DOT) microsoft.com> wrote

Quote:

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!

#3

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

"Ilya Margolin" wrote:

Quote:

Ken,

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

Ilya

"Ken" <Ken (AT) discussions (DOT) microsoft.com> wrote in message
news:6F4A4FFD-C367-46C2-8DB8-C8FCBDFCF7B3 (AT) microsoft (DOT) 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!

#4

Ken,

Yes, there are, but not for Informix.

Ilya

"Ken" <Ken (AT) discussions (DOT) microsoft.com> wrote

Quote:

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 (AT) discussions (DOT) microsoft.com> wrote in message
news:6F4A4FFD-C367-46C2-8DB8-C8FCBDFCF7B3 (AT) microsoft (DOT) 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!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Informix to SQL

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Informix to SQL - 05-20-2005 , 01:27 PM

Re: Informix to SQL - 05-20-2005 , 03:31 PM

Re: Informix to SQL - 05-23-2005 , 10:00 AM

Re: Informix to SQL - 05-23-2005 , 12:28 PM