I just recently did this migration too. On the 2005 box be sure you have the
backward compatibility feature packs loaded to be able to edit the DTS
package after you load it. We used structured storage files to move the
packages over and then import them using 2005 SQL Server Management Studio.
The import option shows up when you rt/click off "management/legacy/Data
Transformation Service" in the studio. Some gotcha's. If you plan to have the
server use MAPI so any SQL 2K DTS can use the mail object, you will have to
load outlook, set it up for sql and enable it. If the DTS packages access the
file system you may need to play with security a bit. SQL 2005 is tighter on
security.
--
Mark Price
DBA/SA
[quoted text, click to view] "shubtech@gmail.com" wrote:
> We have a new machine with a fresh install of SQL2005. We have
> restored some of the DB's from the SS2K box, now I need to move some of
> the DTS to SS2005. We really are not ready to change our DTS to the new
> SSIS so we would like to continue using DTS on 2005 for a little while
> until we are ready to chnage our DTS to SSIS. I have read some articles
> on the net where it suggested to download the DTS designer components
> which I did as we will still need to edit the DTS in the 2005 box.
>
> However I am not sure what the next step should be to bring over the
> DTS from 2000 to 2005. Our DTS on the 2000 box are stored in
> (Location:SQL Server ) however if I need to I can save them as
> structured storage file.
>
> Can anyone please help me with the next step?
>
> Thanks
>
Hello shubtech@gmail.com,
Why not then simply use the Execute 2000 Package task and retrieve the packages
from the 2000 server. There is no compelling need to migrate everything
to 2K5. The Execute 2000 Package task is very good.
Allan Mitchell
www.SQLDTS.com www.SQLIS.com www.Konesans.com [quoted text, click to view] > We have a new machine with a fresh install of SQL2005. We have
> restored some of the DB's from the SS2K box, now I need to move some
> of the DTS to SS2005. We really are not ready to change our DTS to the
> new SSIS so we would like to continue using DTS on 2005 for a little
> while until we are ready to chnage our DTS to SSIS. I have read some
> articles on the net where it suggested to download the DTS designer
> components which I did as we will still need to edit the DTS in the
> 2005 box.
>
> However I am not sure what the next step should be to bring over the
> DTS from 2000 to 2005. Our DTS on the 2000 box are stored in
> (Location:SQL Server ) however if I need to I can save them as
> structured storage file.
>
> Can anyone please help me with the next step?
>
> Thanks
>
