Monday, 11 April 2016

Annotation

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.

Popular Posts