Printed 2017/07/24 04:09AM

SSIS Package Annotation in Denali

By Brian K. McDonald, 2010/11/30

If you are anything like me, you document your SSIS packages for those who may have to maintain them after you move on to other projects. One thing that have disliked is how annotations worked in SSIS. There is no word wrap setting to automatically wrap to the next line, nor could you just hit the enter key to get to the next line. You had to hit CTRL along with the ENTER key to do this. I found it slightly annoying, but like any other annoyances, we accept it for what it is! J Annotations have changed in Denali! Yeah…Hoorah….I know…it’s really not that big of a deal, but hey… it’s worth mentioning.


Here is a screenshot of how SSIS 2005 and 2008 handled annotations longer than the object and didn’t have an carriage return line feeds using the CTRL+ENTER that I mentioned above.


Figure 1: Old Annotations (2005 & 2008)

Old Package Annotations


Figure 2: New Annotations (DENALI)

New Annotations 


As you can see, they have made a few visual and usability enhancements to the annotation object within SSIS for Denali. Thank you Microsoft! J You really can’t see too much by the screenshot other than the visual enhancement, but just know that I didn’t hit enter one time. If I had, it would just start a new line for me. No more CTRL+ENTER. J


I hope that you have enjoyed this post. If you did, please take just a moment to rate it below! Also, if you don’t already, please be sure to follow me on twitter at @briankmcdonald. Also note that you can subscribe to an RSS feed of my blogs or find me at any of the below methods.



Brian K. McDonald, MCDBA, MCSD
Business Intelligence Consultant – Pragmatic Works


Blogs: SQLBIGeek | SQLServerCentral | BIDN | SQLServerPedia

Twitter: @briankmcdonald




Copyright © 2002-2017 Redgate. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.