How To Include Comments In SSIS Package [What is Annotation]

When we create TSQL objects such as Stored Procedure, Function etc., we put comments inside our code so we do not have to dig through code later to understand it when it comes to make some changes.

By putting comments we make sure if any other developer in our team needs to understand the program to make changes or execute,He/She can use these comments as document and understand quickly.

It is good practice to include comments even you write your code in any programming language. In SSIS Package, Annotations is provided that can be used to put our comments inside SSIS Package. Annotations are available in Control Flow, Data Flow and Event Handler design surfaces of SSIS Designer.

To put Annotations, Right Click in design surface in any Pane( Control Flow, Data Flow or Event Handler)

Fig 1: Right Click to Add Annotation

Once you Click Add Annotation , Text box will appear as shown below
Fig 2: Text Box to Add Comments by Clicking Add Annotation

Let's start writing our comments about the SSIS Package those can help us and other developer to understand this Package quickly. After writing first line of comment we want to go to next line. Let's hit Enter key. Only Enter is not going to take you to next line if you are using BIDS. Press Ctrl and then hit Enter. It will take you to next line.

Fig 3: Adding multiple line of comments


Fig 4: Multiple line of comments

If we are using SQL Server Data Tools (SSDT) then Enter key will take you to next line.
Fig 5: Adding Annotation when using SSDT.

If you try to select the comments you have written and copy, The copy option is grayed out. Select the text and then press Ctrl+C to copy the text.


If you would like to watch video how to Write comments in SSIS Package, check below video

28 comments:

  1. I would also motivate just about every person to save this web page for any favorite assistance to assist posted the appearance.and if you need Foundation Company then contact us!

    ReplyDelete
  2. Somewhere the content of the blog surrounded by little arguments. Yes it is healthy for readers. They can include this kind of language in their writing skill as well as while group discussion in college.
    Fulfilment center

    ReplyDelete
  3. "Thanks for sharing. Very nice blog. Get the viral magical short video app Likee and watch the latest goldmovie21 videos online.

    "

    ReplyDelete
  4. educational paper writing want to be a hundred% precise and grammatical errors free as purchaser always appears for a professional writer who can help with superb writing issuer and can show expertise thru their writing talent. concept of author is notably preferred.

    ReplyDelete
  5. There are a lot increasingly different pointers to qualified specialist organizations. By the by, it is significant for your remarks to be taken care of by a certified specialist .blog comment service

    ReplyDelete
  6. Professionally written blogs are rare to find, however I appreciate all the points mentioned here. I also want to include some other writing skills which everyone must aware of.
    London Family offices

    ReplyDelete
  7. This blog is truly useful to convey overhauled instructive undertakings over web which is truly examination. I discovered one fruitful case of this truth through this blog. I will utilize such data now.
    Best surge protector

    ReplyDelete
  8. Thanks for the post and great tips..even I also think that hard work is the most important aspect of getting success..
    licenta windows 10

    ReplyDelete
  9. This comment has been removed by the author.

    ReplyDelete
  10. I am thankful to this blog for assisting me. I added some specified clues which are really important for me to use them in my writing skill. Really helpful stuff made by this blog. Belastingadviseurs utrecht

    ReplyDelete
  11. Nice to read this publication on this blog. As far as I can see, this is a very basic question for everyone indeed. Its my personal opinion and I am completely agreed with the subject used here
    Surge filter

    ReplyDelete
  12. I am grateful for this blog to distribute knowledge about this significant topic. Here I found different segments and now I am going to use these new instructions with new enthusiasm.
    Nirav Gandhi an Commerce

    ReplyDelete
  13. Sometime few educational blogs become very helpful while getting relevant and new information related to your targeted area. As I found this blog and appreciate the information delivered to my database.
    Nirav Gandhi Canada

    ReplyDelete
  14. significant for an essayist as it can essentially impact the achievement or disappointment of the book. Cooperate Identity design

    ReplyDelete
  15. On the off chance that a writer selects independently publishing he additionally needs to focus on another significant part of the book for example covers structure. Cooperate Identity design

    ReplyDelete
  16. Be that as it may, the outcome being I abandoned my fantasies and objectives of online business. Throughout the following scarcely any years not in any case taking a gander at business advertisements or anything looking like a business opportunity. Cooperate Identity design

    ReplyDelete
  17. academic blogs are absolutely beneficial to supply updated academic affairs over net it truly is truely appraisable. i found one a hit instance of this fact via this blog. i'm going to use such records now.bioresonantie veendam

    ReplyDelete
  18. This is kind of a modest representation of the truth, yet in the event that you take a gander at YouTube, they just as of late arrived at one billion perspectives for each day.https://y.tools/contact-us/

    ReplyDelete
  19. This blog is truly useful to convey overhauled instructive undertakings over web which is truly examination. I discovered one fruitful case of this truth through this blog. I will utilize such data now.
    Nirav Gandhi an Commerce

    ReplyDelete
  20. After research a couple of of the weblog posts in your website now, and I really like your method of blogging. I bookmarked it to my bookmark website record and will probably be checking back soon. Pls check out my site as effectively and let me know what you think. service de cybersécurité

    ReplyDelete
  21. Wow, superb blog layout! How long have you been blogging for? you make blogging look easy. The overall look of your site is magnificent, as well as the content! developpement web

    ReplyDelete
  22. I high appreciate this post. It’s hard to find the good from the bad sometimes, but I think you’ve nailed it! would you mind updating your blog with more information writing service

    ReplyDelete