Groups | Blog | Home
all groups > sql server dts > june 2004 >

sql server dts : Meta Data Service Packages


Mike Koerner
6/14/2004 2:48:46 PM
Hi,

I am trying to save a DTS package to the Meta Data repository, but it is not
listed in the location drop down in the DTS Save As dialog. Any reason the
meta data services repository would not be listed as a save location? I am
trying to learn more about meta data in the enterprise.

Thanks,
Mike

Allan Mitchell
6/15/2004 6:12:49 AM
It was removed as a default save location in SP3

Right click on the Data Tramsformation Services Folder | Properties

You will see the option there to reenable.

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


[quoted text, click to view]

Mike Koerner
6/15/2004 1:27:18 PM
Hi,

Thanks for your response, it worked. Any good links to learn more about the
uses of meta data?

Thanks,
Mike

[quoted text, click to view]

Allan Mitchell
6/15/2004 7:40:50 PM
To tell you the truth I do not know anybody using this feature period. MS
obviously had a reason to turn it off by default. Packages were slow to
open also.

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


[quoted text, click to view]

AddThis Social Bookmark Button