Hello. What is the best way to transfer data from DB2 to SQL Server
2000? Any feedback is appreciated!

Why don't you use the DTS Import/Export wizard? You can copy entire db's,
objects and all.

"taraernst (AT) new (DOT) rr.com" wrote:

Dominick D. wrote:
That's what I'd like to do - - - use SQL's DTS Import/Export wizard,
however, there does not appear to be an OLE DB provider for DB2 in SQL
unless you have Microsoft Host Integration Server 2000 installed. Are
you familiar with Microsoft Host Integration?