question

ptj avatar image
ptj asked

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.
ssispackagecomments
10 |1200

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

1 Answer

·
Tim avatar image
Tim answered
A simple way is to name the packages differently. Such as Customer_Extract, Customer_Extract_dev.
5 comments
10 |1200

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

Yes, in the Control Flow right click and chose "add annotation" Type what ever message you want in the box. Hope this helps.
1 Like 1 ·
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 Likes 0 ·
@ptj, does this annotation feature work for your needs?
0 Likes 0 ·
TRAD, that works and is simple, thanks
0 Likes 0 ·
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 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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