SSIS for real:  A walk through a real-world project

In this presentation Joel will walk though a complete real-world SSIS project that pulls data from an AS/400 and converts it to a SQL Server destination.  In addition to specific AS/400 conversion issues he will also cover topics like dynamic OLEDB connections, and creating an effective work flow.  Along the way he'll take a look at how he uses Derived Columns, Conditional Split, Lookup, and Script components to solve every day conversion issues.

Joel Cochran is an Expression Blend MVP, an INETA Community Champion, and a Microsoft Certified Technology Specialist (MCTS) in Windows Forms and WPF. He is the founder of BlendSIG, a virtual Special Interest Group focused on Expression Blend and author of "Expression Blend in Action" by Manning Publications. He is also the author of "The Practical MVVM Manifesto" (http://practicalmvvm.com).  He has been developing for Windows since 2003 and is a self-proclaimed "Blend Evangelist". A frequent speaker at User Groups and Code Camps, he enjoys teaching and writing about .NET and other topics. You can find him online at http://www.developingfor.net or on Twitter at http://twitter.com/joelcochran. Joel has served as the Director of Operations for Stonewall Technologies, Inc., an ISV, in Staunton, VA, since 2000.

Sponsored by:  inmotion hosting