How to export SQL2000 DTS package to SQL2005

Last Post 29 Sep 2008 02:28 AM by kevincheang. 2 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
kevincheang
New Member
New Member

--
26 Sep 2008 07:55 PM
Dear all,

I need to upgrade a SQL2000 to SQL2005, however, I got the problem is how to transfer SQL2000 DTS to SQL2005.

I export those DTS and import to 2005 got error...

Any suggestions / reference material for me to do such case... Thanks

Kevin
kevincheang
New Member
New Member

--
29 Sep 2008 02:28 AM
You means that when I upgrade the SQL2000 to 2005, also upgraded 2000 DTS to 2005 DTS?

Pls advise.

Thanks

Kevin
kevincheang
New Member
New Member

--
02 Oct 2008 01:29 AM
Is it installing SQL2005 server firstly, then using dts package upgraded wizard for upgrade 2000 dts to 2005 dts?

Thanks

Kevin


Acceptable Use Policy
---