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

avatar image

31 1 1 3

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

1 answer: sort voted first

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

avatar image

40.4k 39 84 166

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.

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: 7402 times

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

Copyright 2016 Redgate Software. Privacy Policy