DTS migration 2000 to 2005

There are two options to move from 2000 sql server to 2005 sql server
database engine.
1. Double click on the DTS package to open in the designer.
Click file--> save as and change the destination server to SQL server
2005. Then save.
Finally the package will be right clicked in 2005 database
engine and migrated to integration services.
2. Save the DTS package as a structured storage file and import
it in sql server 2005 database engine under management --> legacy -->
Data transformation services.
Finally the package will be right clicked in 2005 database
engine and migrated to integration services.
What is the recommended method out of these two? Please illustrate.
My recommendation would be the second. I would also be careful in testing
what the Migration Wizard does when moving it to an SSIS package. If your DTS
package contains a lot of script components, "odd" things can happen. Since
you can still run and maintain your DTS packages under the Migration section
(just not create new ones), depending on the volume of use of DTS, I often
recommend to not migrate and slowly create new ones in SSIS. SSIS is a
daunting tool compared to the DTS designer, so even maintaining once
converted could be time consuming.
My 2 cents - hope that helps.
"sudesh.withanage@.gmail.com" wrote:

> There are two options to move from 2000 sql server to 2005 sql server
> database engine.
> 1. Double click on the DTS package to open in the designer.
> Click file--> save as and change the destination server to SQL server
> 2005. Then save.
> Finally the package will be right clicked in 2005 database
> engine and migrated to integration services.
>
> 2. Save the DTS package as a structured storage file and import
> it in sql server 2005 database engine under management --> legacy -->
> Data transformation services.
> Finally the package will be right clicked in 2005 database
> engine and migrated to integration services.
>
> What is the recommended method out of these two? Please illustrate.
>