Knight's 24-hour trainer : Microsoft SQL server 2008 integration services by Knight, Brian, 1976-, Knight, Devin; Davis, Mike, 1976- instant download

Knight's 24-hour trainer : Microsoft SQL server 2008 integration services by Knight, Brian, 1976-, Knight, Devin; Davis, Mike, 1976- instant download

1 online resource (xxiii, 357 pages) :, A unique book-and-video package for learning Microsoft SQL Server Integration Services. If you need a practical, hands-on introduction to Microsoft SQL Server 2008 Integration Services (SSIS), this book and video package from foremost SSIS authority Brian Knight gets you thoroughly up to speed. Each lesson in the book includes three major components: a thorough description of how each SSIS feature or process works; a tutorial that walks you through the process or technique; and a video lesson that demonstrates it. If you take full advantage of this comprehensive package, you will gain enough e, Print version record, Knight's 24-Hour Trainer: Microsoft® SQL Server® 2008 Integration Services; About the Authors; Acknowledgments; Contents; Preface; Who This Book Is For; What This Book Covers; How This Book Is Structured; What This Book Covers; Instructional Videos on DVD; Conventions; Supporting Packages and Code; Errata; p2p.wrox.com; Welcome to SSIS; Import and Export Wizard; The Business Intelligence Development Studio; Architecture; Editions of SQL Server 2008; Summary; Section I: Installation and Getting Started; Lesson 1: Moving Data with the Import and Export Wizard; Try It, Lesson 2: Installing SQL Server Integration ServicesLesson 3: Installing the Sample Databases; Try It; Lesson 4: Creating a Solution and Project; Try It; Lesson 5: Exploring Business Intelligence Development Studio; The Solution Explorer; The Properties Window; The Toolbox; The BIDS Design Environment; Lesson 6: Creating Your First Package; Creating and Using Connection Managers; Using and Configuring Tasks; Exploring Package Encryption; Executing Packages; Try It; Section II: Tasks; Lesson 7: Connecting Control Flow Tasks with Precedence Constraints; Try It, Lesson 8: Manipulating Files with the File System TaskTry It; Lesson 9: Coding Custom Script Tasks; Try It; Lesson 10: Using the Execute SQL Task; Try It; Lesson 11: Using the Send Mail Task; Try…