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

SSIS Denali Annotations

I have written a couple quick blogs recently sharing some of the new usability changes for SSIS in Denali.  In previous posts I wrote about Resolve References and Data Flow Grouping. 

Today I am writing about another quick tidbit.  Annotations are a feature that has been available in previous versions of SSIS.  Essentially, they are ways of leaving notes in your package about what is going on with it.  People often use annotations to type version change notes of a package or explain what steps in the package are doing.

There is no change in the creation of annotations from previous versions of SSIS to Denali.  You simply right-click on the design surface and click Add Annotation then type your note. 

The difference that you will find is that you are no longer forced to hit CTRL+ENTER to apply carriage returns in the annotation box.  You simply hit the ENTER button and it takes you to the next line!  I know this seems like a simply change but these are the little things that really annoy an SSIS developer.

Devin Knight

Devin is a BI consultant at Pragmatic Works Consulting. Previously, he has tech edited the book Professional Microsoft SQL Server 2008 Integration Services and was an author in the book Knight's 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services. Devin has spoken at past conferences like PASS and at several SQL Saturday events. He is a contributing member to the Business Intelligence Special Interest Group (SIG) for PASS as a leader in the SSIS Focus Group. Making his home in Jacksonville, FL, Devin is a participating member of the local users’ group (JSSUG).


Posted by Paul Blackwell-319608 on 1 December 2010


Great post and if you or your client are not quite ready to move to Denali, you can still word wrap your annotations as well as add background colors, justify your text (left, right, center), make read only or persist empty annotations all by setting certain hexidecimal digits in the binary stream.

Leave a Comment

Please register or log in to leave a comment.