Percentage Sampling Transformation in SSIS with Example

By
roopesh.valluru
-
424
41036

Friends,

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 !!

Regards,

Roopesh Babu V

RELATED ARTICLESMORE FROM AUTHOR

424 COMMENTS

  1. A sublingual cannabis spray is now also available from GW Pharmaceuticals and has been approved as of 2011 for use by prescription in the UK, Canada, Spain, Germany, Denmark, and the Czech Republic.
    Any consumer can easily sildenafil 100 at affordable prices from a trusted pharmacy
    The symptoms of metastatic cancers depend on the location of the tumor, and can include enlarged lymph nodes which can be felt or sometimes seen under the skin and are typically hard , enlarged liver or enlarged spleen, which can be felt in the abdomen, pain or fracture of affected bones, and neurological symptoms.

  2. Signs and Symptoms of Depression in Children The signs of depression in children ages six to 12 are similar to those seen in adults.
    out the substantial discounts quoted through this site for vardenafil (levitra) products online? Will it be real or generic?
    Patients with a history of kidney disease, chronic liver disease, congestive heart failure, electrolyte abnormalities or suspected inflammatory bowel disease should not take this medication.

  66. 888starz download bangladesh [url=http://www.888starz-downloads.com]888starz download bangladesh[/url] .

  184. tadaga 20 https://www.fundable.com/tadaga

    0950663759 – Vladimir (Sergey) Romanenko (Obman, Kidalo)!

    +38 095 0663759 – Владимир (Сергей) Романенко, Одесса – Мошенник, продает нерабочий товар на OLX!

  340. Sharing, a detailed overview on Mexican Pharmacy safety. The author describes how to avoid scams for antibiotics. Link: п»їhttps://polkcity.us.com/# pharmacy mexico online.

  341. п»їLately, I found a great resource about Mexican Pharmacy standards. It covers the safety protocols for generic meds. In case you need cheaper alternatives, check this out: п»їUpstate Medical. It helped me.

  342. п»їActually, I discovered a useful resource regarding cheap Indian generics. It details CDSCO regulations on prescriptions. If you are looking for factory prices, go here: п»їhttps://kisawyer.us.com/# india online pharmacy. Might be useful.

  343. п»їTo be honest, I stumbled upon an interesting resource concerning buying affordable antibiotics. The site discusses WHO-GMP protocols for generic meds. If anyone wants reliable shipping to USA, take a look: п»їbest online pharmacy india. Worth a read.

  344. п»їRecently, I came across an informative page about cheap Indian generics. The site discusses how to save money for generic meds. For those interested in Trusted Indian sources, go here: п»їsee more. Worth a read.

  345. Just wanted to share, a detailed overview on FDA equivalent standards. The author describes quality control for ED meds. Source: п»їhttps://polkcity.us.com/# tijuana pharmacy online.

  346. п»їJust now, I stumbled upon a helpful guide concerning generic pills from India. The site discusses the manufacturing standards for generic meds. For those interested in factory prices, take a look: п»їkisawyer.us.com. Good info.

  347. п»їTo be honest, I stumbled upon an interesting guide about ordering meds from India. It details CDSCO regulations for generic meds. If anyone wants cheaper alternatives, take a look: п»їkisawyer.us.com. Good info.

  348. п»їJust now, I stumbled upon a helpful guide about Indian Pharmacy exports. The site discusses CDSCO regulations for generic meds. If you are looking for cheaper alternatives, check this out: п»їbest india pharmacy. Might be useful.

  349. If you want to save money on prescriptions, I suggest visiting this report. The site explains prices for generics. Huge savings at this link: п»їhttps://polkcity.us.com/# mexico meds.

  350. п»їActually, I stumbled upon a great report about ordering meds from Mexico. It explains FDA equivalents for ED medication. For those interested in reliable shipping to USA, read this: п»їpolkcity.us.com. Worth a read.

  352. п»їActually, I stumbled upon a great guide about buying affordable antibiotics. It details WHO-GMP protocols on prescriptions. For those interested in cheaper alternatives, take a look: п»їindia pharmacy. Worth a read.

  353. п»їLately, I stumbled upon an informative article regarding buying affordable antibiotics. The site discusses CDSCO regulations on prescriptions. In case you need factory prices, check this out: п»їkisawyer.us.com. Worth a read.

  359. Hey all! Check out a useful online drugstore to order medications at a discount. Pharmiexpress provides express shipping on all meds. For fast service, highly recommended: pharmiexpress.com. Best regards.

  361. Merhaba arkadaşlar, güvenilir casino siteleri arıyorsanız, bu siteye kesinlikle göz atın. En iyi firmaları ve bonusları sizin için inceledik. Güvenli oyun için doğru adres: https://cassiteleri.us.org/# cassiteleri.us.org bol şanslar.

  362. Hər vaxtınız xeyir, əgər siz yaxşı kazino axtarırsınızsa, məsləhətdir ki, Pin Up saytını yoxlayasınız. Ən yaxşı slotlar və sürətli ödənişlər burada mövcuddur. Qeydiyyatdan keçin və bonus qazanın. Oynamaq üçün link: burada uğurlar hər kəsə!

  363. Pin-Up AZ Azərbaycanda ən populyar kazino saytıdır. Burada minlərlə oyun və canlı dilerlər var. Qazancı kartınıza anında köçürürlər. Mobil tətbiqi də var, telefondan oynamaq çox rahatdır. Giriş linki Pinup tövsiyə edirəm.

  364. Online slot oynamak isteyenler için rehber niteliğinde bir site: https://cassiteleri.us.org/# listeyi gör Hangi site güvenilir diye düşünmeyin. Onaylı casino siteleri listesi ile rahatça oynayın. Detaylar linkte.

  365. п»їSalam Gacor, lagi nyari situs slot yang mudah menang? Rekomendasi kami adalah Bonaslot. Winrate tertinggi hari ini dan terbukti membayar. Isi saldo bisa pakai Dana tanpa potongan. Login disini: п»їBonaslot login semoga maxwin.

  366. Aktual Pin Up giriş ünvanını axtarırsınızsa, bura baxa bilərsiniz. Bloklanmayan link vasitəsilə qeydiyyat olun və qazanmağa başlayın. Xoş gəldin bonusu sizi gözləyir. Keçid: bura daxil olun uğurlar.

  367. To be honest, I recently stumbled upon a useful Indian pharmacy to save on Rx. If you need medicines from India without prescription, this store is the best place. It has fast shipping to USA. More info here: click here. Good luck.

  369. To be honest, Lately ran into a reliable Mexican pharmacy for affordable pills. For those seeking and need meds from Mexico, this site is highly recommended. Great prices and it is safe. Link is here: https://pharm.mex.com/#. Cya.

  370. Greetings, I recently ran into an awesome website to save on Rx. If you want to save money and need cheap antibiotics, this store is the best option. Great prices and very reliable. Check it out: https://pharm.mex.com/#. Best regards.

  371. Hey guys, I recently stumbled upon the best Indian pharmacy to save on Rx. If you want to buy cheap antibiotics at factory prices, this site is highly recommended. You get fast shipping to USA. Visit here: https://indiapharm.in.net/#. Best regards.

  372. Dostlar selam, Casibom oyuncular? ad?na onemli bir bilgilendirme paylas?yorum. Herkesin bildigi uzere bahis platformu adresini erisim k?s?tlamas? nedeniyle tekrar degistirdi. Siteye ulas?m sorunu cekenler icin link asag?da. Son siteye erisim baglant?s? su an asag?dad?r Casibom Uyelik Bu link uzerinden direkt siteye erisebilirsiniz. Ayr?ca kay?t olanlara verilen hosgeldin bonusu kampanyalar?n? mutlaka inceleyin. Lisansl? casino deneyimi icin Casibom dogru adres. Herkese bol kazanclar dilerim.

  378. Herkese merhaba, bu populer site kullan?c?lar? ad?na k?sa bir duyuru yapmak istiyorum. Herkesin bildigi uzere bahis platformu domain adresini BTK engeli yuzunden tekrar guncelledi. Erisim problemi yas?yorsan?z link asag?da. Yeni siteye erisim baglant?s? su an asag?dad?r https://casibom.mex.com/# Paylast?g?m baglant? uzerinden vpn kullanmadan siteye erisebilirsiniz. Ek olarak kay?t olanlara sunulan hosgeldin bonusu kampanyalar?n? mutlaka inceleyin. En iyi bahis deneyimi surdurmek icin Casibom tercih edebilirsiniz. Herkese bol kazanclar dilerim.

  381. Dostlar selam, bu site oyuncuları adına kısa bir duyuru paylaşıyorum. Bildiğiniz gibi site giriş linkini tekrar değiştirdi. Erişim sorunu yaşıyorsanız panik yapmayın. Yeni siteye erişim linki artık aşağıdadır: https://vaycasino.us.com/# Paylaştığım bağlantı ile doğrudan siteye girebilirsiniz. Güvenilir bahis deneyimi sürdürmek için Vay Casino tercih edebilirsiniz. Herkese bol kazançlar temenni ederim.

  382. Herkese selam, Vaycasino kullanıcıları adına kısa bir duyuru yapmak istiyorum. Bildiğiniz gibi Vaycasino adresini yine güncelledi. Erişim hatası yaşıyorsanız endişe etmeyin. Son Vay Casino giriş linki şu an burada: Vaycasino Giriş Bu link ile doğrudan siteye girebilirsiniz. Güvenilir casino deneyimi için Vay Casino doğru adres. Herkese bol kazançlar temenni ederim.

  383. Herkese merhaba, bu populer site kullan?c?lar? ad?na onemli bir duyuru paylas?yorum. Bildiginiz gibi bahis platformu giris linkini erisim k?s?tlamas? nedeniyle yine tas?d?. Giris hatas? yas?yorsan?z cozum burada. Son siteye erisim linki su an burada Casibom Yeni Adres Paylast?g?m baglant? ile vpn kullanmadan hesab?n?za erisebilirsiniz. Ek olarak kay?t olanlara sunulan yat?r?m bonusu f?rsatlar?n? mutlaka inceleyin. Guvenilir casino deneyimi icin Casibom dogru adres. Tum forum uyelerine bol kazanclar dilerim.

  385. Bahis severler selam, Casibom sitesi oyuncular? icin k?sa bir duyuru yapmak istiyorum. Herkesin bildigi uzere site domain adresini erisim k?s?tlamas? nedeniyle yine guncelledi. Siteye ulas?m hatas? varsa dogru yerdesiniz. Yeni Casibom guncel giris adresi art?k asag?dad?r Casibom Indir Bu link ile dogrudan hesab?n?za girebilirsiniz. Ayr?ca yeni uyelere verilen hosgeldin bonusu f?rsatlar?n? da inceleyin. Guvenilir bahis keyfi surdurmek icin Casibom tercih edebilirsiniz. Tum forum uyelerine bol sans dilerim.

  391. Hi các bác, nếu anh em đang kiếm sân chơi đẳng cấp để chơi Tài Xỉu đừng bỏ qua địa chỉ này. Uy tín luôn: Link vào BJ88. Húp lộc đầy nhà.

  412. Hi guys, I wanted to share a trusted drugstore to purchase prescription drugs securely. I found MagMaxHealth: lipitor. Selling high quality drugs and huge discounts. Cheers.

LEAVE A REPLY

Please enter your comment!
Please enter your name here

− two = one