This book and video package is geared at introducing DBAs and developers who are just starting to get a handle on Microsoft Business Intelligence tools, and SQL Server Integration Services (SSIS) in particular. The book and accompanying video give the novice reader just enough experience with the product to start their first SSIS project.
The book tightly integrates instructional videos--provided on the book's accompanying DVD--with each of the hands-on lessons found in the book.

About the Author

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 recently 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 is the author of Professional SQL Server 2005/2008 Administration and Professional SQL Server 2005/2008 SQL Server Integration Services (Wrox Press). Brian has spoken at conferences like PASS, SQL Connections and TechEd and many Code Camps. His blog can be found at http://www.PragmaticWorks.com. Brian is an independent consultant at Pragmatic Works.

Table of Contents:
Preface. Welcome To SSIS. · Section I: Installation and Getting Started · Section II: Tasks. · Section III: Data Flow. · Section IV: Variables and Expressions. · Section V: Containers. · Section VI: Configuration. · Section VII: Troubleshooting and Logging. · Section VIII: Deployment and Administration. · Section IX: Data Warehousing. · Section X: Wrap Up and Review. Appendix A: SSIS Component Crib Notes. Appendix B: Problem and Solution Crib Notes. Appendix C: What's on the DVD? Index.