July 20, 2010 at 8:01 am
Hi,
Just wanted to post this one as I was on here a few months back looking for any tools useful for documenting SSIS packages. I found a few suggestions but didn't really see anything that jumped out at me - I have always loved the challenge of designing and implementing new SSIS packages but never documented anything - that was the part I hated. I suddenly found myself with a system with over 20 scheduled jobs calling SSIS packages and no documentation - not good!!
The thought of just documenting my SSIS packages in Word and then saving the files to a server where I knew they would never be looked at or probably never found always put me off.
So in the end, I setup a local version of mediawiki for our company dept and documented all of my SSIS processes in there and it has been a revelation. Its free, only took a few minutes to configure and get the mediawiki up and running and once it was I just came up with my own template format and documented everything in there.
So now anyone in the dept can easily access documentation and instead of messing around with annotation in the SSIS package itself I just include a link to the documentation in the wiki.
Just wondering if anyone else is using the mediawiki for this purpose?
I first downloaded the Xampp software from here :
http://www.apachefriends.org/en/xampp.html
, installed it on a web server running the MySQL and Apache services and the followed the instructions here to set up the wiki :
http://www.nat32.com/xampp/wiki.htm
It really was all very easy!
Hope this tip might be of use to someone out there!
Cheers,
JayK
August 3, 2010 at 7:43 am
Yes I have used the media wiki not only for documenting only SSIS, but complete SQL Server Environment. However its a tedious process.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply