notes or comments in ssis package

Is there a simple way to add notes or comments to a SSIS package? For example, if you have different versions of the same package, one is in production and the other is in a test environment, you may want to add some notes to the test version so that anyone reviewing it will be able to quickly know what is different from the production version.
more ▼

asked Jan 13, 2011 at 10:54 AM in Default

ptj gravatar image

31 1 1 1

(comments are locked)
10|1200 characters needed characters left

1 answer: sort newest
A simple way is to name the packages differently. Such as Customer_Extract, Customer_Extract_dev.
more ▼

answered Jan 13, 2011 at 11:06 AM

Tim gravatar image

36.4k 38 41 139

thanks TRAD for your quick response, but what I am looking for is a way to describe the changes between the two packages in a note or comment in the test version.
Jan 13, 2011 at 11:16 AM ptj
Yes, in the Control Flow right click and chose "add annotation" Type what ever message you want in the box. Hope this helps.
Jan 13, 2011 at 11:22 AM Tim
@ptj, does this annotation feature work for your needs?
Jan 13, 2011 at 01:57 PM Tim
TRAD, that works and is simple, thanks
Jan 13, 2011 at 04:48 PM ptj
Awesome. Glad to have helped out. If you don't mind go ahead and mark my answer as solving your issue so others can see you are no longer in need of assistance. Also welcome to SQL Server Central, I hope you like the site and will continue to use it.
Jan 13, 2011 at 06:13 PM Tim
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Jan 13, 2011 at 10:54 AM

Seen: 5348 times

Last Updated: Jan 13, 2011 at 10:54 AM