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
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.
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!
ReplyDeleteHerbie is the foremost Chatbot Companies in UAE. Our Artificial Intelligence Technology is different from Chatbot Development Companies. We are specialized in AI Conversational Chatbots and Virtual Assistant Chatbot. Herbie is most intelligent Virtual Assistant ever developed by AI Chatbot Companies
DeleteSomewhere 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.
ReplyDeleteFulfilment center
Nice Blog Thanks for Sharing.
ReplyDeletecompanies address with hr email ids
list of companies in delhi ncr with email address
list of mnc companies in delhi ncr with contact details
Many thanks for share your blog site here. Professional Packers And Movers
ReplyDelete"Thanks for sharing. Very nice blog. Get the viral magical short video app Likee and watch the latest goldmovie21 videos online.
ReplyDelete"
طرق مكافحة الحمام
ReplyDeleteشركة تركيب طارد حمام بالرياض
شركة طارد حمام بالرياض
شركة طارد حمام بالرياض
شركة مكافحة حمام بالرياض
تركيب شبك حمام بالرياض
مكافحة الحمام والطيور بالرياض
We read your blog , share most useful information in blog . Best Movers And Packers In Delhi
ReplyDeleteeducational 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.
ReplyDeleteThere 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
ReplyDeleteHey friend, it is very well written article, thank you for the valuable and useful information you provide in this post. Keep up the good work! FYI, please check these related articles:
ReplyDeleteशनि देव की आरती – Shani Dev Ki Aarti,
Jai Ambe Gauri Aarti – जय अम्बे गौरी आरती,
Aarti Shri Ramayan Ji Ki – श्री रामायणजी की आरती,
Shri Ram Aarti – आरती श्री रामचन्द्रजी,
Shri Hanuman Chalisa – श्री हनुमान चालीसा,
3 Ganesh Aarti – 3 गणेश आरती,
Shivaji ki Aarti – Om Jai Shiv Omkara | शिवजी की आरती – ओम जय शिव ओंकारा,
Thanks
Ritu Sharma
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.
ReplyDeleteLondon Family offices
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.
ReplyDeleteBest surge protector
Thanks for the post and great tips..even I also think that hard work is the most important aspect of getting success..
ReplyDeletelicenta windows 10
This comment has been removed by the author.
ReplyDeleteI 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
ReplyDeleteNice 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
ReplyDeleteSurge filter
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.
ReplyDeleteNirav Gandhi an Commerce
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.
ReplyDeleteNirav Gandhi Canada
significant for an essayist as it can essentially impact the achievement or disappointment of the book. Cooperate Identity design
ReplyDeleteOn 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
ReplyDeleteBe 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
ReplyDeleteacademic 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
ReplyDeleteThis 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/
ReplyDeleteThis 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.
ReplyDeleteNirav Gandhi an Commerce
Great post! I really enjoyed reading it. Keep sharing such articles. Looking forward to learn more from you.
ReplyDeleteBest SEO Company Chennai
Digital Marketing Freelancer in Chennai
Logo Design Freelancer Chennai
Web Design Company Chennai
Graphic Designing Company Chennai
Online Business Promotions
Digital Marketing Company in Chennai
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é
ReplyDeleteWow, 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
ReplyDeleteI 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
ReplyDeleteIt is worthwhile reading this blog. I was searching such kind of blog for a long time but now I think I got a blog of my interest. I am thankful for these all suggestions mentioned under this blog.bioresonantie utrecht
ReplyDeleteI am enjoying the photos of the galleries with the total of the all updates on the photos that have taken randomly there. Actually on those types of the meetings rare to take in that wills corporations of the random series. online flight tickets
ReplyDeleteThis is such a great resource that you are providing and you give it away for free.You have done a outstanding job! Wedding car hire
ReplyDeleteThis is such a great resource that you are providing and you give it away for free.You have done a outstanding job! English speaking courses
ReplyDeleteI feel very grateful that I read this. It is very helpful and very informative and I really learned a lot from it dubai web hosting
ReplyDeleteAwesome post, extremely instructive. I ask why alternate pros of this segment don't see this. You should proceed with your composition. I'm certain, you have an incredible perusers' base already!e of sound sustenance and acknowledging nourishment. Los angeles movers company
ReplyDeleteI am always searching online for storys that can accommodate me. There is obviously a multiple to understand about this. I feel you made few salubrious points in Attributes moreover. ClassyPrice
ReplyDeleteThis is in reality great to peruse substance of this blog. An is exceptionally broad and immense educated stage has been known by this blog. I as a general rule value this blog to have such sort of instructive information. Office moving los angeles
ReplyDeleteThis blog is really helpful to deliver updated educational affairs over internet which is really appraisable. I found one successful example of this truth through this blog. I am going to use such information now.bioresonantie veendam
ReplyDeleteI really appreciate this wonderful post that you have provided for us. I feel strongly that love and read more on this topic. I have spent a lot of my spare time reading your content. Thank you a lot.메이저놀이터
ReplyDeleteI feel extremely cheerful to have seen your site page and anticipate such a large number of all the more engaging circumstances perusing here. Much appreciated yet again for every one of the points of interest. Mobile Price in Bangladesh
ReplyDeleteBest Web design and development service company in toronto
ReplyDeleteTop website design company in brampton
Developing from a group of specialists to an undeniable top SEO office in Canada, we have confidence in persistently redesigning ourselves with the goal that we can offer the most recent types of assistance to our customers. At the point when google changes their calculation in the computerized world, we are the first to react, adjust, and change SEO methodology so your site stays at the top query output.
great ideas loved by What Mobile
ReplyDeleteTop Chauffeur service in Melbourne
ReplyDeleteWhether you need a last minute chauffeur car or a planned vehicle for your outing, book with us and get served on time. With well-mannered chauffeurs and finest vehicles, we arrange to pick and drop our customers with great punctuality. A hassle-free traveling experience waits at Silver Executive Cab for every customer
i have a site of Mobile Phone Prices i would add in it by following your tips
ReplyDeleteDetailed and descriptive articles written in this blog is really very helpful for me as well as for other who seeking such kind of knowledge. It is definitely going to become useful in coming future.bioresonantie utrecht
ReplyDeleteVery efficiently written information. It will be beneficial to anybody who utilizes it, including me. Keep up the good work. For sure i will check out more posts. This site seems to get a good amount of visitors.
ReplyDeletecustom web design melbourne
When do you think this Real Estate market will go back in a positive direction? Or is it still too early to tell? We are seeing a lot of housing foreclosures in Longwood Florida. What about you? I would love to get your feedback on this. nagapoker
ReplyDeleteTheir comic timing is great, and can still deliver the emotions when you need them to. nagapoker
ReplyDeleteExperience With My Roommates Girl friend
ReplyDeleteHi friends, I am Maxx not real name 24, with an athletic body type college sex video . I am a new reader of this site. I like many stories published in it. Today I want to share one of my sexual experiences which I enjoyed very much. It all started 4 months ago in Kolkata when I changed my job from Hyderabad to Kolkata. This is a very common thing in a BPO sector in the day of induction I met a cool guy Sunny, before long we became good friends.
Nice to be visiting your blog again, it has been months for me. Well this article that i've been waited for so long. I need this article to complete my assignment in the college, and it has same topic with your article. Thanks, great share. dewapoker
ReplyDeleteI think this is an informative post and it is very useful and knowledgeable. therefore, I would like to thank you for the efforts you have made in writing this article. nagapoker
ReplyDeleteHere in this blog, words themselves are creating that scenario where there is a lot of mayhem and serendipity along with a silent isolation. Rarely found to see such skill and enthusiasm.bioresonantie utrecht
ReplyDeleteThis content is simply exciting and creative. I have been deciding on a institutional move and this has helped me with one aspect. top porn site
ReplyDeleteThe article posted was 오션파라다이스게임 very informative and useful. I especially appreciate content that has to do with beauty and fitness, so it’s of particular interest to me to see what you have here. Thanks for sharing this with us.
ReplyDeleteNice to be visiting your blog again, it has been months for me. Well this article that i've been waited for so long. I need this article to complete my assignment in the college, and it has same topic with your article. Thanks, great share. Agen QQ Online
ReplyDeleteA debt of gratitude is in order for sharing us. a course in miracles teacher
ReplyDeleteI??m a blog crazed person and i also like to read cool blog like yours.??-,*?? niche related backlinks
ReplyDeleteGreat post, you have pointed out some great points, I besides believe this is a very wonderful website. niche related blog comments
ReplyDeleteGreat post man, keep the nice work, just shared this with the friendz niche related blog comments
ReplyDeleteIt is truly a nice and useful piece of info. I’m satisfied that you shared this useful information with us. Please keep us up to date like this. Thanks for sharing. manufacturer of 3ply face mask
ReplyDeleteFantastic data on your site, thank you for setting aside an ideal opportunity to impart to us. Astounding understanding you have on this current, it's decent to discover a site that subtle elements such a great amount of data about distinctive specialists. 먹튀업체
ReplyDeleteLove what you're doing here guys, keep it up you also go here: 토토프로
ReplyDeleteReally Nice Article & Thanks for sharing.
ReplyDeleteOflox Is The Best Website Design & Development Company In Dehradun
Really Nice Article & Thanks for sharing.
ReplyDeleteOflox Is The Best Website Design & Development Company In Dehradun
I’d should check with you here. Which is not some thing I usually do! I love reading a post that may get people to feel. Also, many thanks for permitting me to comment! 먹튀죄회
ReplyDeleteused trucks are sometimes expensive and it is quite hard to find a good bargain if you don’t search heavily- 먹튀안전
ReplyDeleteفنحن نقوم بكافة أعمال التنظيف للشقق والفلل والقصور نعمل على تنظيف كافة المنزل بداية من الأرضيات سواء كانت بلاط أو سراميك أو رخام و أيضا نقوم بتنظيف فرش الأرضيات سواء موكيت أو سجاد بأكثر من طريقة سواء باستخدام البخار أو بجهاز الرغوة الالية أو باستخدام الفرشاة الاليه. كما نقوم بتنظيف الأثاث بأجود المواد التي لا تؤثر على درجة الالوان أو حالة الأخشاب كما نقوم بتلميع الزجاج ممها بلغ ارتفاعة.
ReplyDeleteشركة غسيل موكيت بابها
شركة عزل خزانات بابها
شركة تنظيف خزانات المياه بابها
شركة تنظيف كنب بابها
شركة رش مبيدات بابها
شركة رش مبيدات بابها
شركة مكافحة الحشرات بابها
Very good post thanks for sharing with us visit now cats crash arena turbo stars mod apk and alight motion pro mod apk
ReplyDeleteI am always searching online for storys that can accommodate me. There is obviously a multiple to understand about this. I feel you made few salubrious points in Attributes moreover.
ReplyDeleteMobile Price in Bangladesh
It become an attractive part of a blog when author uses indirect speech while writing a blog. It shows your creative mind as well as make your written essay different from others.bioresonantie veendam
ReplyDeleteThanks for Sharing This Article.It is very so much valuable content. I hope these Commenting lists will help to my website
ReplyDeleteworkday studio online training
best workday studio online training
top workday studio online training
Your enthusiasm leads you beyond the limits. whilst you feel yourself enthusiastic that’s the time you can pass any restrict. you're searching out to get perfection through the usage of the functionality of exertions. study such motivational article and truely it'll permit you to recognize new data. Switchvox Hosting
ReplyDeleteconsummate case of hypothesis, compassion and expression. Here I took in another approach to theorize through writer's written work. It enabled me to feel another approach to estimate your considerations and express them in a simple and clear way. IP Office Hosting
ReplyDeleteA large portion of instructive data over various types of online journals don't such strong as steady every one of the purposes of this blog. You require not to locate whatever other stage to confirm the information expressed here. FreePBX Hosting
ReplyDeleteنحن نمتلك مجموعة من الخبراء والمتخصصين فى شركة تنظيف بابها ونحن نستطيع التعامل مع كافة المساحات المختلفة فلا يهم ان كنت تمتلك منزل او فيلا فأن لدينا خبرات كبيرة تمكنا من تقديم خدماتنا على اكمل وجه ولدينا عمال وفنيين محترفين ولهم خبرات مختلفة نقدم ايضآ تنظيف لواجهات الشركات والفنادق. فكل ما تحتاجه من معدات واجهزة ومنظفات ذات جودة عالمية موجودة بشركتنا فنحن نسعى فقط لارضاء العميل أولآ واخيرآ
ReplyDeleteشركة عزل خزانات بخميس مشيط
شركة مكافحة حشرات بخميس مشيط
شركة غسيل مجالس بخميس مشيط
شركة غسيل خزانات المياه بخميس مشيط
شركة غسيل خزانات بخميس مشيط
شركة تنظيف شقق بابها
Great post, please keep on sharing amazing article like this! It makes me happy reading your post nemzetközi szállítmányozás. https://europa-road.eu/
ReplyDeleteThis is such a great dentist esource that you are providing and you give it away for free. I love seeing websites that understand the value of providing a quality resource for free. It is the old what goes around comes around routine. rijlessen heerlen
ReplyDeleteThis 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. Cheap YouTube Services
ReplyDeletethanks for the tips and information..i really appreciate it.. 실시간스포츠중계
ReplyDeleteI have a hard time describing my thoughts on content, but I really felt I should here. Your article is really great. I like the way you wrote this information. best instagram followers app reddit
ReplyDeleteYou there, this is really good post here. Thanks for taking the time to post such valuable information. Quality content is what always gets the visitors coming. that link
ReplyDeleteThe data you have posted is exceptionally valuable. The locales you have alluded was great. A debt of gratitude is in order for sharing..
ReplyDeleteI as of late discovered numerous helpful data in your site particularly this site pagehendimovi
Thanks for the post and great tips: even I also think that hard work is the most important aspect of getting success.
ReplyDeleteYour blog provided us with valuable information to work with. Each & every tips of your post are awesome. Thanks a lot for sharing. Keep blogging,
Your website is really cool and this is a great inspiring article. Thank you so much.
Graphic desing
Super site! I am Loving it!! Will return once more, Im taking your food likewise, Thanks. censorship-resistant wiki
ReplyDeleteThank you for very usefull information.. Vancouver SEO Company
ReplyDeleteggc my courses
ReplyDeleteI admire what you have done here. I like the part where you say you are doing this to give back but I would assume by all the comments that this is working for you as well.
Bad Data can take you downhill and with no relevant report. data science course in hyderabad
ReplyDeletegreat post and very informative. best software development services in India
ReplyDeletesuperb article. good to read. best digital marketing company in Udaipur
ReplyDeletePersonal auto insurance flat out doesn't cover you, when you are using your car/vehicle as a delivery vehicle. It doesn't matter what type of business you work for, what type of food they sell, or what type of ownership the company has.
ReplyDeleteVisit this site:http://shomeservices.ae
This is such a great resource that you are providing and you give it away for free. I love seeing websites that understand the value of providing a quality resource for free. It is the old what goes around comes around routine. essay writing service
ReplyDeleteGreat post! I really enjoyed reading it. Keep sharing such articles. Looking forward to learn more from you.
ReplyDeleteBest Security Company in Chennai
Best Security Agency in Chennai
Best Security Agency in Trichy
Best Security Company in India
Best Security Agency in Chennai
Top Security Company in Chennai
Top Security Agency in Chennai
Top Gorkha Agency in Chennai
I like this post,And I figure that they having a ton of fun to peruse this post,they might take a decent site to make an information,thanks for sharing it to me. cheap essay
ReplyDeleteThanks for sharing these useful information! This is really interesting information for me.
ReplyDeleteAgarwal Packers and Movers, Packers and Movers, Movers and Packers
Packers and Movers Delhi
Packers and Movers Hyderabad
Packers and Movers Chennai
Packers and Movers Bangalore
Packers and Movers Mumbai
Agarwal Packers and Movers Blog
Agarwal Packers and Movers Blog | Packers and Movers Blog
Ramesh Agarwal | Ramesh Aggarwal Blog
I like this concept. I visited your blog for the first time and became your fan. Keep posting as I am going to read it everyday.thanks for this article
ReplyDeleteThis website and I conceive this internet site is really informative ! Keep on putting up! Niche SEO Backlink
ReplyDeleteInstagram has over 700 million active monthly users and its popularity continues to rocket as the cameras in smart phones become better at taking high-quality pics and videos. boost your business
ReplyDeleteThis comment has been removed by the author.
ReplyDeleteThis comment has been removed by the author.
ReplyDeleteBest web hosting Canada
ReplyDeletePro Website Hosting | Domain names & web hosting company offers domain name registration, web hosting, reseller hosting and SSL certificate for privacy protection. Enquire now.
Excellent post. I was reviewing this blog continuously, and I am impressed! Extremely helpful information especially this page. Thank you and good luck. 우리카지노
ReplyDeleteThis is really a nice and informative, containing all information and also has a great impact on the new technology. Check it out here:اخبار التقنية اليوم
ReplyDeleteThis is really a nice and informative, containing all information and also has a great impact on the new technology. Check it out here:bóng đá trực tuyến
ReplyDeleteI recently came across your blog and have been reading along. I thought I would leave my first comment. I don't know what to say except that I have enjoyed reading. Nice blog. I will keep visiting this blog very often. 우리카지노
ReplyDeleteThey are very useful information provide. I like your content. Really it was so interesting read. Thanks for sharing nice information. Fashion bloggers in India
ReplyDeleteSuch a really nice information. They are very nice article. I like your content. Thanks for sharing nice information. Fashion bloggers in India
ReplyDeletehis blog is really great. The information here will surely be of some help to me. Thanks!
ReplyDeleteI enjoyed reading your article. Please make more interesting topics like this on.
ReplyDeleteI'll come back for more :) Digital Marketing Company in Jaipur
"Hi ! This is very informative & interesting article. Nice to read your blog post first time ever. I really appreciate this post. Thanks for sharing this awesome post. At LogisticsMart we help you to choose the Affordable and trusted Pakers and Movers in India Here you find the best tips House Shifting Services in Bangalore
ReplyDelete"
"Hi ! This is very informative & interesting article. Nice to read your blog post first time ever. I really appreciate this post. Thanks for sharing this awesome post. At LogisticsMart we help you to choose the Affordable and trusted Pakers and Movers in India Here you find the best tips House Shifting Services in Bangalore
ReplyDelete"
Your blog provided us with valuable information to work with. Each & every tips of your post are awesome. Thanks a lot for sharing. Keep blogging..
ReplyDeletebuy windows 10 cheap
I guess this blog is perfectly incomparable.
ReplyDeleteHello, your post is a really interesting topic. It helped me a lot. In fact I also have a website with content similar to your posts. Please stop by. Thank you! 토토사이트
ReplyDeleteKıbrıs Araç Kiralama, Ercan Havalimanı | Ayaz Rent a Car ® kıbrıs kiralık araç
ReplyDeleteThey’re a fantastic department; really communicative, proactive, and always hitting tight timelines.
ReplyDeletewebagency
Web Development Company
ReplyDeleteMobile app development
Android app development company
ios app development
ionic framework development
Hi, I’ve been a lurker around your blog for a few months. I love this article and your entire site! Looking forward to reading more! website development services
ReplyDeleteAsiaQQ adalah Situs Judi Online, BandarQQ, DominoQQ, PokerQQ, QQ Online, Situs QQ, Poker Online, Agen BandarQ Online 24 jam...https://1asiaqq.net/
ReplyDelete