SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

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.

Tim Mitchell

Tim Mitchell is a business intelligence consultant, author, trainer, and Microsoft Data Platform MVP with over thirteen years of data management experience. He is the founder and principal of Tyleris Data Solutions.

Tim has spoken at international and local events including the SQL PASS Summit, SQLBits, SQL Connections, along with dozens of tech fests, code camps, and SQL Saturday events. He 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 @Tim_Mitchell.


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.