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 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Transfer data from DB2 to SQL Server 2000

Author  Topic 

taraernst
Starting Member

9 Posts

Posted - 2006-10-26 : 11:03:06
Hello. Can anyone provide a solution on the best way to transfer data from DB2 to SQL Server 2000? I need to create a regular transfer of data from DB2 to SQL and it does not appear that there is a OLE DB provider for DB2 in SQL unless you have Microsoft Host Integration Server 2000. I would like to schedule a DTS to do this, but need the correct provider. There seem to be a bunch of utilities on the Web, but you never know which is going to be the least painful. Any thoughts/suggestions would be appreciated!

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-10-26 : 11:05:16
You could use Linked Server

http://www.carlprothman.net/Default.aspx?tabid=87#OLEDBProviderForDB2


Peter Larsson
Helsingborg, Sweden
Go to Top of Page
   

- Advertisement -