dbTalk Databases Forums  

Repository Package Upgrade

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


Discuss Repository Package Upgrade in the microsoft.public.sqlserver.dts forum.



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

Default Repository Package Upgrade - 11-19-2003 , 01:28 PM






Hi,
Can anyone tell me how to upgrade DTS Repository Packages
from SQL Server ver.7 to 2000? MS Installation guide says
that Packages don't get upgraded automatically in the
process of upgrading databases from 7 to 2000! Correct me
if I am wrong! If it is true! What would be the best way
to do it? I am going to upgrade the entire DB Sever to
2000.
Any suggestions?
Thanks
Kris.

Reply With Quote
  #2  
Old   
Darren Green
 
Posts: n/a

Default Re: Repository Package Upgrade - 11-19-2003 , 03:19 PM






In article <013501c3aed3$3f3a3e60$a501280a (AT) phx (DOT) gbl>, Kris
<anonymous (AT) discussions (DOT) microsoft.com> writes
Quote:
Hi,
Can anyone tell me how to upgrade DTS Repository Packages
from SQL Server ver.7 to 2000? MS Installation guide says
that Packages don't get upgraded automatically in the
process of upgrading databases from 7 to 2000! Correct me
if I am wrong! If it is true! What would be the best way
to do it? I am going to upgrade the entire DB Sever to
2000.
Any suggestions?
Thanks
Kris.

You need to upgrade the repository structures. There is a tool to do
this, called Insrepim.exe. The SQL Server 2000 Books Online
topic is "DTS Information Model", or just search for Insrepim.exe.

SQL Server 2000 Books Online Contents path -
Data Transformation Services -> Sharing Meta Data -> DTS Information
Model

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org



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.