Knight's 24-Hour Trainer : Microsoft SQL Server 2008 Integration Services
by Brian Knight; Devin Knight; Mike DavisFormat: eBook
Pub. Date: 2009-06-01
Publisher(s): Wrox
Availability: This title is currently not available.
Other versions by this Author
-
Free Shipping On Orders Over $35
Your order must be $35 or more to qualify for free economy shipping. Marketplace items, eBooks and apparel do not qualify towards the $35 purchase minimum.
List Price: $49.99
Rent Book
Select for Price
New Book
We're Sorry
Sold Out
Used Book
We're Sorry
Sold Out
eBook
We're Sorry
Not Available
Summary
A unique book-and-video package for learning Microsoft SQL Server Integration ServicesIf 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 experience to tackle your first SSIS project with confidence. SQL Server Integration Services 2008 (SSIS) builds on the revolutionary database product suite first introduced by Microsoft in 2005 and is a powerful tool for performing extraction, transformation, and load (ETL) operations essential to data warehousing If you're just learning SSIS, the step-by-step tutorials in this book and DVD training package will ready you to tackle your own first project Every lesson in the book is supplemented by instructional video on the DVD
Table of Contents
| Preface | |
| Welcome To SSIS | |
| Installation and Getting Started | |
| Moving Data with the Import and Export Wizard | |
| Installing SQL Server Integration Services | |
| Installing the Sample Databases | |
| Creating a Solution and Project | |
| Exploring Business Intelligence Development Studio | |
| Creating Your First Package | |
| Tasks | |
| Connecting Control Flow Tasks with Precedence Constraints | |
| Manipulating Files with the File System Task | |
| Coding Custom Script Tasks | |
| Using the Execute SQL Task | |
| Using the Send Mail Task | |
| Using the FTP Task | |
| Creating a Data Flow | |
| Data Flow | |
| Extracting Data from Sources | |
| Loading Data to a Destination | |
| Changing Data Types with the Data Conversion Transform | |
| Creating and Replacing Columns with the Derived Column Transform | |
| Rolling Up Data with the Aggregate Transform | |
| Ordering Data with the Sort Transform | |
| Joining Data with the Lookup Transform | |
| Auditing Data with theRow Count Transform | |
| Combining Multiple Inputs with the Union All Transform | |
| Cleansing Data with the Script Component | |
| Separating Data with the Conditional Split Transform | |
| Altering Rows with the OLE DB Command Transform | |
| Handling Bad Data with the Fuzzy Lookup Transform | |
| Removing Duplicates with the Fuzzy Grouping Transform | |
| Variables and Expressions | |
| Making a Package Dynamic with Variables | |
| Making a Connection Dynamic with Expressions | |
| Making a Task Dynamic with Expressions | |
| Containers | |
| Using Sequence Containers to Organize a Package | |
| Using For Loop Containers to Repeat Control Flow Tasks | |
| Using the Foreach Loop Container to Loop Through a Collection of Objects | |
| Configuration | |
| Easing Deployment with Configuration Tables | |
| Easing Deployment with Configuration Files | |
| Configuring Child Packages | |
| Troubleshooting and Logging | |
| Logging Package Data | |
| Using Event Handlers | |
| Troubleshooting Errors | |
| Using Data Viewers | |
| Using Breakpoints | |
| Deployment and Administration | |
| Deploying Packages | |
| Configuring the SSIS Service | |
| Securing SSIS Packages | |
| Running SSIS Packages | |
| Scheduling Packages | |
| Data Warehousing | |
| Loading a Dimension Table | |
| Loading a Fact Table | |
| Wrap Up and Review | |
| Bringing It All Together | |
| SSIS Component Crib Notes | |
| Problem and Solution Crib Notes | |
| What's on the DVD? | |
| Index | |
| Table of Contents provided by Publisher. All Rights Reserved. |
An electronic version of this book is available through VitalSource.
This book is viewable on PC, Mac, iPhone, iPad, iPod Touch, and most smartphones.
By purchasing, you will be able to view this book online, as well as download it, for the chosen number of days.
Digital License
You are licensing a digital product for a set duration. Durations are set forth in the product description, with "Lifetime" typically meaning five (5) years of online access and permanent download to a supported device. All licenses are non-transferable.
More details can be found here.
A downloadable version of this book is available through the eCampus Reader or compatible Adobe readers.
Applications are available on iOS, Android, PC, Mac, and Windows Mobile platforms.
Please view the compatibility matrix prior to purchase.