
Knight's 24-Hour Trainer : Microsoft SQL Server 2008 Integration Services
by Knight, Brian; Knight, Devin; Davis, MikeRent Book
New Book
We're Sorry
Sold Out
Used Book
We're Sorry
Sold Out
eBook
We're Sorry
Not Available
How Marketplace Works:
- This item is offered by an independent seller and not shipped from our warehouse
- Item details like edition and cover design may differ from our description; see seller's comments before ordering.
- Sellers much confirm and ship within two business days; otherwise, the order will be cancelled and refunded.
- Marketplace purchases cannot be returned to eCampus.com. Contact the seller directly for inquiries; if no response within two days, contact customer service.
- Additional shipping costs apply to Marketplace purchases. Review shipping costs at checkout.
Summary
Author Biography
Devin Knight is a BI consultant at Pragmatic Works. Previously, he has tech edited the book Professional Microsoft SQL Server 2008 Integration Services (John Wiley & Sons, Inc.). Devin has spoken at past conferences like PASS and at several SQL Saturday events. He is a contributing member to the Business Intelligence Special Interest Group (SIG) for PASS as a leader 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 at http://pragmaticworks.com/community/blogs/.
Mike Davis (Jacksonville, Florida) is an author, developer, consultant, and trainer with Pragmatic Works. He has expertise in many areas of Business Intelligence including Integration Services, Reporting Services, Analysis Services, Database Administration, and .NET Software Development. Mike has created enterprise level BI and software solutions for numerous corporations. As a trainer he travels the world teaching classes on SQL Server and BI. He also participates as a speaker at events like SQL Saturdays, SQL Server launches, SQL server user groups, and SQL PASS. In his spare time Mike plays guitar and darts. He is a member of the North Florida Dart League.
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.