Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Tim Mitchell

Tim Mitchell is a business intelligence consultant, author, trainer, and SQL Server MVP with over a decade of experience. Tim is the principal of Tyleris Data Solutions and is a Linchpin People teammate. Tim has spoken at international, regional, and local venues including the SQL PASS Summit, SQLBits, SQL Connections, SQL Saturday events, and various user groups and webcasts. He is a board member at the North Texas SQL Server User Group in the Dallas area. Tim is coauthor of the book SSIS Design Patterns, and is a contributing author on MVP Deep Dives 2. You can visit his website and blog at TimMitchell.net or follow him on Twitter at twitter.com/Tim_Mitchell.

SSIS Documentation suggestions on Microsoft Connect

For SSIS developers, the need for proper documentation is crucial.  However, the built-in object for documentation, the annotation, is difficult to use.  It doesn’t wrap text, doesn’t support varying font styles in a single instance, and doesn’t offer spell checking.  Further, all annotations are “at large” and are not attached to a particular object – they are associated with a specific task or component only by the location in which you place them.

If you’re like me and would like to see improvements to the SSIS annotation tool, consider visiting Microsoft Connect and offering your vote and feedback on a couple of items:

Connect Item 483132 – Suggestion to improve the SSIS annotation tool by adding rich-text capability.  I added this item this morning.

Connect Item 216927 – Suggestion to allow linking of annotation to a specific object (task, component, etc.).  This one has been out there for a while but only has a few votes.

Comments

Posted by Marc Beacom on 16 August 2009

Thanks for bringing these to our attention!

I agree on both items.  Documenting ssis has always been a pain as the tools just are not available to make it easy and efficient.  I spend more time than I'd care to acknowledge with these items.  

Posted by Steve Jones on 17 August 2009

Good idea, I added a vote as well. I think #2 is more important than #1, but both would be good.

Posted by Tim Mitchell on 17 August 2009

Definitely agree that the second one listed is more important.  The formatting and wrapping issue is irritating, but can be worked around.  The attachment of annotations to specific objects is a task that can't be done in the current product.

Posted by RBarryYoung on 22 August 2009

Agreed, Tim.  I have all but given up on annotations for anything other than the simplest most necessary comments.  Now I justput MS-Word documents into the package projects.  Not quite as closely bound as I would like, but at least I can be sure that there is proper documentation available.

Posted by DB_Newbie2007 on 15 October 2009

I would be happy if I could just get the annotations to wrap! ;)

I voted for #1... just in time, as the connect.microsoft.com website does not appear to be working at the moment to cast a vote for #2 also.

Leave a Comment

Please register or log in to leave a comment.