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!