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.
Lets learn how to use Annotation.
I am opening the package.
Right click on the control flow.
Click on the Add Annotation.
Similarly we can use Annotation on Data flow and Event
Handler pane.
Drawback
If you use formatting then Annotation will be misplace.
Let’s see.
So After using Annotation please do not formatting.
Thanks.
No comments:
Post a Comment
If you have any doubt, please let me know.