Posts

Showing posts from January, 2012

Documenting an SSIS package

I've been doing SSIS since it was called DTS back in the old'en days. I enjoyed using it with SQL Server 2000. One thing I always had trouble with was actually documenting the darn thing. It actually leads into a more existential issue with documenting these Workflow type systems, as well as these newer cloud based systems (take Microsoft's data explorer project, etc). I am leaving my current job and I had some SSIS work that wasnt well documented. I do see there are some commercial tools like BI Documenter  http://pragmaticworks.com/Products/Business-Intelligence/BIDocumenter/Default.aspx  But it seems I'll just fire up an old fashion Word document for now, and embed screenshots.