Hi,

Right now I have a SQL Server 2000 database, and an Informix database. May I know how to import data from Informix to SQL 2000 and export data from SQL to Informix? Besides, how to update certain data in the Informix/ SQL server 2000 after generating the Import/Export process?
Please help as I am new to this and I need a step-by-step solution for this. Thank you very much

I pull information from Informix every week (10GB+). I use the the Informix
SDK drivers from Informix.

Create a DSN to point to Informix | Test

Once you have this then you can use this as a datasource in DTS

You can retrive data from/Send data to Informix.

--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


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

SQL to Informix? Besides, how to update certain data in the Informix/ SQL
server 2000 after generating the Import/Export process?

HI Allan

May I know the scripts or ways to pull data from the Informix (by row) to SQL and update some of the data in the Informix? Please help as I am new to this.

Why would you want to pull the data from Informix to SQL Server and then
update informix?

What I personally do Is I do it two ways

1. Linked Server of the Informix Database
2. I pump the rows to Informix and then issue the statements against
Informix using an ExecuteSQL task.



--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


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

to this.