SSIS - How to Use Data Viewer in SSIS Package

Scenario:

Let’s say we are developing a package and it extracts some records from source, Implement some business logic by using different transformations and finally load into destination (table/file). When we look at destination, record is incorrect but we are not sure what happen to source record. We want to see the change in record/records after each of transformation to find out which logic is not working correctly.

Solution:

SQL Server Integration Services (SSIS) provided Data Viewer in Data Flow Task. Data Viewer can be used between two transformations to see the data. When we executes our package Data Viewer pop up window shows data so we can see What is changed from Input to Output.

In this example we are extracting few records from Source, We want to see what we are extracting. We have used aggregate transformation that is grouping by CountryName and doing Sum operation on SaleAmount. We can create second data viewer after Aggregate transformation to see the data.
To use Data Viewer between Transformations, Double click on green connection that exists between two transformations, it will open Data Viewer Editor (Data Flow Path Editor).

There are three options on Left Pane
General: Provides general information
MetaData : Provided meta data information of columns
Data Viewer: This is the tab where we will be able to select the column those we want to include in Data View.

In SSIS 2008/ R2 and previous versions where other options were available in Data Viewer, those options are removed. The only Grid option is left in SSIS 2012 and latest versions and that is even not called Grid anymore but only Data Viewer.


Data Viewer Configuration window in SSIS 2008R2 and old


SSIS 2012  and latest versions Data Viewer Editor

Data Viewer Editor Window with only Data Viewer Tab in SSIS 2012 and Latest versions

Once data viewers are created, we can execute our package. We will be able to see data at different stages of execution.

How to use Data Viewer in SSIS Package to view data while debugging SSIS Package
We can hit Play button in Data Viewer Output window to go to next Data Viewer. The data can also be copied from Data Viewer and used for testing.


