geekSpeak recording - Real World SQL Server Integration Services with Matthew Roche
- Posted: Aug 22, 2007 at 11:31AM
- 5,506 views
- 1 comment
Loading user information from Channel 9
Something went wrong getting user information from Channel 9
Loading user information from MSDN
Something went wrong getting user information from MSDN
Loading Visual Studio Achievements
Something went wrong getting the Visual Studio Achievements
Right click “Save as…”
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!