working with sql server 2000 - and sql server 2005

[treviboy]

hi,
I've got sql server 2005 on my desktop. I've got a sql server 2000 database on a server. I would like to run DTS to import some data into one or more than one table in the sql server 2000 database. Can I do that with sql server 2005? I apologize if I am not putting this in the right spot. Or maybe somebody could point me to some documentation that I can read?
Thank you very much !

 

[Ankor]

Yes, you can run your SQL 2000 DTS from SQL 2005 client - just install DTS Designer 2000.

 

[treviboy]

Thanks Ankor.

 

[treviboy]

Can I update the sql server2000 on a remote server, using sql server 2005's SIS package? Isn't that possible?

 

[mrdenny]

Yes you can use SSIS to update a SQL 2000 database. You can not deploy an SSIS package to a SQL 2000 server.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com