Knight / Davis Knight's 24-Hour Trainer

Microsoft SQL Server 2008 Integration Services
1. Auflage 2011
ISBN: 978-1-118-28744-6
Verlag: John Wiley & Sons
Format: EPUB
Kopierschutz: Adobe DRM (»Systemvoraussetzungen)

E-Book, Englisch, 384 Seiten, E-Book

A unique book-and-video package for learning Microsoft SQLServer Integration Services
If you need a practical, hands-on introduction to Microsoft SQLServer 2008 Integration Services (SSIS), this book and videopackage from foremost SSIS authority Brian Knight gets youthoroughly up to speed. Each lesson in the book includes threemajor components: a thorough description of how each SSIS featureor process works; a tutorial that walks you through the process ortechnique; and a video lesson that demonstrates it.
If you take full advantage of this comprehensive package, youwill gain enough experience to tackle your first SSIS project withconfidence.
* SQL Server Integration Services 2008 (SSIS) builds on therevolutionary database product suite first introduced by Microsoftin 2005 and is a powerful tool for performing extraction,transformation, and load (ETL) operations essential to datawarehousing
* If you're just learning SSIS, the step-by-step tutorials inthis book and DVD training package will ready you to tackle yourown first project
* Every lesson in the book is supplemented by instructional videoon the DVD
Note:As a part of this title, video lessons are included onDVD. For the e-book versions, video lessons can be accessed atwrox.com using a link provided in the interior of thee-book.

Autoren/Hrsg.

Knight, Brian

Knight, Devin

Davis, Mike

Inhaltsverzeichnis

Preface.
Welcome To SSIS.
Section I: Installation and Getting Started
Lesson 1: Moving Data with the Import and Export Wizard.
Lesson 2: Installing SQL Server Integration Services.
Lesson 3: Installing the Sample Databases.
Lesson 4: Creating a Solution and Project.
Lesson 5: Exploring Business Intelligence DevelopmentStudio.
Lesson 6: Creating Your First Package.
Section II: Tasks.
Lesson 7: Connecting Control Flow Tasks with PrecedenceConstraints.
Lesson 8: Manipulating Files with the File System Task.
Lesson 9: Coding Custom Script Tasks.
Lesson 10: Using the Execute SQL Task.
Lesson 11: Using the Send Mail Task.
Lesson 12: Using the FTP Task.
Lesson 13: Creating a Data Flow.
Section III: Data Flow.
Lesson 14: Extracting Data from Sources.
Lesson 15: Loading Data to a Destination.
Lesson 16: Changing Data Types with the Data ConversionTransform.
Lesson 17: Creating and Replacing Columns with the DerivedColumn Transform.
Lesson 18: Rolling Up Data with the Aggregate Transform.
Lesson 19: Ordering Data with the Sort Transform.
Lesson 20: Joining Data with the Lookup Transform.
Lesson 21: Auditing Data with theRow Count Transform.
Lesson 22: Combining Multiple Inputs with the Union AllTransform.
Lesson 23: Cleansing Data with the Script Component.
Lesson 24: Separating Data with the Conditional SplitTransform.
Lesson 25: Altering Rows with the OLE DB Command Transform.
Lesson 26: Handling Bad Data with the Fuzzy LookupTransform.
Lesson 27: Removing Duplicates with the Fuzzy GroupingTransform.
Section IV: Variables and Expressions.
Lesson 28: Making a Package Dynamic with Variables.
Lesson 29: Making a Connection Dynamic with Expressions.
Lesson 30: Making a Task Dynamic with Expressions.
Section V: Containers.
Lesson 31: Using Sequence Containers to Organize a Package.
Lesson 32: Using For Loop Containers to Repeat Control FlowTasks.
Lesson 33: Using the Foreach Loop Container to Loop Through aCollection of Objects.
Section VI: Configuration.
Lesson 34: Easing Deployment with Configuration Tables.
Lesson 35: Easing Deployment with Configuration Files.
Lesson 36: Configuring Child Packages.
Section VII: Troubleshooting and Logging.
Lesson 37: Logging Package Data.
Lesson 38: Using Event Handlers.
Lesson 39: Troubleshooting Errors.
Lesson 40: Using Data Viewers.
Lesson 41: Using Breakpoints.
Section VIII: Deployment and Administration.
Lesson 42: Deploying Packages.
Lesson 43: Configuring the SSIS Service.
Lesson 44: Securing SSIS Packages.
Lesson 45: Running SSIS Packages.
Lesson 46: Scheduling Packages.
Section IX: Data Warehousing.
Lesson 47: Loading a Dimension Table.
Lesson 48: Loading a Fact Table.
Section X: Wrap Up and Review.
Lesson 49: Bringing It All Together.
Appendix A: SSIS Component Crib Notes.
Appendix B: Problem and Solution Crib Notes.
Appendix C: What's on the DVD?
Index.

Über Autor(innen)

Brian Knight, SQL Server MVP, MCITP, MCSE, MCDBA, is theowner and founder of Pragmatic Works. He is also the co-founder ofSQLServerCentral.com and JumpstartTV.com. He runs the local SQLServer users group in Jacksonville (JSSUG). Brian is a contributingcolumnist at several technical magazines and does regular webcastsat Jumpstart TV. He is the author of ten SQL Server books. Brianhas spoken at conferences like PASS, SQL Connections, and TechEdand many Code Camps. His blog can be found athttp://www.pragmaticworks.com. Brian watches his 401k wither awayin Jacksonville, Florida.
Devin Knight is a BI consultant at Pragmatic Works.Previously, he has tech edited the book Professional MicrosoftSQL Server 2008 Integration Services (John Wiley & Sons,Inc.). Devin has spoken at past conferences like PASS and atseveral SQL Saturday events. He is a contributing member to theBusiness Intelligence Special Interest Group (SIG) for PASS as aleader in the SSIS Focus Group. Making his home in Jacksonville,Florida, Devin is a participating member of the local users'group (JSSUG). Visit his blog athttp://pragmaticworks.com/community/blogs/.
Mike Davis (Jacksonville, Florida) is an author,developer, consultant, and trainer with Pragmatic Works. He hasexpertise in many areas of Business Intelligence includingIntegration Services, Reporting Services, Analysis Services,Database Administration, and .NET Software Development. Mike hascreated enterprise level BI and software solutions for numerouscorporations. As a trainer he travels the world teaching classes onSQL Server and BI. He also participates as a speaker at events likeSQL Saturdays, SQL Server launches, SQL server user groups, and SQLPASS. In his spare time Mike plays guitar and darts. He is a memberof the North Florida Dart League.