geekSpeak recording - Real World SQL Server Integration Services with Matthew Roche
- Posted: Aug 22, 2007 at 11:31 AM
- 4,828 Views
- 1 Comment
Download
How do I download the videos?
- To download, right click the file type you would like and pick “Save target as…” or “Save link as…”
Why should I download videos from Channel9?
- It's an easy way to save the videos you like locally.
- You can save the videos in order to watch them offline.
- If all you want is to hear the audio, you can download the MP3!
Which version should I choose?
- If you want to view the video on your PC, Xbox or Media Center, download the High Quality WMV file (this is the highest quality version we have available).
- If you'd like a lower bitrate version, to reduce the download time or cost, then choose the Medium Quality WMV file.
- If you have a Zune, WP7, iPhone, iPad, or iPod device, choose the low or medium MP4 file.
- If you just want to hear the audio of the video, choose the MP3 file.
Right click “Save as…”
- Mid Quality WMV (Lo-band, Mobile)
This geekSpeak is all about SQL Server 2005 Integration Services. We are lucky to have a real expert from the industry,
Matthew Roche, to share his experiences with us.
Matthew shows us how SSIS is a real development studio, since it's an instance of Visual Studio 2005, with new designers. It's very familiar for folks who are moving from a traditional development environment. He gets us familiar with tools and techniques,
solutions and projects, like the drag-and-drop approach to building packages, opportunities to include scripts, and develop your own components as .NET Assemblies.
Matthew answers some great questions around performance, programmability. He helps us understand the distinction between data flows and control flows, and how best to manage SSIS packages.
He offers some useful guidance on what scenarios merit what choices for moving data from one place to another - be it .NET app, SSIS, TSQL, BCP and so on.
But the most important reason to watch is to find out what Matthew would "chew off his own mouse finger" to avoid having to do. 
Be sure to check the geekSpeak blog for upcoming geekSpeaks!
Comments Closed
Comments have been closed since this content was published more than 30 days ago, but if you'd like to continue the conversation,
please create a new thread in our Forums,
or
Contact Us and let us know.
Follow the Discussion
sorry to moan - but i find all the "geek speak's" i've listened to so far very painful - the first 15 mins seems to consist of back slapping - which is very nice and all but i have a short attention span so after 5 mins i'm ready to chop my mouse finger off - can you guys not just get to the bones of the topic allot quicker please please
sorry to compain - i love the videos and screen casts and sandbox stuff - they get right to the meat straight away
although the sandbox stuff often times out before i finish - so i have to start all over again - the time constraint is such that afterwards i struggle to figure out what i've learned as i get so stressed about the "timeout" that my attension is not really on the topic sadly
all the best - it has gotten a whole lot better - i mean once upon a time their was little or no audio/visual training except for employers spending a fortune once every three years - which is a lng time to waut when u r struggling - and audio visual for me is waaaaayyy better that dry old anbigous jargon filled pdf's - i'm frickin lovin the videos and screen casts both here on ch9 and the asp.net site learn stufff -fabrutsio
ta -j
Remove this comment
Remove this thread
close