GRID Data Viewers in SSIS with Example



Data viewers are a very important feature in SSIS for debugging your data pump pipeline. They allow you to view data at points in time at runtime. If you place a data viewer before and after the Aggregate Transform, you can see the data flowing into the transform at runtime and what it looks like after the transform happens. There is one fantastic feature  in this Data Viewers i.e Once you deploy your package and run it on the server as a job or with the service, the data viewers do not show because they are only a debug feature. Anytime the package is executed outside the designer, the data viewers won’t show. There are four types of data viewers:

  • Grid
  • Histogram
  • Scatter Plot
  • Column Chart

1. Grid:

  • GRID Type Will displays the columns in the Grid Format.

2. Histogram:

  • Select Histogram when columns wants display in histogram model
  • Histogram graph works only with 1 column at a time.
  • Histogram graph works only with numeric data

3. Scatter Plot:

  • Scatter Plot (x.y) works only with numeric data.

4. Column Chart:

  • Select Column Chart when columns want to display in the column chart.
  • This graph only works with 1 column at a time.

In this post, let us see a simple example to configure GRID Data Viewers in a Data Flow task.

  • Open a new project and drag a Data Flow task from toolbox in Control Flow.
  • Edit the Data Flow task by double clicking the object or by selecting EDIT button on Right click on the object. Make sure the Data Flow Page is opened as shown below.

  • Select an OLE DB data sources from data flow sources and drag and drop it in the data flow.
  • Double click on the OLE DB data source to open a new window where we can set the properties of the connection.
  • Select the connection manager and click on new button to set the connection string to the table of your wish as shown below.

  • Select  the required columns from the COLUMNS TAB(Page) as shown below.

  • Drag and Drop the Flat File Destination, make a connection between the OLE DB Source and Flat File Destination and configure it.
  • Double click on the pipeline connecting OLE DB Source and Flat File destination to configure Data Viewers properties and click on ADD to add a new Data Viewer as shown below.

  • You can find all the FOUR different types of Data Viewers you can set and select GRID as we are covering about only GRID in this post.

  • Select the GRID tab and select the columns for which we wish to see the data in Data Viewers. By default all the columns will be selected and we can deselect any column which we don’t want to be part of Data Viewer and then click OK as shown below.

  • Now you can see an ICON showing the Data Viewer is created for a path as shown below.

  • Now the package is all set to test Data Viewers functionality and hence trigger the package. Once the execution reaches to the point of Data Viewer, the GRID will be opened and shown as below.

In the above picture, the highlighted part is the Data Viewer where you can see the columns configured as part of GRID Data Viewer configuration.

That is it .. In next post we will see about the remaining types of Data Viewers like Histogram,Scatter Plot and Column Chart. Till then enjoy Coding !!

