Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 Import tables from Informix to sql server 2000

Author  Topic 

linda9898
Starting Member

28 Posts

Posted - 2007-06-20 : 09:47:09
hi all ,

i need to import some tables from Infomix database to the sql server 2000.
what is the easiest way to do it as im quite new at this area.
thanks
linda

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-06-20 : 09:56:18
Have you tried using DTS Import/Export Wizard?

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-06-20 : 11:11:11
Ne to install Informix client on sql server first.
Go to Top of Page

lea
Starting Member

3 Posts

Posted - 2007-07-02 : 09:01:27
hi, i try to transform the data from informix to sql server by import/export wizard, but there is no "ole db provider for informix" in the list of sourse data. how to instal informix client on sql server? i cant find client on a console tree. thanks in advance
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-07-02 : 11:15:06
You can download informix client for windows on IBM web site.
Go to Top of Page
   

- Advertisement -