I am trying to save a DTS package to Meta Data Services. The problem is
that in DTS designer, when I 'save as', the location dropdown does not even
list Meta data Services. I do see Meta Data Services in the Enterprise
Manager tree.

What gives? Any info is appreciated.


thanks, -marty nicholson

Just some background - I am running Developer Edition on XP Pro. I have not
see any articles stating that Meta Data Services did not run on this config.

-marty

"Martin Nicholson" <mgnicholsonNOSPAM (AT) hotmailNOSPAM (DOT) com> wrote

Well, I solved this myself. From Enterprise Mgr, right-click Data
Transformation Services > Properties. Check "Enable Save to Meta Data
Services".

From what I read, this feature was introduced in SP3a.

Here's a link to an article about it:
http://dbforums.com/arch/203/2003/8/884538


"Martin Nicholson" <mgnicholsonNOSPAM (AT) hotmailNOSPAM (DOT) com> wrote

Correct. This has caught a few people out after applying SP3

--

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



"Martin Nicholson" <mgnicholsonNOSPAM (AT) hotmailNOSPAM (DOT) com> wrote