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 in particular. It is therefore intended to be the first book you read and the first video you watch before moving on to Knight's Professional SQL Server 2012 Integration Services. The book and accompanying video give the novice reader just enough experience with the product to start their first SSIS project.

About the Author

Brian Knight is an independent consultant at Pragmatic Works and co-founder of SQLServerCentral.com. He runs the Jacksonville SQL Server Users Group, is a contributing columnist for SQL Server Standard, and writes a regular column for SQLServerCentral.com.

Table of Contents:
PREFACE WELCOME TO SSIS SECTION 1: 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 SQL SERVER DATA TOOLS · LESSON 6: CREATING YOUR FIRST PACKAGE · LESSON 7: UPGRADING PACKAGES TO SQL SERVER 2012 · LESSON 8: UPGRADING TO THE PROJECT DEPLOYMENT MODEL SECTION 2: CONTROL FLOW · LESSON 9: USING PRECEDENCE CONSTRAINTS · LESSON 10: MANIPULATING FILES WITH THE FILE SYSTEM TASK · LESSON 11: CODING CUSTOM SCRIPT TASKS · LESSON 12: USING THE EXECUTE SQL TASK · LESSON 13: USING THE EXECUTE PROCESS TASK · LESSON 14: USING THE EXPRESSION TASK · LESSON 15: USING THE SEND MAIL TASK · LESSON 16: USING THE FTP TASK · LESSON 17: CREATING A DATA FLOW SECTION 3: DATA FLOW · LESSON 18: EXTRACTING DATA FROM SOURCES · LESSON 19: LOADING DATA TO A DESTINATION · LESSON 20: CHANGING DATA TYPES WITH THE DATA CONVERSION TRANSFORM · LESSON 21: CREATING AND REPLACING COLUMNS WITH THE DERIVED COLUMN TRANSFORM · LESSON 22: ROLLING UP DATA WITH THE AGGREGATE TRANSFORM · LESSON 23: ORDERING DATA WITH THE SORT TRANSFORM · LESSON 24: JOINING DATA WITH THE LOOKUP TRANSFORM · LESSON 25: AUDITING DATA WITH THE ROW COUNT TRANSFORM · LESSON 26: COMBINING MULTIPLE INPUTS WITH THE UNION ALL TRANSFORM · LESSON 27: CLEANSING DATA WITH THE SCRIPT COMPONENT · LESSON 28: SEPARATING DATA WITH THE CONDITIONAL SPLIT TRANSFORM · LESSON 29: ALTERING ROWS WITH THE OLE DB COMMAND TRANSFORM · LESSON 30: HANDLING BAD DATA WITH THE FUZZY LOOKUP · LESSON 31: REMOVING DUPLICATES WITH THE FUZZY GROUPING TRANSFORM SECTION 4: MAKING PACKAGES DYNAMIC · LESSON 32: MAKING A PACKAGE DYNAMIC WITH VARIABLES · LESSON 33: MAKING A PACKAGE DYNAMIC WITH PARAMETERS · LESSON 34: MAKING A CONNECTION DYNAMIC WITH EXPRESSIONS · LESSON 35: MAKING A TASK DYNAMIC WITH EXPRESSIONS SECTION 5: COMMON ETL SCENARIOS · LESSON 36: LOADING DATA INCREMENTALLY · LESSON 37: USING THE CDC COMPONENTS IN SSIS · LESSON 38: USING DATA QUALITY SERVICES · LESSON 39: USING THE DQS CLEANSING TRANSFORM · LESSON 40: CREATING A MASTER PACKAGE SECTION 6: CONTAINERS · LESSON 41: USING SEQUENCE CONTAINERS TO ORGANIZE A PACKAGE · LESSON 42: USING FOR LOOP CONTAINERS TO REPEAT CONTROL FLOW TASKS · LESSON 43: USING THE FOREACH LOOP CONTAINER TO LOOP THROUGH A COLLECTION OF OBJECTS SECTION 7: CONFIGURING PACKAGES · LESSON 44: EASING DEPLOYMENT WITH CONFIGURATION TABLES · LESSON 45: EASING DEPLOYMENT WITH CONFIGURATION FILES · LESSON 46: CONFIGURING CHILD PACKAGES SECTION 8: TROUBLESHOOTING SSIS · LESSON 47: LOGGING PACKAGE DATA · LESSON 48: USING EVENT HANDLERS · LESSON 49: TROUBLESHOOTING ERRORS · LESSON 50: USING DATA VIEWERS · LESSON 51: USING BREAKPOINTS SECTION 9: ADMINISTERING SSIS · LESSON 52: CREATING AND CONFIGURING THE SSIS CATALOG · LESSON 53: DEPLOYING PACKAGES TO THE PACKAGE CATALOG · LESSON 54: CONFIGURING THE PACKAGES · LESSON 55: CONFIGURING THE SERVICE · LESSON 56: SECURING SSIS PACKAGES · LESSON 57: RUNNING SSIS PACKAGES · LESSON 58: RUNNING PACKAGES IN T-SQL AND DEBUGGING PACKAGES · LESSON 59: SCHEDULING PACKAGES SECTION 10: LOADING A WAREHOUSE · LESSON 60: DIMENSION LOAD · LESSON 61: FACT TABLE LOAD SECTION 11: WRAP UP AND REVIEW · LESSON 62: 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