Section IV: Variables and Expressions
Lesson 28: Making a Package Dynamic with Variables....................................................... 205
Lesson 29: Making a Connection Dynamic with Expressions .............................................. 211
Lesson 30: Making a Task Dynamic with Expressions ........................................................ 217
Section V: Containers
Lesson 31: Using Sequence Containers to Organize a Package .......................................... 225
Lesson 32: Using For Loop Containers to Repeat Control Flow Tasks .................................. 229
Lesson 33: Using the Foreach Loop Container to Loop Through a Collection
of Objects ....................................................................................................... 235
Section VI: Configuration
Lesson 34: Easing Deployment with Configuration Tables ................................................... 243
Lesson 35: Easing Deployment with Configuration Files ..................................................... 249
Lesson 36: Configuring Child Packages ............................................................................. 255
Section VII: Troubleshooting and Logging
Lesson 37: Logging Package Data .................................................................................... 263
Lesson 38: Using Event Handlers ...................................................................................... 269
Lesson 39: Troubleshooting Errors ..................................................................................... 275
Lesson 40: Using Data Viewers ......................................................................................... 281
Lesson 41: Using Breakpoints ........................................................................................... 287
Section VIII: Deployment and Administration
Lesson 42: Deploying Packages ........................................................................................ 295
Lesson 43: Configuring the SSIS Service ........................................................................... 301
Lesson 44: Securing SSIS Packages ................................................................................. 305
Lesson 45: Running SSIS Packages .................................................................................. 309
Lesson 46: Scheduling Packages ...................................................................................... 315
Section IX: Data Warehousing
Lesson 47: Loading a Dimension Table .............................................................................. 321
Lesson 48: Loading a Fact Table ....................................................................................... 327
Section X: Wrap Up and Review
Lesson 49: Bringing It All Together.................................................................................... 333
Appendix A: SSIS Component Crib Notes ........................................................................... 339
Appendix B: Problem and Solution Crib Notes .................................................................... 343
Appendix C: What’s on the DVD? ....................................................................................... 347
Index ............................................................................................................................... 349
ffirs.indd iiffirs.indd ii 6/8/09 2:39:53 PM6/8/09 2:39:53 PM
评论4