DTS package desined in server 2000, but update 2005 database

Hello
we have sql server 2000 for development environment and 2005 for
production. i have created a DTS package in 2000 to update 5 tables on
Production.
But my DTS package is not updating tables on production. i am getting
following error message:
"To connect to this server you must use SQL Server Management Studio
or SQL Server Managesment Objects (SMO)"
All the comments and suggestions are welcome and will be appreciated.
Thanks
AjitYou should use SSIS to work with SQL 2005. SSIS can connect with SQL 2000,
but DTS cannot do it withj SQL 2005.
In SQL 2005 you just can run DTS 2000 packages using the "Execute DTS 2000
Package" task. TO do it you should install the DTS 2000 run-time Engine.
See the following topic on Book on Line:
SQL Server Integration Services (SSIS) -> Integration Services Objects and
Concepts -> Control Flow Elements -> Integration Services Tasks -> Execute
DTS 2000 Package Task
Gilberto Zampatti
"The Bichoo" wrote:
> Hello
> we have sql server 2000 for development environment and 2005 for
> production. i have created a DTS package in 2000 to update 5 tables on
> Production.
> But my DTS package is not updating tables on production. i am getting
> following error message:
> "To connect to this server you must use SQL Server Management Studio
> or SQL Server Managesment Objects (SMO)"
> All the comments and suggestions are welcome and will be appreciated.
> Thanks
> Ajit
>