3/09/2007 9:46:10 PM
Session 1: Dylan Tusler
This session will cover two brief case studies of converting legacy ETL (Extract, Transform, Load) processes into SSIS packages. Topics to cover:
* Deciding to use SSIS
* Picking apart the legacy processes
* Setting up an SSIS Package Project in Visual Studio (and TFS)
* Deploying an SSIS Package
* Passing Parameters to a package from ASP.NET (to provide a launching place.)
* Scheduling a Package
* Creating a Package Configuration File (and dealing with confidential information.)
About the Presenter
Dylan Tusler started out in commercial software development at age 12. After spending much of the next 17 years as an independant software developer/consultant, he moved to the UK to work in software R&D for Mortgage and Insurance software house Marlborough-Stirling (now Vertex.)
Since returning from the UK in 2003, Dylan has been working at Maroochy Shire Council (soon to be the Sunshine Coast Regional Council) as their Integration Analyst and lead developer. He has overseen the introduction of .NET software development at the Council, including the deployment of TFS. Dylan is an MCSD and an MCDBA.
Session 2: Catherine Eibner
Upgrading existing DTS Packages to SQL Server Integration Services (SSIS) is one of the most controversial upgrade topics, as SSIS is not simply an upgrade to DTS but version 1.0 of a brand new product. Based on real world experience Catherine Eibner will demonstrate how to perform some of the common day-to-day task in SSIS as well as the pitfalls to be aware of to ensure that the DTS upgrade path is as painless as possible.
About the Presenter
Catherine Eibner is currently based in Sydney, Australia working as a Senior System Designer for Cybner Computer Solutions (www.cybner.com.au). Catherine has just past the half way point in achieving a Masters of Solution Development with CSU & IT Masters. Catherine has worked in various roles in the IT industry since 1997 ranging from Testing, Database Development, Windows & Web Development to Training & Project Management. Catherine has been a MCP since 2002, and has just recently achieved an MCTS in SQL 2005 and is aiming to get MCT status this year as well as Small Business Specialist, and a few more other Microsoft exams under her belt for her Masters.
Venue: Microsoft Brisbane Office, Level 9, Waterfront Place, 1 Eagle Street |
Duration Catering from 5:30PM for a 6:00PM Start |
On: Thursday, 25 October 2007