DTS packages migration from MSSQL 2K to MSSQL server 2005

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lena - 05 Mar 2008 20:19 GMT

Hello

I need to migrate all my dts packages from sql server 2000 to sql
server 2005 so I can access these packages under Legacy->DTS in
Microsft sql server 2005 Management studio.
How can I do this?

Regards,
Lena

Reply to this Message

Uri Dimant - 06 Mar 2008 07:21 GMT

Lena, privet
Under Legacy folder, there is Data Transformation Services folder, right
click on it then Import Package File ( I assumed you saved the dts package
as a file)

> Hello
>
[quoted text clipped - 5 lines]
> Regards,
> Lena

Reply to this Message

Lena - 06 Mar 2008 15:10 GMT

I already did that.
Now when I try to open the package, I'm getting error:
"The package cannot be edited.
SQL Server 2000 DTS Designer Components are required to edit DTS
packages. Install the special Web download, "SQL server 2000 DTS
designer Com[ponents" to use this feature".

I can not find this download on Microsoft's site.

> Lena, privet
> Under Legacy folder, there is Data Transformation Services folder, right
[quoted text clipped - 12 lines]
>
> - Show quoted text -

Reply to this Message