Percentage Sampling Transformation in SSIS with Example



Percentage Sampling transformation is similar to the TOP keyword in Sql Server. Just like TOP in SQL, Percentage Sampling Limits the records that are gonna flow through pipeline by the given integer as Percentage. Let’s say I have 1000 records in my source table and if I connect the same source to PERCENTAGE SAMPLING transformation by providing Limit records values to 10 then 10% of total records will be flowed from the transformation. Let us see an example of the same.

  • 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 OLE DB data source 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 as shown below.

  • Set the connection to the database by providing the Server name,database name and authentication details if required.
  • After the connection is set, select Data Access mode as “Table or View” as shown below and then select the table which we are gonna use as input to PERCENTAGE SAMPLING Transformation.

  • Now select the columns that needs to be present as part of source by going to Columns Page in OLE DB Data Source as shown below.

  • Now drag and drop Percentage Sampling transformation and connect OLE DB source output as input to this transformation as shown below.

  • Now edit the Percentage sampling transformation and select PERCENTAGE of rows out of total records in the Source table you wants to use as sample by mentioning  it “Percentage of rows”.
  • Give some meaningful names to Sample Output and Unselected output and use “Use the following random seed” option to get Random values from the source rather than getting TOP records.

  • These are all the properties we can set for Percentage Sampling transformation. Now lets create couple of destinations to store Sampled output and not sampled output. I have taken OLE DB destination to push Sampled output and Flat File destination to push non sampled output.
  • Now drag the output of Percentage Sampling transformation to give source to OLE DB destination and it will prompt us to select the INPUT (we have two, one sampled and another one not sampled) and select Sampled output as shown below.

  • Select the Non Sampled output to Flat file destination and set the connection settings for both OLE DB and Flat File destinations. (You can see configuring destinations in the post here)
  • Now the package is ready to execute and do the same. Make sure all the items turn GREEN.

  • You can observe the records from source got grouped into two different pipelines based on the percentage we have given.

This is it !! This is one of the simplest transformation(to configure) available in SSIS and useful when ever you wish to limit the records flowing to destination.

Happy Coding !!


