September 2, 2003 at 9:25 am
Can you use the Metadata Services other than the Transform Data Task. CAn you use it with for example Execute SQL Task?
September 2, 2003 at 7:25 pm
Hi there
Not that I am aware of, it only stores lineage for packages. There is an API btw... use these steps to take a look at it then check MSDN for the API calls..
I suppose you could maniuplate the MSDB tables direct? 🙂
The meta data services snap in is the key to administering meta data services. To use the snap in (which is not available in EM) you need to:
a) Run mmc.exe
b) File --> “Add/Remove Snapin”, dialog is shown, click on the “Add” button
c) Select the Meta Data Services snap-in and others as need be, close when finished
d) Ok
e) Save the console, setting yourself up with a custom admin management console
To register a instance and set administrative properties, you must have a database with the repository tables. This database is the msdb system database.
a) Right click on Meta Data Services, select register database
b) Filling in the standard registration database property using the SQL Server OLE-DB provider
(which you cannot change).
c) The 3 user modes are:
a. End User – read only access to contents folder (as in EM)
b. Power User – read/write but cannot edit object properties
c. Administrator – read only to information models, read/write all other properties
d) Based on the user access, the DBA can remove, edit and refresh the repository and properties, this is not possible in EM.
Chris Kempster
Author of "SQL Server 2k for the Oracle DBA"
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
September 3, 2003 at 7:14 am
Thanks for the response.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply