Showing posts with label helloi. Show all posts
Showing posts with label helloi. Show all posts

Thursday, March 22, 2012

DTS packages migration from MSSQL 2K to MSSQL server 2005

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
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)
"Lena" <lenaglozman@.yahoo.com> wrote in message
news:e01c20ab-e0a9-4104-ad48-90f70fd91a5d@.47g2000hsb.googlegroups.com...
> 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
|||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.
On Mar 6, 1:21Xam, "Uri Dimant" <u...@.iscar.co.il> wrote:
> Lena, privet
> Under Legacy folder, there is XData Transformation Services folder, right
> click on it then Import Package File ( I assumed you saved the dts package
> as a file)
> "Lena" <lenagloz...@.yahoo.com> wrote in message
> news:e01c20ab-e0a9-4104-ad48-90f70fd91a5d@.47g2000hsb.googlegroups.com...
>
>
>
> - Show quoted text -