Floating FB popout byF5debug

SQL Server Integration Services (SSIS) – Part 58 – Data Viewers (Scatter Plot) in SSIS


This is part 58 of the series of article on SSIS


In this article we are going to see on how to use the Data viewers (Scatter Plot) in SSIS packaging. Data viewers are used as one of the debugging option for the developers to check the data between the processes of a packaging. Data viewers are good at places where we have a minimum data to analyze and then executing the package at the development stage to see the changed took place in the prior task and proceed to the next task. Let’s jump start to see this sample on how to set the properties of the control.

You can look into my series of article on SSIS at the url - http://f5debug.net/tutorial/ssis.aspx



Follow steps 1 to 3 on my first article to open the BIDS project and select the right project to work on integration services project. Once the project is created, we will see on how to use the data viewers to see the data flow. Now once the project is opened drag and drop a source and a destination task along with a dataflow to do some manipulation as shown below


Now we will do a small task on copying the data from the source table to a destination file using the OLEDB source and FlatFile destination as shown above.

Now let’s configure both the tasks to make a flow as shown below

Source Configuration:


Destination Configuration:


Now your screen looks like below after the configuration is completed


Now when we execute the package it will do the execution but we are not sure at what point what happens. So in order to see the transformation between the source and the destination we can use a data viewer browser.

Data viewer provides different options to view the data, the types are: Grid, Histogram, Scatter Plot, and Chart Format.  In this sample we will see on how to use the Scatter Plot option to view. To start the data viewer Right click on the green arrow which connects the source and destination and select the data viewer. It will open the window as shown below


Now click on Add button to do the configuration of our required data viewer. It will open the window as shown below


Now we will select the Scatter plot(x,y) since we are going to see on how to use the Scatter plot. We have a tab Scatter Plot just navigate to that tab and select the column as shown below


Now we are done with the configuration and ready to execute the package. We can see a viewer icon next to the arrow as shown below which indicates that the viewer is active to view.


Now we will execute the package and see the data viewer browser. Press F5 to execute the package and we can see the data viewer browser as shown in the below screen


We have an arrow button in the browser, once we are done with our analysis we can click on the button to proceed. Once we click that button the execution start and proceed further and the final screen will appear as below



So in this article we have seen on how to use the data viewer (Scatter Plot) to analyze the data and to proceed further which acts like a debugging portion for SSIS packaging

About Author: Karthikeyan Anbarasan, Microsoft MVP (Most Valuable Professional) in ASP.NET/IIS Architecture. He is the Founder and Chief Editor of the www.f5debug.net website and has authored books on Windows Phone and Business Intelligence(SSIS). He is also a Passionate Speaker and a Blogger on Microsoft Technologies.

You can Join Me On: Facebook, Twitter, Google Plus, LinkedIn

Add comment

  Country flag

  • Comment
  • Preview

Recent Posts

Random Posts

Most Viewed

URL Shortner

Create your own short urls!!!

Site Counter

free counters


This is a personal weblog. The opinions expressed here represent my own and not those of my employer. For accuracy and official reference refer to MSDN/ TechNet. I have documented my personal experience on this blog.

Protected by Copyscape Web Plagiarism Finder

Site Meter