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.

Comments

Post a Comment

Popular posts from this blog

Quick Progress!

Parsing for fun and profit I remember creating parsers to be a bit harder. I tried using Antlr when doing the JavaFX DLR project and failed at it miserably. It felt messy. I couldnt get a feel for how to structure the document, etc. I was drawn to the Irony parser framework because declaring the grammar in C# somehow felt (at the time) cleaner and it seemed to allow for more expressive statements and character logic. I am not sure if it was my previous experience with parsing and Antlr (or Irony), or how clean and expressive the GOLD parser framework is, but I've been able to create a working parser in just a few days of coding. And by working, I mean it parses and understands valid LLVM IR straight from the project's documentation:  I actually implemented a a lot more operations and keywords needed to parse the example. It was just easier that way. I am going to now start building an AST. I've decided to be a bit aggressive because I think the AST will drive ...
Read more

Its Happening! Its really Happening! ^_^

So, big news. The Oculus/Facebook folks just announced that all kickstarter backers who got a unit, will get a commercial unit!  As, an original backer of the Oculus (and one of the backers who was actually ok with the facebook purchase), I am extremely happy, and extremely proud/humbled that I was a part of helping VR come back.  Big Thank you to the folks at Oculus! As a small token of our appreciation for your support, all Kickstarter backers who pledged for a Rift development kit will get a free Kickstarter Edition Oculus Rift! And like all Rift pre-order purchasers, you’ll receive a bundled copy of Lucky’s Tale and EVE: Valkyrie. To claim your free Rift, fill out the survey you’ll receive from Kickstarter before February 1, 2016 and provide a shipping address that is located in one of the 20 countries Rift is launching in. For those who don’t live in one of those 20 countries, we’re working on an alternative, and you can let us know your preference in the for...
Read more
So I've again been bitten by the Transcoding/transpiling bug...Doh! My history with Transcoding  A few years back (around mid-2007), I was enamored with a new language on the block, JavaFX (now vala). Alas, I had moved on from the Java platform to the .Net platform during that time, and Silverlight just hit the stage (and WPF). I was more of a fan of the declarative and expressive nature of JavaFX than I was of XAML, so I looked into porting JavaFX script to the .Net platform (and later the DLR). I halted my work in 2008-2009, as JavaFX script was dying, and the Parser technology I was using (a great C# based parser called Irony) was giving me issues when integrating with the DLR. The LLVM Project I've been a fan of the LLVM project since about 2009. I have also watched its MSIL backend go into disrepair and interest in C# as part of the vmkit wane. I answered some stack overflow questions in 2011 about this http://stackoverflow.com/questions/5054938/how-to-translate...
Read more