Multicast Transformation in SSIS with Example

By
roopesh.valluru
-
270
28455

Friends,

Multicast transformation is useful when ever you wish to make many copies of same data or you need to move the same data to different pipelines. It has one input and many outputs. I will replicate the same input what is takes and returns many copies of the same data. Lets take a simple example to demonstrate the same.

For this I am creating a table and inserting data into it. If you wish to use existing table then you can go ahead with that.

Note – I am creating 5 more tables with the same structure which I will use as Destination tables.

create table emp
(
emp_name varchar(100),
emp_id int,
sal money,
desig varchar(50),
joindate datetime,
enddate datetime
)

Inserting data into the same table.

insert into emp values(‘sita’,123,30000,’software engineer’,12-03-2011)
insert into emp values(‘ramu’,345,60000,’team lead’,15-06-2009)
insert into emp values(‘lakshman’,567,25000,’analyst’,18-02-2011)
insert into emp values(‘charan’,789,40000,’administrator’,27-05-2011)
insert into emp values(‘akhil’,234,30000,’software engineer’,24-07-2011)
insert into emp values(‘kaveri’,456,50000,’hr’,26-12-2009)
insert into emp values(‘nimra’,678,50000,’adminidtrator’,19-06-2010)
insert into emp values(‘lathika’,891,35000,’system analyst’,23-05-2010)
insert into emp values(‘yogi’,423,70000,’tech lead’,12-09-2009)
insert into emp values(‘agastya’,323,70000,’team lead’,23-04-2008)
insert into emp values(‘agastya’,235,50000,’hr’,21-12-2009)

Now the source data is ready on which we can apply Multicast transformation and move to multiple destinations. PFB the steps to be followed.

  • 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 created just now.

  • Drag and drop MultiCast Transformation into the Data Flow Pane and provide connection between OLE DB Source and Multicast Transformation as shown below.

  • Now from Multicast we can take many outputs and to demostrate the same drag and drop OLE DB Destination and give a connection between MultiCast transformation and OLE DB destination then EDIT the destination transformation to provide the connection details to ONE of the FIVE tables created with same structure.
  • Check the mappings and click OK.

  • Like above, we can create N number of destinations and for this demo purpose I created 5 similar destinations pointing to different tables we created as shown below.

  • In the above pic, you can see that Many outputs are coming from one Multicast transformation and the same is pointed to different OLE DB destinations. Now the package is all set to go. Trigger it and wait till all the items turn GREEN.

That is it !! you can see Multicast taking one input of 11 rows and converting it to many copies and sending to different destinations.

This is how you can configure and use Multicast transformation. You can give output of Multicast to another transformation too before passing it to destination.

Happy Coding guys !!

Regards,
Roopesh Babu V

RELATED ARTICLESMORE FROM AUTHOR

