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.

asked Jan 13 '11 at 10:54 AM in Default

ptj
31 ● 1 ● 1 ● 1

(comments are locked)

1 answer:

A simple way is to name the packages differently. Such as Customer_Extract, Customer_Extract_dev.

answered Jan 13 '11 at 11:06 AM

Tim
31.5k ● 20 ● 30 ● 116

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 '11 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 '11 at 11:22 AM Tim

@ptj, does this annotation feature work for your needs?

Jan 13 '11 at 01:57 PM Tim

TRAD, that works and is simple, thanks

Jan 13 '11 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 '11 at 06:13 PM Tim

(comments are locked)