SQL 2005: SQL Server Integration Services
Multicast
By: Zack Turnbow
Introduction
This next introductory article on SSIS, the use of the Multicast component will be explored. This component is fairly straight forward in its use. It does exactly what it says. If you need to send data to two different places and don’t want to have to create a complex way if copying that data then the Multicast component fits perfectly. If you have been following the previous articles, you will have noticed that the data was previously being sent to a flat file for a report. Now we will incorporate the Multicast to send data to both the report file and to the database.
Yes, it is possible to find a good web host. Sometimes it takes a while. After trying several, we went with Server Intellect and have been very happy. They are the most professional, customer service friendly and technically knowledgeable host we've found so far.
Implementation
First create a new SSIS package and name it Multicast. Then, using the same technique as before, copy the Data Flow component from the Derived Column package to the new package. Make sure to reconfigure the flat file connections for the two import files and their respective Flat File Sources. Now remove the link between the Derived Column output and the Flat File Destination component.
[Click to see full-size]
Find the Multicast component in the toolbox and add it to the work area. Connect the output of the Derived Column component to the Multicast component.
[Click to see full-size]
We chose Server Intellect for its dedicated servers, for our web hosting. They have managed to handle virtually everything for us, from start to finish. And their customer service is stellar.
At first glance, there are no configuration warnings associated with the Multicast component. The reason why is that there is nothing to configure. Now it is time to connect the outputs of the Multicast. Keep in mind that the Multicast component can cast to multiple targets. First, make the connection from the Multicast the Flat File Destination component and reconfigure a connection in Connection Manager for the Flat File Destination.
[Click to see full-size]
Now the data needs to get to the database. Using the technique from the Import article, drag an OLE DB Destination into the work area. Connect another Multicast output to the OLE DB Destination. Before creating an OLE DB connection, the database table needs to have the correct columns in the table. You can both delete the old table and run the included SQL script from the source folder or you can manually add a column called ProcessingCharge with a data type of money to the Transaction table. Go ahead and create a new OLE DB Connection in Connection Manager to get access to the database.
[Click to see full-size]
We migrated our web sites to Server Intellect over one weekend and the setup was so smooth that we were up and running right away. They assisted us with everything we needed to do for all of our applications. With Server Intellect's help, we were able to avoid any headaches!
Configure the OLE DB Destination to use the newly created OLE DB Connection.
[Click to see full-size]
Click the Mappings tab and make sure that the data is going to the right column in the database especially the new ProcessingCharge column.
[Click to see full-size]
Testing the Package
Before you test the package, I would like to introduce a trouble shooting / quality assurance technique that might be of some use. There is a way to view the data during the testing of the package and to do this all you need to do is right click on one of the green links between components and select Data Viewers.
[Click to see full-size]
We moved our web sites to Server Intellect and have found them to be incredibly professional. Their setup is very easy and we were up and running in no time.
There are other options available but what we are interested in is the Data Viewer so go ahead and click the Add button. A dialog box will pop up.
[Click to see full-size]
There are different formats to display the data, select the Grid format. If you would like to have the choice of which columns to see in the grid then click the Grid tab.
[Click to see full-size]
Click OK to close this dialog box and then click OK to close the other dialog box. Now that the data viewer is configured, you will see a magnifying glass over a grid icon close the green link.
[Click to see full-size]
Need help with Windows Dedicated Hosting? Try Server Intellect. I'm a happy customer!
To see if the data ends up in both destinations, run the package as long as there are no configuration warnings. Since there is a data view configured, the package will pause processing the data at the spot where the data view is located and a dialog box will show a grid of the data at the spot where the data viewer is.
[Click to see full-size]
In the main Visual Studio window, you can actually see the processing stop. This actually gives the developer a chance to see the data during processing to make sure everything is on track.
[Click to see full-size]
Press the green arrow in the Data View window to continue finish process in the data.
[Click to see full-size]
I just signed up at Server Intellect and couldn't be more pleased with my Windows Server! Check it out and see for yourself.
You can now compare the data in the flat file with the data in the database table to make sure they are both identical.
What have we learned?
How to configure a Derived Column component.
How to use a Data View to look at the data during package execution.
Attachments
Leave a Comment
#1 SUSHIL
Posted By: SUSHIL | 6.30.2009 at 3:16 AM
Thanks For providing usefull information about SQL SERVER.
#2 computer racks
Posted By: computer racks | 12.23.2009 at 1:30 AM
thanks for such useful info
#3 plus grands bonus de casino en ligne
Posted By: plus grands bonus de casino en ligne | 2.13.2010 at 4:29 AM
SQL Server Integration Services (SSIS) is a component of the Microsoft SQL Server database software which can be used to perform a broad range of data migration tasks.The Multicast transformation distributes its input to one or more outputs. This transformation is similar to the Conditional Split transformation. Both transformations direct an input to multiple outputs. The difference between the two is that the Multicast transformation directs every row to every output, and the Conditional Split directs a row to a single output.
#4 web diretory
Posted By: web diretory | 3.07.2010 at 3:37 AM
hello blogger, I found this site from google and read a few of your other posts. They are gorgeous. Please keep them coming.. Cheers, Thomas Daily.
#5 220-701
Posted By: 220-701 | 3.19.2010 at 5:35 AM
For all I know this could be a really old entry, since there are no date marker on the article. In that case I apologize.
#6 wholesale laptop adapter
Posted By: wholesale laptop adapter | 5.21.2010 at 1:57 AM
its use. It does exactly what it says. If you need to send data to two different places and don’t want to have to create a complex way if copying that data then the Multicast component fits perfectly. If you have been following the previous articles, you will have noticed that the data was previously being sent to a flat file for a report. N
#7 air max shoes
Posted By: air max shoes | 5.23.2010 at 4:58 AM
nike air max sale
#8 coach handbags
Posted By: coach handbags | 5.24.2010 at 3:14 AM
The Far East aristocrat becomes fashion new influence … “the Russian always to choose best goods - - Chanel in the best brand the handbag and the coat,
#9 safety equipment
Posted By: safety equipment | 6.01.2010 at 5:58 AM
I wanted to thank you for this great read!! I definitely enjoying every little bit of it I have you bookmarked to check out new stuff you post
#10 five fingers shoes
Posted By: five fingers shoes | 6.02.2010 at 7:36 PM
Thanks for your great work.
really really good stuff men !!! thanks !!!
Interesting Article. Hoping that you will continue posting an article having a useful information. Thanks a lot! www.five-fingers-vibram.org
#11 impressive
Posted By: impressive | 6.03.2010 at 7:53 PM
Nice to be visiting your post again, it has been months for me. Well this article that I've been waited for so long. I need this article to complete my assignment in the college, and it has same topic with your article. Thanks, great share.
#12 Uggs Sale
Posted By: Uggs Sale | 6.06.2010 at 7:12 PM
ugg boots shop offer powerful training shoes ,Tall ugg shoes. A large number of UGG Tall Boots available at discount Ugg Boots sale are extremely hot recently. Uggs Sale is having its biggest sale of the year
#13 Ugg Boots UK
Posted By: Ugg Boots UK | 6.06.2010 at 7:12 PM
Wow - really powerful post. Thanks for taking time to share this personal perspective that not only we as individuals should heed http://www.uggretailers.org/
#14 uggs shoes
Posted By: uggs shoes | 6.06.2010 at 7:15 PM
Thanks for sharing ,really helped a lot here! We are the best and professional online retailer, offering top quality Classic uggs sale,, Short ugg boots and free shipping worldwide. And we have engaged in uggs shoes sale for years http://www.uggsonline.us
#15 Ugg Schoenen
Posted By: Ugg Schoenen | 6.06.2010 at 7:15 PM
We are shortly launching our new website, http://www.uggofficial.nl/ which will focus on selling ugg boots, Ugg Schoenen and goedkope uggs including the new uggs schoenen and ugg classic tall products.
#16 uggs boots
Posted By: uggs boots | 6.06.2010 at 7:15 PM
Thank you again for all the knowledge you distribute,Nowadays,people pay more attention to high quality life style. High quality means www.uggbaileybutton.org
#17 uggs boots
Posted By: uggs boots | 6.06.2010 at 7:15 PM
Thank you again for all the knowledge you distribute,Nowadays,people pay more attention to high quality life style. High quality means www.uggbaileybutton.org
#18 don ed hardy
Posted By: don ed hardy | 6.06.2010 at 7:15 PM
Thanks for sharing !So nice to see you !I will buy a wallet for my best friend! Shopping Cheap EdHardy can be used on various occasions and in different ways. http://www.donedhardy.name/
#19 hollister
Posted By: hollister | 6.06.2010 at 7:15 PM
I really love your website, it's so useful, i'm just sharing for my friends！Strong winter weather is hitting most of the United States right now www.abercrombieofficial.org
#20 vibram shoes
Posted By: vibram shoes | 6.06.2010 at 7:16 PM
I agree you! excellent review!vibram five fingers have been popular for a long time,for its excellent quality and further features,I’ve always wanted to have a pair of beauty fivefingers running shoes
#21 coach purses cheap
Posted By: coach purses cheap | 6.11.2010 at 3:38 AM
Wow! what an idea ! What a concept ! Beautiful .. Amazing ？
#22 coach purses cheap
Posted By: coach purses cheap | 6.11.2010 at 3:39 AM
Keep posting stuff like this i really like it
#23 coach purses cheap
Posted By: coach purses cheap | 6.11.2010 at 3:40 AM
Keep posting stuff like this i really like it
#24 moncler down jackets
Posted By: moncler down jackets | 6.13.2010 at 2:05 AM
Here elaborates the matter not only extensively but also detailly .I support the write's unique point.It is useful and benefit to your daily life.You can go those <a href=" conditions-encountered.com " >wslmart.net </a> sits to know more relate things.They are strongly recommended by friends.Personally
#25 online poker
Posted By: online poker | 6.17.2010 at 2:27 AM
Thanks for such a great post and the review, I am totally impressed! Keep stuff like this coming.
#26 clothes shop
Posted By: clothes shop | 6.18.2010 at 4:48 AM
I am very interested in the write's view on the leisure. As people's living conditions are increasingly favorable, diversified recreations are accepted by people. Here are some sits can buy to leisure-related products.
#27 michael jordan shoes
Posted By: michael jordan shoes | 6.18.2010 at 8:51 PM
good post!!thank you
#28 UGG Schuhe
Posted By: UGG Schuhe | 6.22.2010 at 1:55 AM
Pretty good post. I just found your site and wanted to say that I have really enjoyed browsing your posts. http://www.uggofficial.de
#29 Ugg Sheepskin Boots
Posted By: Ugg Sheepskin Boots | 6.22.2010 at 1:55 AM
Many thanks for sharing this, very useful! http://www.uggbootshort.com
#30 Ugg Classic Boots
Posted By: Ugg Classic Boots | 6.22.2010 at 1:55 AM
Wow - really powerful post. Thanks for taking time to share this personal perspective that not only we as individuals should heed, but organizations as well. http://www.uggclassicboots.org
#31 Discount Ugg Boots
Posted By: Discount Ugg Boots | 6.22.2010 at 1:56 AM
I really love your website, it's so useful, I'm just baking a cake for my aunt！ http://www.uggmall.us
#32 Vibram Five Fingers
Posted By: Vibram Five Fingers | 6.22.2010 at 1:56 AM
I am glad to post my views and points in this blog. www.fivefingersrunning.com
#33 Bottle Openers
Posted By: Bottle Openers | 6.22.2010 at 3:04 AM
This is my first time i visit here. I found so many interesting stuff in your blog especially its discussion. From the tons of comments on your articles, I guess I am not the only one having all the enjoyment here! keep up the good work.
#34 dizi izle
Posted By: dizi izle | 6.22.2010 at 7:16 AM
Super-Duper site! I am loving it!! Will come back again - taking you feeds also, Thanks.
#35 Louisiana Nursing Degree
Posted By: Louisiana Nursing Degree | 6.23.2010 at 2:04 AM
Hey, guy, your blog is nice. It can bring me many useful information.
#36 cosmetic surgeon
Posted By: cosmetic surgeon | 7.08.2010 at 8:39 AM
Thank you for this post. I am new to your blog and get really very nice. I will keep visiting your blog.
#37 ed hardy
Posted By: ed hardy | 7.16.2010 at 5:04 AM
do you want to become the beautiful scenery this summer? or do you want to attract eyeball among the crowd?now,listen carefully,your wishes will come true here .we support all different kinds of beautiful leisure production,such as sunglasses,t-shiirts and swim trunks et.from here,you will find your favorite things.What are you waiting for?go and choose the now!
#38 ed hardy
Posted By: ed hardy | 7.16.2010 at 5:04 AM
do you want to become the beautiful scenery this summer? or do you want to attract eyeball among the crowd?now,listen carefully,your wishes will come true here .we support all different kinds of beautiful leisure production,such as sunglasses,t-shiirts and swim trunks et.from here,you will find your favorite things.What are you waiting for?go and choose the now!
#39 tiffany jewellery
Posted By: tiffany jewellery | 7.21.2010 at 2:50 AM
For classic and quality genuine silver jewelry, many people choose Tiffany & Co brand.Now,we present you the hottest Tiffany silver jewelry .get more http://www.tiffanyonsale.com/
#40 tiffany co
Posted By: tiffany co | 7.21.2010 at 2:50 AM
For classic and quality genuine silver jewelry, many people choose Tiffany & Co brand.Now,we present you the hottest Tiffany silver jewelry .get more http://www.tiffanyonsale.com/
#41 tiffany jewelry
Posted By: tiffany jewelry | 7.21.2010 at 2:50 AM
For classic and quality genuine silver jewelry, many people choose Tiffany & Co brand.Now,we present you the hottest Tiffany silver jewelry .get more http://www.tiffanyonsale.com/
#42 tiffany jewellery
Posted By: tiffany jewellery | 7.21.2010 at 2:50 AM
For classic and quality genuine silver jewelry, many people choose Tiffany & Co brand.Now,we present you the hottest Tiffany silver jewelry .get more http://www.tiffanyonsale.com/
#43 power chords
Posted By: power chords | 7.22.2010 at 4:43 AM
Please update us more. Thanks a lot!
#44 Abercrombie&Fitch
Posted By: Abercrombie&Fitch | 7.25.2010 at 2:39 AM
Thanks For providing usefull information about SQL SERVER.
http://www.aberclombie.com/ www.aberclombie.com/.../abercrombie-sho
#45 tiffany ring
Posted By: tiffany ring | 7.26.2010 at 6:58 AM
Tiffany On Sale Offer a wide range of fashionable Tiffany & Co silver jewelry, including Necklaces, Pendants, Bracelets, Earrings, Rings and Accessories with fantastic discount.more http://www.tiffanyonsale.com/
#46 tiffany bracelet
Posted By: tiffany bracelet | 7.26.2010 at 6:58 AM
Tiffany On Sale Offer a wide range of fashionable Tiffany & Co silver jewelry, including Necklaces, Pendants, Bracelets, Earrings, Rings and Accessories with fantastic discount.more http://www.tiffanyonsale.com/
#47 tiffany necklace
Posted By: tiffany necklace | 7.26.2010 at 6:58 AM
Tiffany On Sale Offer a wide range of fashionable Tiffany & Co silver jewelry, including Necklaces, Pendants, Bracelets, Earrings, Rings and Accessories with fantastic discount.more http://www.tiffanyonsale.com/
#48 gucci bags
Posted By: gucci bags | 7.29.2010 at 11:25 PM
<a href="http://www.guccicn.net" title="gucci bags"><strong>gucci bags</strong></a>
<a href="http://www.guccicn.net" title="gucci bag"><strong>gucci bag</strong></a>
<a href="http://www.guccicn.net" title="gucci handbags"><strong>gucci handbags</strong></a>
<a href="http://www.guccicn.net" title="gucci handbag"><strong>gucci handbag</strong></a>
<a href="http://www.guccicn.net" title="discount gucci handbags"><strong>discount gucci handbags</strong></a>