Roopesh Babu V


  1. Terrific advice. Cheers.
    [url=]research paper writer services[/url] write a paper [url=]cheap research paper writer[/url] master paper writers

  2. Regards, A lot of facts.
    [url=]i do my homework in spanish[/url] i didn t do my homework what do i do [url=]define linear motion do my homework[/url] why cant i do my homework

  3. Nicely put, Thank you.
    [url=]best dissertation service uk[/url] help writing a dissertation proposal [url=]write my dissertation for me[/url] ma dissertation writing service

  4. Fantastic content. Kudos!
    [url=]define thesis[/url] thesis statement service learning paper [url=]help me write my thesis[/url] thesis statement paragraph

  5. Cheers. Helpful stuff!
    [url=]reddit do my homework[/url] do my statistics homework online [url=]cpm homework[/url] do my homework canada

  6. Useful data. Appreciate it!
    [url=]buy essay service[/url] essay writing service toronto [url=]writing services[/url] essay writing book

  7. Reliable material. Thanks a lot.
    [url=]write a proposal[/url] research proposal papers [url=]proposal writer[/url] buy college research papers

  8. Wonderful stuff. Thanks a lot.
    [url=]dissertation consulting service[/url] buy dissertation paper [url=]buy dissertations[/url] thesis and dissertation help

  9. Cheers! I value this.
    [url=]college thesis[/url] introduction thesis [url=]bachelor thesis writing service[/url] basic thesis statement

  10. Lovely stuff, Regards!
    [url=]write my essay com[/url] how to write an about me section for a website [url=]how to write an about me for dating[/url] can someone do my essay for me

  11. Truly loads of excellent information!
    [url=]pay for dissertation[/url] dissertation writing services uk [url=]help writing dissertation proposal[/url] dissertation exemple

  12. Your writing is perfect and complete. baccarat online However, I think it will be more wonderful if your post includes additional topics that I am thinking of. I have a lot of posts on my site similar to your topic. Would you like to visit once?

  13. canadian online drugstore [url=]erectile dysfunction[/url] the best ed drug

  14. i have learn several just right stuff here. Definitely value bookmarking for revisiting.
    I wonder how so much effort you place to make one of these fantastic informative web site.
    온라인카지노” m really impressed with your writing skills and
    We finalize our work space and hamper within your budget
    , no matter what kind of programme you have in mind!

  15. i have learn several just right stuff here. Definitely value bookmarking for revisiting.
    I wonder how so much effort you place to make one of these fantastic informative web site.
    온라인바카라” m really impressed with your writing skills and
    We finalize our work space and hamper within your budget
    , no matter what kind of programme you have in mind!

  16. i have learn several just right stuff here. Definitely value bookmarking for revisiting.
    I wonder how so much effort you place to make one of these fantastic informative web site.
    바카라사이트” m really impressed with your writing skills and
    We finalize our work space and hamper within your budget
    , no matter what kind of programme you have in mind!

  17. Fine tips. Regards.
    [url=]personal statement writing service[/url] writing a scholarship essay [url=]i need help writing an essay[/url] essay writing service dublin

  18. pillole per erezione in farmacia senza ricetta [url=]viagra generico sandoz[/url] esiste il viagra generico in farmacia

  19. Thanks a lot. I appreciate this!
    [url=]legitimate paper writing service[/url] paper writing services for college students [url=]buy custom papers[/url] graduate paper writing services

  20. Thank you, A good amount of content!
    [url=]thesis writing service reviews[/url] thesis statment [url=]thesis titles[/url] thesis proposal writing service

  21. viagra online spedizione gratuita [url=]viagra online spedizione gratuita[/url] viagra online spedizione gratuita

  22. Very good advice. Kudos.
    [url=]buy dissertation[/url] uk dissertation writing service [url=]nursing dissertation writing services[/url] difference between a thesis and a dissertation

  23. Thanks a lot, An abundance of write ups.
    [url=]college essay help near me[/url] writing helperessay help [url=]essay help uk[/url] help writing essays

  24. Kudos. I like this.
    [url=]need help writing an essay[/url] paper writing help [url=]help writing essays[/url] college essay tutor near me

  25. You actually suggested it effectively.
    [url=]do my essay free[/url] write my essay for free [url=]write my essay for me[/url] online essay writers

  26. You made your point!
    [url=]hire someone to do my homework[/url] do my math homework for me [url=]do my college homework[/url] my homework

  27. Really a lot of valuable tips!
    [url=]research paper helper[/url] buy term papers online [url=]buy research paper[/url] custom research paper writing services

  28. Thank you! Good stuff!
    [url=]online essay writing service[/url] grad school essay writing service [url=]essay writing prompts[/url] writing an essay outline

  29. Nicely put, Thanks!
    [url=]ebook writing service[/url] best finance essay writing service [url=]good essay writing service[/url] legit essay writing service

  30. You actually explained this exceptionally well.
    [url=]research proposal[/url] writing proposal [url=]research proposal apa[/url] proposal writing

  31. buy medicines online in india [url=]india pharmacy without dr prescriptions[/url] world pharmacy india

  32. Wonderful content, Thank you!
    [url=]best essay writers[/url] essay writer no plagiarism [url=]write a essay[/url] essay writter

  33. Many thanks! Great stuff!
    [url=]research paper writing service[/url] pay someone to write your paper [url=]paper writing service[/url] pay to write paper

  34. mexico drug stores pharmacies [url=]buying from online mexican pharmacy[/url] reputable mexican pharmacies online

  35. Many thanks! Very good stuff!
    [url=]essay helper online[/url] free writing assistant [url=]writing helper[/url] buy essay

  36. Thanks a lot. Valuable information.
    [url=]write my research paper[/url] write a paper [url=]how to write a response paper[/url] how to write a reflective paper

  37. Whoa all kinds of very good advice.
    [url=]essay service review[/url] paper writing service reviews [url=]writing a compare and contrast essay[/url] essay help service

  38. With thanks. I appreciate this.
    [url=]easy essay writing[/url] what is the best essay writing service [url=]legit essay writing services[/url] essay help service

  39. cheapest pharmacy for prescriptions without insurance [url=]sure save pharmacy[/url] best online foreign pharmacy

  40. Patients should [url=]order Cipro[/url] well in advance of any planned travel to ensure they have time to receive and complete the full course of antibiotics.

  41. Regards, Numerous information!
    [url=]academic essay writing[/url] essay review service [url=]unique essay writing service[/url] professional essay writers

  42. You mentioned that very well.
    [url=]essay writing prompts[/url] essay writing service uk [url=]cheap custom writing service[/url] professional paper writing services

  43. You explained it perfectly!
    [url=]help with college essay writing[/url] best essay writing website [url=]essay writing samples[/url] essay writing practice

  44. ed drugs online [url=]certified canadian international pharmacy[/url] list of canadian pharmacies online

  45. You made your stand pretty well!!
    [url=]buy college paper[/url] cheap research paper writing service [url=]custom handwriting paper[/url] pay to write paper

  46. discount drugs online pharmacy [url=]online canadian discount pharmacy[/url] canadain pharmacy no prescription

  47. Fantastic data. Appreciate it.
    [url=]assignment help[/url] the college essay guy [url=]writing helper[/url] the college essay guy

  48. Awesome stuff, Thanks.
    [url=]make an essay[/url] essay writter [url=]write essay[/url] write my essay for cheap

  49. mail order pharmacy india [url=]indian pharmacy paypal[/url] buy prescription drugs from india

  50. You have made your point.
    [url=]help me write an essay[/url] essay bot [url=]argumentative essay[/url] how to write a college essay

  51. Compre su licencia de conducir en línea. ofrecemos durabilidad, calidad de impresión excepcional y una impresión general de calidad y autenticidad. Analice una variedad de funciones, como códigos de barras, bandas magnéticas, chips inteligentes y superposiciones holográficas. También incluyen laminados holográficos que añaden autenticidad a las tarjetas.
    comprar licencia de conducir

  52. Köp ditt körkort online. vi erbjuder hållbarhet, exceptionell utskriftskvalitet och ett helhetsintryck av kvalitet och autenticitet. Analysera en mängd olika funktioner som streckkoder, magnetremsor, smarta chips och holografiska överlägg. De inkluderar även holografiska laminat som ger äkthet till korten.
    köpa körkort

  53. Comprar carta de condução online. oferecemos durabilidade, qualidade de impressão excepcional e uma impressão geral de qualidade e autenticidade. Analise uma variedade de recursos, como códigos de barras, tarjas magnéticas, chips inteligentes e sobreposições holográficas. Eles também incluem laminados holográficos que adicionam autenticidade aos cartões.
    Comprar carta de conducao

  54. Koop uw rijbewijs online. wij bieden duurzaamheid, uitzonderlijke printkwaliteit en een algehele indruk van kwaliteit en authenticiteit. Analyseer een verscheidenheid aan functies, zoals streepjescodes, magnetische strepen, slimme chips en holografische overlays
    rijbewijs-kopen belgie

  55. Koop uw rijbewijs online. wij bieden duurzaamheid, uitzonderlijke printkwaliteit en een algehele indruk van kwaliteit en authenticiteit. Analyseer een verscheidenheid aan functies, zoals streepjescodes, magnetische strepen, slimme chips en holografische overlays. Ze bevatten ook holografische laminaten die authenticiteit aan de kaarten toevoegen.
    rijbewijs kopen

  56. comprare la patente. offriamo durata, qualità di stampa eccezionale e un’impressione generale di qualità e autenticità. Analizza una varietà di caratteristiche come codici a barre, bande magnetiche, chip intelligenti e sovrapposizioni olografiche. Includono anche laminati olografici che aggiungono autenticità alle carte.
    comprare patente

  57. over the counter erectile dysfunction pills [url=]cheapest ed pills online[/url] erectile dysfunction drug

  58. You said it adequately.!
    [url=]pay for an essay[/url] pay to write essay [url=]order essay online[/url] pay for research paper

  59. Wow a lot of great data!
    [url=]phd thesis[/url] proquest dissertations [url=]writing dissertations[/url] dissertation writing service

  60. Kudos. Awesome stuff.
    [url=]letter writing service[/url] best resume writing service 2019 [url=]college essay service[/url] cheapest essay writing service uk

  61. canadian discount cialis [url=]drugs without a doctor s prescription[/url] the best canadian online pharmacy

  62. canada pharmacy reviews [url=]prescription drugs without prior prescription[/url] mexican pharmacy testosterone

  63. Many thanks, Fantastic stuff!
    [url=]professional paper writing service[/url] paper writing services [url=]pay someone to write a paper[/url] professional paper writing service

  64. india pharmacy [url=]indian pharmacies safe[/url] indianpharmacy com

  65. You actually explained it adequately!
    [url=]paper writing services[/url] professional paper writing service [url=]buy college paper[/url] research paper writing service

  66. Helpful data. Thanks!
    [url=]college essays writing[/url] executive resume writing service [url=]coursework writing service[/url] top essay writing

  67. buy cipro online without prescription [url=]buy cipro online without prescription[/url] cipro for sale

  68. trusted canadian pharmacy [url=]certified canadian international pharmacy[/url] discount pharmacy online

  69. ed pills online [url=]ed medications online[/url] mens erection pills

  70. indianpharmacy com [url=]india pharmacy[/url] buy medicines online in india

  71. п»їlegitimate online pharmacies india [url=]india pharmacy[/url] world pharmacy india

  72. generic ed pills [url=]erectile dysfunction pills[/url] erectile dysfunction medicines

  73. cost of cheap propecia price [url=]buy propecia[/url] where buy cheap propecia prices

  74. Some men find that using a cock ring, a ring worn at the base of the penis, can help maintain an erection by restricting blood flow out of the penis. However, it is important to use these devices according to instructions and for a limited duration to avoid potential complications. viagra 50mg or 100mg

  75. Maintaining a positive body image and self-esteem can improve sexual confidence. Remember that sexual attraction and pleasure encompass more than just physical performance. Embrace your unique qualities and focus on overall well-being. fildena 100 mg price

  76. kamagra tablets usa [url=]Kamagra Oral Jelly 100mg buy online[/url] cheap kamagra oral jelly

  77. We combined the MEDLINE search with the Cochrane Highly Sensitive Search Strategy for identifying randomized trials, as described in Chapter 6 of the Cochrane Handbook for Systematic Reviews of Interventions Lefebvre 2011 what happens to a woman if they take viagra The pig experiments at University of Murcia, Spain, were performed in accordance with Directive 2010 63 EU EEC for animal experiments and were reviewed and approved by the Ethical Committee for Experimentation with Animals code 69 2014, the Research Ethics Committee code 1086 2015, and the Biosafety Committee code of the University of Murcia, Spain; and by the Murcia Regional Ministry of Agriculture and Water code 273

  78. The effects of chronic medication use, such as antipsychotics and antidepressants, on erectile function are a topic of ongoing research. Collaborative medication management, dosage adjustments, or alternative medications may help mitigate sexual side effects. fildena soft water

  79. kamagra [url=]Kamagra Oral Jelly 100mg buy online[/url] kamagra tablets usa

  80. can i buy propecia for sale [url=]Finasteride prescription online[/url] can you get generic propecia no prescription

  81. Buy Kamagra online next day delivery [url=]cheap kamagra oral jelly[/url] Oral Jelly 100mg Kamagra price

  82. mexican mail order pharmacies [url=]buying from online mexican pharmacy[/url] mexican online pharmacies prescription drugs

  83. mexican drugstore online [url=]purple pharmacy mexico price list[/url] buying prescription drugs in mexico online

  84. best online pharmacies in mexico [url=]best online pharmacies in mexico[/url] buying prescription drugs in mexico

  85. online canadian pharmacy reviews [url=]best canadian pharmacy[/url] northwest canadian pharmacy

  86. sildenafil buy [url=]4 sildenafil[/url] sildenafil generic without prescription

  87. birth control pills without seeing a doctor [url=]birth control pills[/url] birth control pills buy

  88. price for birth control pills [url=]birth control pills[/url] over the counter birth control pills

  89. birth control pills buy [url=]birth control pills buy[/url] birth control pills cost

  90. birth control pills online [url=]п»їbuy birth control pills online[/url] birth control pills delivery

  91. pharmacies in mexico that ship to usa [url=]medication from mexico pharmacy[/url] reputable mexican pharmacies online