I want to transfer data from sql server 6.5 to sql server 2000.
can DTS help me ?
Or any other suggest ?

Thanks!

Yep you can use DTS to move data between 6.5 and 2000.

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"Chen Ka Pong" <cspong (AT) mail (DOT) hongkong.com> wrote

how to do that ?

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Create a DSN to your 6.5 SQL Server.
Add to your DTS Designer an "Other Connection" and supply the details of the
DSN and Username and Password.


--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"Chen Ka Pong" <cspong (AT) mail (DOT) hongkong.com> wrote