Use Annotations in Packages


Applies To: SQL Server 2016

The SSIS Designer provides annotations, which you can use to make packages self-documenting and easier to understand and maintain. You can add annotations to the control flow, data flow, and event handler design surfaces of SSIS Designer. The annotations can contain any type of text, and they are useful for adding labels, comments, and other descriptive information to a package. Annotations are a design-time feature only. For example, they are not written to logs.

When you press ENTER, the text wraps to the next line. The annotation box automatically increases in size as you add additional lines of text. Package annotations are persisted as clear text in the CDATA section of the package file.

For more information about changes to the format of the package file, see SSIS Package Format.

When you save the package, SSIS Designer saves the annotations in the package.

To add an annotation to a package

Community Additions