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.
| Author |
Topic |
|
1fred
Posting Yak Master
158 Posts |
 Posted - 2003-09-15 : 14:13:10
|
| A client has a DB2 5.1 database and an Oracle 8.0 one too. Since a lot of the informations in these databases are corrupted or not normalise, they want to push some information into SQL server 2000.Is DB2 5.1 supported with MS sql Linked Server or at last DTS?What's the best solution to brind the data to SQl server?Thanks |
|
|
lozitskiy
Starting Member
28 Posts |
Posted - 2003-09-15 : 15:53:00
|
| You can install IBM client and use DB2 as linked server (I have done this couple time).OPENQUERY will help to read from or write to DB2.-------------MCP MSSQL |
 |
|
|
|
|
|
Linked Server With BD2