116 comments:

  1. Data Technology-'IT'- is costly. Each CEO, CFO, COO-practically every supervisor at each degree of each organization in presence realizes that certain reality.ExcelR Data Science Courses

    ReplyDelete
  2. I think DataViewer is actually a very good tool to learn more about some good aspects of SSIS and PostgreSQL.

    SSIS PostgreSql Write

    ReplyDelete
  3. This is a topic that's near to my heart... Cheers! Where are your contact details though? onsite mobile repair bangalore I absolutely love your blog.. Very nice colors & theme. Did you build this website yourself? Please reply back as I’m wanting to create my own personal site and would like to find out where you got this from or what the theme is called. Thanks!
    asus display repair bangalore I really like it whenever people get together and share opinions. Great blog, keep it up! huawei display repair bangalore

    ReplyDelete
  4. Very good info. Lucky me I discovered your blog by chance (stumbleupon). I have book-marked it for later! online laptop repair center bangalore This website was... how do you say it? Relevant!! Finally I have found something that helped me. Thanks! dell repair center bangalore

    ReplyDelete
  5. Everything is very open with a very clear clarification of the challenges. It was really informative. Your site is very useful. Many thanks for sharing! macbook repair center bangalore I would like to thank you for the efforts you've put in penning this blog. I really hope to check out the same high-grade content by you in the future as well. In fact, your creative writing abilities has motivated me to get my own, personal site now ;) acer repair center bangalore

    ReplyDelete
  6. Awesome blog. I enjoyed reading your articles. This is truly a great read for me. I have bookmarked it and I am looking forward to reading new articles. Keep up the good work!
    data analytics courses

    data science interview questions

    business analytics courses

    data science course in mumbai

    ReplyDelete
  7. You actually make it look so easy with your performance but I find this matter to be actually something which I think I would never comprehend. It seems too complicated and extremely broad for me. I'm looking forward for your next post, I’ll try to get the hang of it!
    ExcelR Machine Learning Courses
    ExcelR Artificial intelligence course in Mumbai

    ReplyDelete
  8. You actually make it look so easy with your performance but I find this matter to be actually something which I think I would never comprehend. It seems too complicated and extremely broad for me. I'm looking forward for your next post, I’ll try to get the hang of it!
    PMP Certifications

    ReplyDelete
  9. This is a wonderful article, Given so much info in it, Thanks for sharing. CodeGnan offers courses in new technologies and makes sure students understand the flow of work from each and every perspective in a Real-Time environmen python training in vijayawada. , data scince training in vijayawada . , java training in vijayawada. ,

    ReplyDelete
  10. Impressive! I finally found great post here. Nice article on data science . It's really a nice experience to read your post. Thanks for sharing your innovative ideas to our vision.
    Data Science Course
    Data Science Course in Marathahalli
    Data Science Course Training in Bangalore

    ReplyDelete
  11. Great job for publishing such a beneficial web site. Your web log isn’t only useful but it is additionally really creative too. anaconda install tensorflow

    ReplyDelete
  12. Good post, Hi, your article was of great help. The way you shared the information is good, thanks.
    Machine Learning Training In Hyderabad

    ReplyDelete
  13. Expected to form you an almost no word to thank you once more with respect to the decent recommendations you've contributed here.
    Machine Learning Training In Hyderabad

    Machine Learning Course In Hyderabad

    ReplyDelete

  14. Thanks for nice blog regarding DevOps. Keep updating
    DevOps Training In Hyderabad

    ReplyDelete
  15. wonderful article. Very interesting to read this article.I would like to thank you for the efforts you had made for writing this awesome article. This article resolved my all queries.
    Data science Interview Questions
    Data Science Course

    ReplyDelete
  16. keep up the good work. this is an Ossam post. This is to helpful, i have read here all post. i am impressed. thank you. this is our courses in data analytics
    courses in data analytics | https://www.excelr.com/data-analytics-certification-training-course-in-mumbai

    ReplyDelete
  17. Thanks for sharing such a informative blog with us. Keep on sharing
    Azure Training In Hyderabad

    ReplyDelete
  18. Attend The Machine Learning Course Bangalore From ExcelR. Practical Machine Learning course Bangalore Sessions With Assured Placement Support From Experienced Faculty. ExcelR Offers The Machine Learning course Bangalore.
    Machine Learning Course Bangalore

    ReplyDelete
  19. Nice Post ! really enjoyed reading this article. Thanks for sharing such detailed information.
    AI Training in Hyderabad

    ReplyDelete
  20. Great article like this require readers to think as they read. I took my time when going through the points made in this article. I agree with much this information.
    Best Data Science training in Mumbai

    Data Science training in Mumbai

    ReplyDelete
  21. keep up the good work. this is an Ossam post. This is to helpful, i have read here all post. i am impressed. thank you. this is our data science training in mumbai
    data science training in mumbai | https://www.excelr.com/data-science-course-training-in-mumbai

    ReplyDelete
  22. wonderful article. Very interesting to read this article.I would like to thank you for the efforts you had made for writing this awesome article. This article resolved my all queries. keep it up.
    data analytics course in Bangalore

    ReplyDelete
  23. wonderful article. Very interesting to read this article.I would like to thank you for the efforts you had made for writing this awesome article. This article resolved my all queries. keep it up.
    data analytics course in Bangalore

    ReplyDelete
  24. Good Article, the information you provided is helpful for me
    Data Science Training In Hyderabad

    ReplyDelete
  25. thanks for sharing nice information. its Very use full and informative and keep sharing.
    more : https://www.analyticspath.com/machine-learning-training-in-hyderabad

    ReplyDelete
  26. Wonderful post, i loved reading it.
    Share more
    Sysprogs
    Unicube
    Liveatthebike

    ReplyDelete
  27. thanks for sharing nice information.....
    more : https://www.kellytechno.com/Hyderabad/Course/Data-Science-Training

    ReplyDelete
  28. Nice articles .Thanks for sharing wonderful Articles with us. I am learn more from your articles.
    DevOps Training In Hyderabad

    ReplyDelete
  29. I normally wouldn't be so engaged by any articles pertaining to this subject, but yours grabbed my attention. It was like a great dessert crying out to me to eat it. This is good content.
    SAP training in Kolkata
    Best SAP training in Kolkata
    SAP training institute in Kolkata

    ReplyDelete
  30. I normally wouldn't be so engaged by any articles pertaining to this subject, but yours grabbed my attention. It was like a great dessert crying out to me to eat it. This is good content.
    SAP training in Kolkata
    Best SAP training in Kolkata
    SAP training institute in Kolkata

    ReplyDelete
  31. I have to agree with the valid points you make in your article because I see things like you. Additionally, your content is interesting and really good reading material. Thank you for sharing your talent.
    SAP training in Mumbai
    Best SAP training in Mumbai
    SAP training institute Mumbai

    ReplyDelete
  32. Attend The Machine Learning Courses in Bangalore From ExcelR. Practical Machine Learning courses in Bangalore Sessions With Assured Placement Support From Experienced Faculty. ExcelR Offers The Machine Learning courses in Bangalore.
    Machine Learning Courses in Bangalore

    ReplyDelete
  33. Hey, i liked reading your article. You may go through few of my creative works here
    Riosabeloco
    Systemcentercentral

    ReplyDelete
  34. The context has been explained really well. Looking forward to see more of such informative updates
    Machine Learning Training in Hyderabad

    ReplyDelete
  35. Thanks for Information Oracle Apps Technical is a collection of a bunch of collected applications like accounts payables, purchasing, inventory, accounts receivables, human resources, order management, general ledger and fixed assets, etc which have its own functionality for serving the business
    Microsoft Windows Azure Training | Online Course | Certification in chennai | Microsoft Windows Azure Training | Online Course | Certification in bangalore | Microsoft Windows Azure Training | Online Course | Certification in hyderabad | Microsoft Windows Azure Training | Online Course | Certification in pune

    ReplyDelete
  36. Very interesting to read this article.I would like to thank you for the efforts you had made for writing this awesome article. This article inspired me to read more. keep it up.
    Correlation vs Covariance

    ReplyDelete
  37. Very interesting blog. Many blogs I see these days do not really provide anything that attracts others, but believe me the way you interact is literally awesome.You can also check my articles as well.

    Data Science In Banglore With Placements
    Data Science Course In Bangalore
    Data Science Training In Bangalore
    Best Data Science Courses In Bangalore
    Data Science Institute In Bangalore

    Thank you..

    ReplyDelete
  38. Very interesting blog. Many blogs I see these days do not really provide anything that attracts others, but believe me the way you interact is literally awesome.You can also check my articles as well.

    Data Science In Banglore With Placements
    Data Science Course In Bangalore
    Data Science Training In Bangalore
    Best Data Science Courses In Bangalore
    Data Science Institute In Bangalore

    Thank you..

    ReplyDelete
  39. Very interesting to read this article.I would like to thank you for the efforts you had made for writing this awesome article. This article inspired me to read more. keep it up.
    Correlation vs Covariance
    Simple linear regression

    ReplyDelete
  40. Very interesting to read this article.I would like to thank you for the efforts you had made for writing this awesome article. This article inspired me to read more. keep it up.
    Correlation vs Covariance
    Simple linear regression

    ReplyDelete
  41. This is a great inspiring article. I am pretty much pleased with your good work. You put really very helpful information.
    Artificial Intelligence Training in Hyderabad
    Artificial Intelligence Course in Hyderabad

    ReplyDelete
  42. The context has been explained really well. Looking forward to see more of such informative updates
    Machine Learning Training in Hyderabad

    ReplyDelete
  43. I like your post. Everyone should do read this blog. Because this blog is important for all now I will share this post. Thank you so much for share with us.
    DevOps Training in Hyderabad
    DevOps Course in Hyderabad

    ReplyDelete
  44. I would you like to say thank you so much for my heart. Really amazing and impressive post you have the share. Please keep sharing
    Data Science Training in Hyderabad
    Data Science Course in Hyderabad

    ReplyDelete
  45. Great things you’ve always shared with us. Just keep writing this kind of posts.The time which was wasted in traveling for tuition now it can be used for studies.Thanks get free instagram likes reddit

    ReplyDelete
  46. Really Very Infromative Post , Thanks For Sharing The Information With Us.
    Best AWS Training in Hyderabad

    ReplyDelete
  47. After reading your article I was amazed. I know that you explain it very well. And I hope that other readers will also experience how I feel after reading your article.
    machine learning courses in bangalore

    ReplyDelete
  48. Great post, and great website. Thanks for the information! data entry bpo solutions

    ReplyDelete
  49. We have a real time instructor for training. Our coach has 4 to 8 years' experience in training. artificial intelligence courses in hyderabad

    ReplyDelete
  50. The development of artificial intelligence (AI) has propelled more programming architects, information scientists, and different experts to investigate the plausibility of a vocation in machine learning. Notwithstanding, a few newcomers will in general spotlight a lot on hypothesis and insufficient on commonsense application. machine learning projects for final year In case you will succeed, you have to begin building machine learning projects in the near future.

    Projects assist you with improving your applied ML skills rapidly while allowing you to investigate an intriguing point. Furthermore, you can include projects into your portfolio, making it simpler to get a vocation, discover cool profession openings, and Final Year Project Centers in Chennai even arrange a more significant compensation.


    Data analytics is the study of dissecting crude data so as to make decisions about that data. Data analytics advances and procedures are generally utilized in business ventures to empower associations to settle on progressively Python Training in Chennai educated business choices. In the present worldwide commercial center, it isn't sufficient to assemble data and do the math; you should realize how to apply that data to genuine situations such that will affect conduct. In the program you will initially gain proficiency with the specialized skills, including R and Python dialects most usually utilized in data analytics programming and usage; Python Training in Chennai at that point center around the commonsense application, in view of genuine business issues in a scope of industry segments, for example, wellbeing, promoting and account.

    ReplyDelete
  51. I just got to this amazing site not long ago. I was actually captured with the piece of resources you have got here. Big thumbs up for making such wonderful blog page!

    machine learning courses in bangalore

    ReplyDelete
  52. I just got to this amazing site not long ago. I was actually captured with the piece of resources you have got here. Big thumbs up for making such wonderful blog page!

    machine learning courses in bangalore

    ReplyDelete
  53. The development of artificial intelligence (AI) has propelled more programming architects, information scientists, and different experts to investigate the plausibility of a vocation in machine learning. Notwithstanding, a few newcomers will in general spotlight a lot on hypothesis and insufficient on commonsense application. machine learning projects for final year In case you will succeed, you have to begin building machine learning projects in the near future.

    Projects assist you with improving your applied ML skills rapidly while allowing you to investigate an intriguing point. Furthermore, you can include projects into your portfolio, making it simpler to get a vocation, discover cool profession openings, and Final Year Project Centers in Chennai even arrange a more significant compensation.


    Data analytics is the study of dissecting crude data so as to make decisions about that data. Data analytics advances and procedures are generally utilized in business ventures to empower associations to settle on progressively Python Training in Chennai educated business choices. In the present worldwide commercial center, it isn't sufficient to assemble data and do the math; you should realize how to apply that data to genuine situations such that will affect conduct. In the program you will initially gain proficiency with the specialized skills, including R and Python dialects most usually utilized in data analytics programming and usage; Python Training in Chennai at that point center around the commonsense application, in view of genuine business issues in a scope of industry segments, for example, wellbeing, promoting and account.

    ReplyDelete
  54. I just got to this amazing site not long ago. I was actually captured with the piece of resources you have got here. Big thumbs up for making such wonderful blog page!
    Data Analyst Course

    ReplyDelete
  55. Your current tunes can be remarkable. You've got a number of quite accomplished musicians. My spouse and i would like anyone the top involving good results. offline data entry services

    ReplyDelete
  56. After reading your article I was amazed. I know that you explain it very well. And I hope that other readers will also experience how I feel after reading your article.

    data science courses

    ReplyDelete

  57. Very interesting blog Thank you for sharing such a nice and interesting blog and really very helpful article.
    Data Science Course in Hyderabad

    ReplyDelete
  58. Very interesting to read this article.I would like to thank you for the efforts you had made for writing this awesome article. This article inspired me to read more. keep it up.
    Correlation vs Covariance
    Simple linear regression
    data science interview questions

    ReplyDelete
  59. Such a very useful article. Very interesting to read this article.I would like to thank you for the efforts you had made for writing this awesome article.

    Simple Linear Regression

    Correlation vs Covariance

    ReplyDelete
  60. I really loved reading your blog. It was very well authored and easy to undertand. Unlike additional blogs I have read which are really not tht good. I also found your posts very interesting. In fact after reading. I had to go show it to my friend and he ejoyed it as well! bookkeeper data entry

    ReplyDelete
  61. This Was An Amazing ! I Haven't Seen This Type of Blog Ever ! Thankyou For Sharing, data sciecne course in hyderabad

    ReplyDelete
  62. Thank you for the update, very nice site.. data entry ebook

    ReplyDelete
  63. This Was An Amazing ! I Haven't Seen This Type of Blog Ever ! Thankyou For Sharing, data sciecne course in hyderabad

    ReplyDelete
  64. I really loved reading your blog. I also found your posts very interesting. In fact, after reading, I had to go show it to my friend and he enjoyed it as well!!!!
    Machine Learning Training in Hyderabad
    Machine Learning Course in Hyderabad

    ReplyDelete
  65. This Was An Amazing ! I Haven't Seen This Type of Blog Ever ! Thankyou For Sharing
    Python Training in Hyderabad

    Best PythonTraining Institutes in Hyderabad

    ReplyDelete
  66. Highly informative article. This site has lots of information and it is useful for us. Thanks for sharing your views.
    Data Science Training in Hyderabad
    Data Science Course in Hyderabad

    ReplyDelete
  67. This is an awesome post.Really very informative and creative contents. These concept is a good way to enhance the knowledge.

    AWS training in Hyderabad

    Best AWS training institutes in Hyderabad

    ReplyDelete
  68. Attend online training from one of the best training institute Data Science

    Course in Hyderabad

    ReplyDelete
  69. With the surge in popularity, these Services are on the go these days. Higher Efficiency: If your personnel are clear of routine and uninteresting procedure for entering information, they are able to deliver better result. quickbooks data entry outsource

    ReplyDelete
  70. With the surge in popularity, these Services are on the go these days. Higher Efficiency: If your personnel are clear of routine and uninteresting procedure for entering information, they are able to deliver better result. quickbooks data entry outsource

    ReplyDelete
  71. This Was An Amazing ! I Haven't Seen This Type of Blog Ever ! Thankyou For Sharing, data sciecne course in hyderabad

    ReplyDelete
  72. The development of artificial intelligence (AI) has propelled more programming architects, information scientists, and different experts to investigate the plausibility of a vocation in machine learning. Notwithstanding, a few newcomers will in general spotlight a lot on hypothesis and insufficient on commonsense application. machine learning projects for final year In case you will succeed, you have to begin building machine learning projects in the near future.

    Projects assist you with improving your applied ML skills rapidly while allowing you to investigate an intriguing point. Furthermore, you can include projects into your portfolio, making it simpler to get a vocation, discover cool profession openings, and Final Year Project Centers in Chennai even arrange a more significant compensation.


    Data analytics is the study of dissecting crude data so as to make decisions about that data. Data analytics advances and procedures are generally utilized in business ventures to empower associations to settle on progressively Python Training in Chennai educated business choices. In the present worldwide commercial center, it isn't sufficient to assemble data and do the math; you should realize how to apply that data to genuine situations such that will affect conduct. In the program you will initially gain proficiency with the specialized skills, including R and Python dialects most usually utilized in data analytics programming and usage; Python Training in Chennai at that point center around the commonsense application, in view of genuine business issues in a scope of industry segments, for example, wellbeing, promoting and account.


    The Nodejs Training Angular Training covers a wide range of topics including Components, Angular Directives, Angular Services, Pipes, security fundamentals, Routing, and Angular programmability. The new Angular TRaining will lay the foundation you need to specialise in Single Page Application developer. Angular Training

    ReplyDelete
  73. I am always read your blog. Thanks for providing informative information. Data science course in Mumbai
    Data science course in Pune

    ReplyDelete
  74. I just stumbled upon your blog and wanted to say that I have really enjoyed reading your blog posts. ExcelR Business Analytics Course Any way I’ll be subscribing to your feed and I hope you post again soon. Big thanks for the useful info.

    ReplyDelete
  75. Amazing and interesting blog found to be well written in a simple manner that everyone will understand and gain the enough knowledge from your blog being more informative is an added advantage for the users who are going through it. Once again nice blog keep it up.
    DevOps Training in Chennai

    DevOps Online Training in Chennai

    DevOps Training in Bangalore

    DevOps Training in Hyderabad

    DevOps Training in Coimbatore

    DevOps Training

    DevOps Online Training

    ReplyDelete
  76. The easiest way to start, if you don't have a business to promote, is to create a Facebook page and try to build awareness of it. digital marketing course in hyderabad

    ReplyDelete
  77. An excellent article, very informative. It is not every day that I have the possibility to see something like this. thanksdata science course in Hyderabad

    ReplyDelete
  78. I have express a few of the articles on your website now, and I really like your style of blogging. I added it to my favorite’s blog site list and will be checking back soon…
    Machine Learning Courses in Pune I really enjoy reading and also appreciate your work.
    I have bookmarked your website because this site contains valuable information in it. I am really happy with articles quality and presentation. Thanks a lot for keeping great stuff. I am very much thankful for this site.

    ReplyDelete
  79. Hence the terms 'Big data' and 'Data science' were coined. Big data has made quite an impact on the world and data science has recently risen to be one of the hottest topics. Now how are these two related? data science course in hyderabad

    ReplyDelete
  80. The information that you have shared is really useful for everyone.
    Microsoft Azure DevOps Online Training

    ReplyDelete
  81. I like your post. Everyone should do read this blog. Because this blog is important for all now I will share this post. Thank you so much for share with us.
    DevOps Training in Hyderabad
    DevOps Course in Hyderabad

    ReplyDelete
  82. Nice information thanks for sharing it’s very useful. This article gives me so much information.
    AWS Training in Hyderabad
    AWS Course in Hyderabad

    ReplyDelete
  83. I see the greatest contents on your blog and I extremely love reading them. inventory data entry

    ReplyDelete
  84. I would you like to say thank you so much for my heart. Really amazing and impressive post you have the share. Please keep sharing
    Data Science Training in Hyderabad
    Data Science Course in Hyderabad

    ReplyDelete
  85. Machine Learning Courses in Pune I really enjoy reading and also appreciate your work. I read that Post and got it fine and informative. Please share more like that...
    I have bookmarked your website because this site contains valuable information in it. I am really happy with articles quality and presentation. Thanks a lot for keeping great stuff. I am very much thankful for this site.

    ReplyDelete
  86. It’s very informative and you are obviously very knowledgeable in this area. You have opened my eyes to varying views on this topic with interesting and solid content.
    data science courses

    ReplyDelete
  87. Amazing Article ! I would like to thank you for the efforts you had made for writing this awesome article. This article inspired me to read more. keep it up.
    Correlation vs Covariance
    Simple Linear Regression
    data science interview questions
    KNN Algorithm
    Logistic Regression explained

    ReplyDelete
  88. Amazing Article ! I would like to thank you for the efforts you had made for writing this awesome article. This article inspired me to read more. keep it up.
    Correlation vs Covariance
    Simple Linear Regression
    data science interview questions
    KNN Algorithm
    Logistic Regression explained

    ReplyDelete
  89. Great Article… I love to read your articles because your writing style is too good, it is very very helpful for all of us and I never get bored while reading your article because they are becomes more and more interesting from the starting lines until the end.

    DevOps Training in Hyderabad

    ReplyDelete
  90. Very nice blogs!!! i have to learning for lot of information for this sites…Sharing for wonderful information.Thanks for sharing this valuable information to our vision. You have posted a trust worthy blog keep sharing, data science courses

    ReplyDelete