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 |
|
msb_s
Starting Member
4 Posts |
 Posted - 2002-08-28 : 07:59:08
|
| HI Can somebody suggest me whether it is possible to create a DTS pack which exports the data from some tables on SQlServer 2000 to some tables ( of same structure as on SQL 200) on SQLServer 7thanks in advancesai |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2002-08-28 : 08:12:07
|
| yesDamian |
 |
|
|
msb_s
Starting Member
4 Posts |
Posted - 2002-08-29 : 01:55:43
|
| Please suggest me how to do create a DTS Pack to export the data from SQL Server 2000 to SQL Server 7.Because in the DTS wizard on a machine having SQL Server 200 and i am not able to see any machine having SQLServer7 .Please help me Thanks MSB_S |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2002-08-29 : 02:56:28
|
| Just because the wizard didn't automatically detect it doesn't mean you can not do it. Try entering the address of your other server.Damian |
|
|
|
KHeon
Posting Yak Master
135 Posts |
Posted - 2002-08-29 : 07:21:41
|
| Try by IP, that should work. Also, to get servers to show up in the Servers dropdown, add them (and alias them) to the Client Network Utility.Kyle HeonPixelMEDIA, Inc.Senior Application Programmer, MCPkheon@pixelmedia.com |
|
|
|
|
|
|
DTS Pack to Export Data from SQL2000 to SQL 7