notes or comments in ssis package

Question

question

ptj asked Jan 13, '11

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.

ssis package comments

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2011-01-13T11:06:34Z

Tim answered Jan 13, '11

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

5

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Tim commented · Jan 13, 2011 at 11:22 AM

Yes, in the Control Flow right click and chose "add annotation" Type what ever message you want in the box. Hope this helps.

1 ·

ptj commented · Jan 13, 2011 at 11:16 AM

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.

0 ·

Tim commented · Jan 13, 2011 at 01:57 PM

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

0 ·

ptj commented · Jan 13, 2011 at 04:48 PM

TRAD, that works and is simple, thanks

0 ·

Tim commented · Jan 13, 2011 at 06:13 PM

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.

0 ·

question