The Microsoft “End of Life” policy for SQL 2000 has encouraged many organizations to seriously look at migrating their SQL2000 servers to SQL2005 or 2008. One of the biggest obstacles to a rapid migration is the DTS package issue. To gain the performance benefits and a supported path forward for the functionality in DTS, these packages should be converted into native SSIS. As we all know, the conversion is NOT straightforward. SSIS is more powerful and significantly different from DTS.

Join us as SQL Server and author, Brian Knight shares his knowledge about:

•         Why you should upgrade from DTS to Integration Services.
•         Advantages of SSIS over DTS
•         Options for converting DTS packages to native SSIS
•         Adding value to packages during the conversion process
•         Assessing the scope of a DTS conversion project (time, costs)
•         See a demonstration of DTS xChange , a tool used to convert DTS packages

Speaker's Bio:

Brian Knight, SQL Server MVP, MCSE, MCDBA, is the co-founder of SQLServerCentral.com and JumpstartTV.com. He runs the local SQL Server users group in Jacksonville (JSSUG) and was on the Board of Directors of the Professional Association for SQL Server (PASS). Brian is a contributing columnist for SQL Server Standard and also maintains a regular column for the database website SQLServerCentral.com and does regular webcasts at Jumpstart TV. He has co-authored and authored more than 9 SQL Server books including Admin911: SQL Server (Osborne/McGraw-Hill Publishing), Professional SQL Server DTS, Expert SSIS, Professional SQL Server 2005 Administration and Professional SQL Server 2005 SSIS (Wrox Press). Brian is a frequent speaker at conferences like PASS, SQL Connections and TechEd and many Code Camps.

Agenda:

6:00 PM Networking and Pizza

7:00 PM Presentation

8:00 PM Meeting end