Roopesh Babu V


  1. Incredible quite a lot of excellent information.
    why is writing important essay [url=][/url] website that writes your essay for you

  2. You have made your stand pretty clearly..
    writing a good scholarship essay [url=][/url] book writing help

  3. Many thanks, Quite a lot of postings!
    purpose of college essay [url=][/url] custom dissertation writing

  4. Wow quite a lot of wonderful info!
    cheap canadian drugs [url=]canada pharmaceuticals online generic[/url] northwest pharmacy canada

  5. You actually said it adequately!
    pharmacy online prescription [url=]order prescriptions online without doctor[/url] cheap pharmacy online

  6. You actually stated that effectively.
    how to write an essay for high school [url=][/url] a website that writes essays for you

  7. Thanks a lot! Excellent information!
    list of legitimate canadian pharmacies [url=]buy viagra pharmacy 100mg[/url] canadian drug store

  8. You actually expressed this really well!
    pharmacy price compare [url=]canadian family pharmacy[/url] best non prescription online pharmacies

  9. You actually expressed that superbly!
    most reliable canadian pharmacies [url=]canadian pharmacy certified canada pharmacy online[/url] best online international pharmacies

  10. Helpful tips. Thanks.
    how to write a essay introduction [url=]how to write an essay for graduate school[/url] professional letter writing services

  11. дома для престарелых
    [url= ]дом престарелых[/url]
    пансионат для престарелых
    [url=]дом престарелых[/url]
    [url=]пансионат для пожилых[/url] [url=]пансионат для пожилых[/url] [url=]пансионат для пожилых[/url] [url=]частный дом престарелых[/url] [url=]дом престарелых[/url] ebea502

  12. You made your position pretty well!!
    how to write a good reflective essay [url=]harvard college application essay[/url] website that writes essays for you

  13. Amazing write ups. With thanks.
    what to write in college essay [url=]essays writing services[/url] online essay writing services

  14. Whoa loads of valuable data.
    top rated essay writing service [url=][/url] creative writing service

  15. Proof of principal for the value of osteoblast stimulation in the treatment of osteolytic breast cancer metastases was suggested by exploratory studies of bone parameters reviewed 11 in the BOLERO 2 Breast cancer trials of Oral Everolimus 2 trial exemestane the mTOR inhibitor everolimus 12 is lasix a diuretic

  16. [url=]sosniti[/url]

    Толпа доступно на официальном Номер ап толпа и в приложении. Фирма выпустила мобильные дополнения для операторных систем Android равно iOS, считать которые может каждый. Это яркий плюс для, потому что юзеры все почаще прибегают ко мобильным девайсам чтобы игр посредством софты.

  17. [url=]беседки[/url]

    Садовые беседки — очень популярный фотоспособ обустройства сада, поэтому их сложность эпохально, поэтому кажинный выберет нечто для себя. Наибольшей популярностью употребляются деревянные беседки – эльбор натуральный, то-то прекрасно вписывается в течение сад.

  18. [url=][/url]

    Пролетарое челкогляделка Vavada (Вавада). Известное средь гемблеров casino Vavada заходит в течение ТОП русскоязычных азартных заведений.
    vavada регистрация

  19. [url=]vavada com online зеркало[/url]

    Зайдя сверху зеркало, вам полным-полно потребуется фоторегистрация на Vavada. Ясно как день введите свои этые, коим применялись сверху официозном сайте. Этто прозвище равным образом пароль.

  20. [url=]казино vavada бездепозитный[/url]

    Официальный фотосайт Вавада казино, вход путем живое пролетарое челкогляделка VAVADA Casino Игровые автоматы от узнаваемых конструкторов, бонус от казино.
    казино vavada бездепозитный

  21. [url=]aviator игра на деньги скачать[/url]

    Aviator – это новый вид соц многопользовательской выступления, заключающейся с растущей кривой, что может вымахивать в энный момент.
    bunker hack aviator

  22. [url=]vavada-no-deposit-bonus-be[/url]

    Шиздец последние скидки в течение онлайн-казино 2022 – элитный фотоспособ начать игру. Бездепозитный бонус, фриспины, кешбэк, промокоды.

  23. [url=]aviator casino online[/url]

    В ТЕЧЕНИЕ пилот хоть немного по играть на мелкотравчатые ставки, но яко только ваша милость поднимаете ставку, хрущев суммарно перестаёт летать.
    aviator game casino

  24. Whoa tons of wonderful facts.
    canadian online pharmacy without prescription [url=]my canadian drugstore[/url] canada drugs com

  25. Nicely put. Appreciate it.
    trusted online canadian pharmacy reviews [url=]canadian pharmacies regulated by health canada[/url] pharmacy of canada

  26. You’ve made the point!
    cvs pharmacy store number list [url=]cialis from canadian pharmacy[/url] best drugstore setting spray

  27. You have made your position extremely well..
    price drugs [url=]how to report someone abusing prescription drugs[/url] legitimate canadian internet pharmacies

  28. Really a good deal of fantastic material.
    list of reputable canadian pharmacies [url=]pharmacy technician online[/url] rx crossroads pharmacy phone number

  29. The largest cardiac screening experience is from Stanford University on 294 asymptomatic HL survivors who had received mantle radiation therapy to a median dose of 44 Gy treatment for lyme disease doxycycline phenytoin ivermectin for mites in guinea pigs But Industry Minister Arnaud Montebourg, who had tradedbarbs with Taylor, has said the executive was reconsidering hisabandoned takeover bid for the plant


Please enter your comment!
Please enter your name here

48 − 38 =