I haven’t had any time to work on MetaShare lately, but I know that someone has made it work with Katmai already. I don’t think that the code was checked in, but if I get a chance, I’ll try and make the changes so there is a switch to allow operation with Katmai.
Also – I’ve had a couple of requests to perform a demo of MetaShare. I’d be happy to do that. Let me look into ways to do that and I’ll post somethig about a time and method. I know that some folks are not necessarily in the US, so maybe we can figure out a way to do the audio over the internet as well as desktop sharing. If anyone has suggestions, let me know for both audio and desktop sharing. If there isn’t anyone from outside the US, then we can use something like http://www.freeconferencecall.com/ – but I’m still interested if anyone knows of a free desktop sharing solution we could use.
We’d cover breifly how I set up the demo environment with Microsoft Data Warehouse Toolkit sample data structure and SSIS packages written by Warren and Joy, how to extract metadata out of the MDWT_AdventureWorksDW database as well as the SSIS package store and publish this information as Wiki using FlexWiki. We’ll also talk about how powerful it is to publish this metadata as wiki instead of something like a dead text document.
Maybe we could do something week after next – the week of the 10th? Leave me a comment here if you’d be interested in attending. We can also do multiple sessions if we can’t agree on a time. I think it will take from a half hour to an hour to run through the whole thing.
Stay tuned.
Mark
i’d like to see that,
Greetings,
I have tried the MetaShare for AdventureDW without problem. But do you know we can use Metashare on tracking any other SSIS package (ex, transfer data between Oracle through SSIS)?
MetaShare is designed to extract out SSIS meta data no matter what the source and destination of the package it. It is, however, specially designed to extract the meta data in combination with the Kimball Spreadsheet meta data.
Give it a try. It should still work with a packages that sources out of Oracle.
You mean we need to have special design from SSIS, or we can just use existing Kimball spredsheet meta data? Do you have any guide that we can follow to make a new SSIS package showing meta data by MetaShare?
Thanks a lot
Sorry I wasn’t clear. As far as SSIS is concerned, there is no special Kimball metadata involved. You can use MetaShare on any SSIS package.
In the MetaShare cmd line to run it, we need to specify a database name, this database is data source? If we run SSIS for Oracle1 to oracle2, what we should specify for this database name? (should we run this in Oracle server?)
I just got it works, however, it only shows Data source info, I didn’t see and find any SSIS info over there, I searched SSIS package in Wiki, but result got nothing, do I need to add anything to get SSIS info showing over there?
No, nothing special needs to be in the package for MetaShare to extract meta data. I will go ahead and say that I don’t know how well this will work with an Oracle database as the other search partner for MetaShare. You’re more than welcome to download the source code and see how well you can make it work for you.
Any way to find how many SSIS packages related to a table.column?
You’ll have to run XPath queries on the XML of the SSIS packages. Feel free to look in the source code of MetaShare for an example.
Why is the Metashare.Generate.exe precompiled?
I would like to be able to point to 2008 directories for SSIS package.
The code is looking in a DTS90 directory instead od DTS100, but I have no way to change this
little help?