dbTalk Databases Forums  

sql2005 : dts package

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss sql2005 : dts package in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
soonyu
 
Posts: n/a

Default sql2005 : dts package - 07-11-2006 , 05:08 AM






I just using migration wizard in legacy->dts to import wizard
from sql2000, it show successful.
but where can i can the import dts?
Can't find anywhere..

need advice

soonyu

Reply With Quote
  #2  
Old   
Arbeebee
 
Posts: n/a

Default Re: sql2005 : dts package - 07-11-2006 , 07:50 AM






In the Management Studio, connect to the server.

Then look in ServerName => Managemener => Legacy = > Data
Transformation Services

soonyu wrote:
Quote:
I just using migration wizard in legacy->dts to import wizard
from sql2000, it show successful.
but where can i can the import dts?
Can't find anywhere..

need advice

soonyu


Reply With Quote
  #3  
Old   
soonyu
 
Posts: n/a

Default Re: sql2005 : dts package - 07-11-2006 , 08:12 AM



i did but not manage to find.
when i try to run wizard to import again. it mention already exist and
whether want to overwrite?

can we restore sql2000 msdb to sql2005?

--soonyu

"Arbeebee" wrote:

Quote:
In the Management Studio, connect to the server.

Then look in ServerName => Managemener => Legacy = > Data
Transformation Services

soonyu wrote:
I just using migration wizard in legacy->dts to import wizard
from sql2000, it show successful.
but where can i can the import dts?
Can't find anywhere..

need advice

soonyu



Reply With Quote
  #4  
Old   
Allan Mitchell
 
Posts: n/a

Default Re: sql2005 : dts package - 07-15-2006 , 05:55 AM



Hello soonyu,


Open Management Studio
Connect to the SSIS Service
Look in there


Yes you can RESTORE a 2K DB to 2K5



Allan



Quote:
i did but not manage to find.
when i try to run wizard to import again. it mention already exist and
whether want to overwrite?
can we restore sql2000 msdb to sql2005?

--soonyu

"Arbeebee" wrote:

In the Management Studio, connect to the server.

Then look in ServerName => Managemener => Legacy = > Data
Transformation Services

soonyu wrote:

I just using migration wizard in legacy->dts to import wizard
from sql2000, it show successful.
but where can i can the import dts?
Can't find anywhere..
need advice

soonyu




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.