270 COMMENTS

  1. I’m writing on this topic these days, slotsite, but I have stopped writing because there is no reference material. Then I accidentally found your article. I can refer to a variety of materials, so I think the work I was preparing will work! Thank you for your efforts.

  14. amoxicillin price without insurance: [url=https://amoxicillins.com/#]where to buy amoxicillin pharmacy[/url] buy amoxicillin

  23. [url=https://propecia1st.science/#]buying propecia without insurance[/url] get propecia no prescription

  24. order cheap mobic for sale [url=https://mobic.store/#]can i order cheap mobic tablets[/url] how to get mobic price

  27. erection pills viagra online [url=http://cheapestedpills.com/#]ed medications online[/url] mens erection pills

  56. zithromax tablets for sale [url=https://azithromycin.men/#]zithromax 250 mg australia[/url] generic zithromax over the counter

  72. safe reliable canadian pharmacy [url=https://certifiedcanadapills.pro/#]canadian drug[/url] canadian online drugs

  73. To announce actual scoop, ape these tips:

    Look fitted credible sources: http://davai-group.org/wp-content/pages/what-is-g21-news.html. It’s eminent to ensure that the expos‚ source you are reading is respected and unbiased. Some examples of good sources include BBC, Reuters, and The Different York Times. Announce multiple sources to get back at a well-rounded sentiment of a precisely low-down event. This can support you listen to a more complete display and keep bias. Be in the know of the viewpoint the article is coming from, as set good news sources can have bias. Fact-check the dirt with another fountain-head if a communication article seems too sensational or unbelievable. Always make persuaded you are reading a known article, as expos‚ can transmute quickly.

    Close to following these tips, you can befit a more informed dispatch reader and more intelligent apprehend the world around you.

  74. Absolutely! Declaration info portals in the UK can be unendurable, but there are numerous resources at to cure you find the unexcelled in unison for the sake of you. As I mentioned already, conducting an online search representing https://blog.halon.org.uk/pag/what-is-laura-ingle-s-age-exploring-laura-ingle-s.html “UK scuttlebutt websites” or “British news portals” is a pronounced starting point. Not one determination this hand out you a encompassing tip of report websites, but it intention also lend you with a heartier savvy comprehension or of the in the air communication view in the UK.
    On one occasion you have a list of imminent story portals, it’s critical to gauge each one to shape which richest suits your preferences. As an case, BBC Dispatch is known for its ambition reporting of intelligence stories, while The Guardian is known representing its in-depth breakdown of bureaucratic and popular issues. The Disinterested is known championing its investigative journalism, while The Times is known in the interest of its work and finance coverage. During understanding these differences, you can choose the talk portal that caters to your interests and provides you with the news you call for to read.
    Additionally, it’s usefulness all things local expos‚ portals because specific regions within the UK. These portals produce coverage of events and news stories that are fitting to the area, which can be specially helpful if you’re looking to charge of up with events in your local community. In behalf of exemplar, provincial good copy portals in London number the Evening Paradigm and the Londonist, while Manchester Evening Hearsay and Liverpool Reproduction are hot in the North West.
    Inclusive, there are diverse news portals at one’s fingertips in the UK, and it’s significant to do your research to remark the united that suits your needs. By evaluating the different news broadcast portals based on their coverage, style, and essay viewpoint, you can decide the individual that provides you with the most related and engrossing info stories. Esteemed destiny with your search, and I anticipate this tidings helps you come up with the practised news portal inasmuch as you!

  76. Quoted 08:00 Sat – 22:00 Fri (UK time) Bitcoin’s supply is limited to 21 million coins, and each block is added to the network every 10 minutes. The timing of each block is kept stable through a difficulty adjustment mechanism, while BTC’s inflation is controlled by code, with the reward in each block halving every 210,000, or roughly every four years.Each Bitcoin is divisible to eight decimal places, with the smallest unit being known as a satoshi – one satoshi is 0.00000001 BTC. The cryptocurrency could be made divisible into even more decimal places in the future. Save on potential margin offsets between Bitcoin futures and options on futures. • You are doing so on the basis of your own enquiry, without solicitation or inducement by PrimeXBT;• Consumer protections under UK regulations do not apply to services provided by PrimeXBT because it is not regulated in the UK and provides services from outside the UK;• You have read our Risk Disclosure and have the necessary knowledge and experience to understand the risks involved.
    http://test10.dsso.kr/bbs/board.php?bo_table=free&wr_id=4086
    You can earn more Dogecoin for just letting it in your account our year interest rate 8% If we detect that you have blocked the advertisement, or the advertisement is not displayed in your browser, then you will not be able to receive Dogecoin or other crypto currencies. This may be caused by the ad-blocking plug-in or extension that comes with the browser. Please disable your ad-blocking plug-in or add the page to the whitelist. We sell different types of products and services to both investment professionals and individual investors. These products and services are usually sold through license agreements or subscriptions. Our investment management business generates asset-based fees, which are calculated as a percentage of assets under management. We also sell both admissions and sponsorship packages for our investment conferences and advertising on our websites and newsletters.

  100. canadian pharmacy world [url=https://drugsotc.pro/#]online pharmacy without scripts[/url] pharmacy discount card

  127. Cheap generic Viagra online [url=https://viagra.eus/#]Sildenafil Citrate Tablets 100mg[/url] cheapest viagra

  138. best online canadian pharmacy: escrow pharmacy canada – ed drugs online from canada canadapharmacy.guru
    indian pharmacy paypal [url=https://indiapharmacy.pro/#]canadian pharmacy india[/url] buy medicines online in india indiapharmacy.pro

  142. canada rx pharmacy world: escrow pharmacy canada – legitimate canadian mail order pharmacy canadapharmacy.guru
    mexican online pharmacies prescription drugs [url=https://mexicanpharmacy.company/#]best online pharmacies in mexico[/url] mexico pharmacies prescription drugs mexicanpharmacy.company

  146. canadian pharmacy antibiotics: canada online pharmacy – legit canadian pharmacy canadapharmacy.guru
    mexican pharmaceuticals online [url=http://mexicanpharmacy.company/#]mexican pharmaceuticals online[/url] mexican online pharmacies prescription drugs mexicanpharmacy.company

  147. reliable canadian pharmacy reviews: 77 canadian pharmacy – canadian pharmacies that deliver to the us canadapharmacy.guru
    buy prescription drugs from canada cheap [url=https://canadapharmacy.guru/#]canadadrugpharmacy com[/url] canadian pharmacy meds review canadapharmacy.guru

  155. mexican online pharmacies prescription drugs: purple pharmacy mexico price list – mexico pharmacies prescription drugs mexicanpharmacy.company
    onlinepharmaciescanada com [url=https://canadapharmacy.guru/#]buying drugs from canada[/url] maple leaf pharmacy in canada canadapharmacy.guru

  157. indian pharmacy: online pharmacy india – india pharmacy indiapharmacy.pro
    canadian neighbor pharmacy [url=http://canadapharmacy.guru/#]canadian king pharmacy[/url] pharmacy wholesalers canada canadapharmacy.guru

  162. canadian mail order pharmacy: safe canadian pharmacy – canadian pharmacies compare canadapharmacy.guru
    mexican rx online [url=http://mexicanpharmacy.company/#]mexican border pharmacies shipping to usa[/url] mexico pharmacies prescription drugs mexicanpharmacy.company

  180. Абузоустойчивый VPS
    Виртуальные серверы VPS/VDS: Путь к Успешному Бизнесу

    В мире современных технологий и онлайн-бизнеса важно иметь надежную инфраструктуру для развития проектов и обеспечения безопасности данных. В этой статье мы рассмотрим, почему виртуальные серверы VPS/VDS, предлагаемые по стартовой цене всего 13 рублей, являются ключом к успеху в современном бизнесе

  215. VPS SERVER
    Высокоскоростной доступ в Интернет: до 1000 Мбит/с
    Скорость подключения к Интернету — еще один важный фактор для успеха вашего проекта. Наши VPS/VDS-серверы, адаптированные как под Windows, так и под Linux, обеспечивают доступ в Интернет со скоростью до 1000 Мбит/с, что гарантирует быструю загрузку веб-страниц и высокую производительность онлайн-приложений на обеих операционных системах.

  216. Моментально возводимые здания: прибыль для бизнеса в каждой составляющей!
    В современном обществе, где время равно деньгам, объекты быстрого возвода стали настоящим выходом для коммерции. Эти новаторские строения комбинируют в себе устойчивость, экономическую эффективность и быстроту установки, что придает им способность отличным выбором для разнообразных предпринимательских инициатив.
    [url=https://bystrovozvodimye-zdanija-moskva.ru/]Легковозводимые здания из металлоконструкций[/url]
    1. Быстрое возведение: Время – это самый важный ресурс в бизнесе, и здания с высокой скоростью строительства обеспечивают существенное уменьшение сроков стройки. Это особенно выгодно в случаях, когда требуется быстрый старт бизнеса и начать зарабатывать.
    2. Экономичность: За счет усовершенствования производственных процессов элементов и сборки на месте, затраты на экспресс-конструкции часто приходит вниз, чем у традиционных строительных проектов. Это позволяет получить большую финансовую выгоду и достичь большей доходности инвестиций.
    Подробнее на [url=https://bystrovozvodimye-zdanija-moskva.ru/]http://www.scholding.ru/[/url]
    В заключение, быстровозводимые здания – это великолепное решение для коммерческих проектов. Они комбинируют в себе ускоренную установку, экономию средств и надежные характеристики, что обуславливает их отличным выбором для предпринимателей, стремящихся оперативно начать предпринимательскую деятельность и получать деньги. Не упустите возможность сократить затраты и время, оптимальные моментальные сооружения для ваших будущих инициатив!

  223. can you buy doxycycline over the counter [url=http://doxycycline.forum/#]Buy doxycycline hyclate[/url] doxycycline online paypal

  232. cipro online no prescription in the usa [url=http://ciprofloxacin.men/#]ciprofloxacin without insurance[/url] ciprofloxacin over the counter

  259. п»їfarmacia online migliore [url=http://farmaciait.pro/#]farmaci senza ricetta elenco[/url] acquisto farmaci con ricetta

  267. comprare farmaci online all’estero [url=https://farmaciait.pro/#]farmacia online[/url] farmacia online

LEAVE A REPLY

Please enter your comment!
Please enter your name here

18 − = 10