Wightman Pro SQL Server 2005 Integration Services

1. ed
ISBN: 978-1-4302-0448-0
Verlag: Apress
Format: PDF
Kopierschutz: 1 - PDF Watermark

E-Book, Englisch, 548 Seiten

Written for the developer, the DBA, and the data artisan, Pro SQL Server 2005 Integration Services will show you how to develop and deploy enterprise SSIS solutions in multibillion-item environments. In addition, it details how to build bespoke custom components tailored to your project's exact requirements as well as create performant and scalable solutions with an eye to future requirements and upgrades. Written by an author who has been using SSIS since its inception this book uses efficient best practice methods to achieve results for the most demanding user.

James Wightman is an average guy. A programmer, problem solver, artist, and artisan, he loves his work and his family, and he's looking for that one chance to change the world. Born in 1975, James spent his formative years reading Marvel comics and books by Tolkien before discovering computers in 1980. Teaching himself to program computers at the age of 6, he wrote himself a teaching aid to learn pure mathematics and then translated the program into Z80 machine language. From there, he learned C and then became adept with 68000 assembly language and eventually C++, writing two games one released commercially for the Commodore Amiga. James is an innovator in many ways and in many areas. At age 11, he invented a way for aircraft to land with increased safety, and at age 12, he invented a VCR that could record four simultaneous broadcast streams onto a standard VHS tape. That you don't own a VCR that records four channels at once and that aircraft still make a squealing sound when their wheels touch tarmac indicate how well the designs of a preteen are received by companies such as Sony and Boeing. His next invention will rock the world to its very foundations. Or at least cause a ripple. Maybe. So he hopes. Having worked on the largest of Microsoft technology led projects for some of the biggest companies worldwide for the past 15 years, James is honored to have worked on his second book, Pro SQL Server 2005 Integration Services, and hopes that writing will remain a part of his ongoing commitment to programming and the programming community. Currently, his time is taken up learning the Mandarin, Japanese, and Russian languages as well as spending time on the MSDN forums trying to help his peers. In his spare time, he works on his next books for Apress. He was also recently voted in as a school governor. In his work life, James is technical lead on a project in cooperation with Microsoft which could, quite literally, save the planet.

Autoren/Hrsg.

Wightman, James

Inhaltsverzeichnis

1;Contents at a Glance;5
2;Contents;6
3;Foreword;15
4;About the Author;16
5;About the Technical Reviewer;17
6;Acknowledgments;18
7;Introduction;19
8;Introducing SQL Server 2005 Integration Services;22
8.1;A Little History;23
8.2;What Can SSIS Do?;24
8.3;The First Time Ever I Saw SSIS;27
8.4;I Have Such Delights to Show You;27
8.5;An Interview with Donald Farmer;28
8.6;Become a Knowledge Broker;31
8.7;Summary;33
9;The Architecture of SSIS;34
9.1;A Brief SQL Server Architecture Overview;34
9.2;SSIS and SQL Server Analysis Services;35
9.3;Common Language Runtime Integration;36
9.4;SSIS Architecture Overview;36
9.5;The Power of the Data Flow Architecture;42
9.6;Summary;49
10;From DTS to SSIS;50
10.1;What’s New?;50
10.2;Preparing to Migrate Legacy DTS Packages;51
10.3;Using the Package Migration Wizard;60
10.4;Summary;64
11;The IDE and Extending Visual Studio;65
11.1;A First Look at BIDS;65
11.2;Projects and Solutions;66
11.3;Properties Explorer;71
11.4;Compilation, Running, and Debugging;73
11.5;The Toolbox;80
11.6;Class Explorer;81
11.7;Project Templates;82
11.8;The SSIS Menu;83
11.9;Package Explorer;89
11.10;Execution Results;90
11.11;Summary;91
12;Package Hierarchy;93
12.1;Vocabulary;94
12.2;Containers;94
12.3;Packages;95
12.4;Checkpoints;95
12.5;Variables;96
12.6;Variable Scope;97
12.7;Event Handlers;98
12.8;Adding Components;102
12.9;Using Executable Designers;102
12.10;Precedence Constraints;102
12.11;Flow Between Executables;104
12.12;Directing Errors;108
12.13;Summary;110
13;Control Flow;111
13.1;Where Does the Control Flow Fit?;112
13.2;For Loop Container;113
13.3;Foreach Loop Container;115
13.4;Sequence;132
13.5;ActiveX Script Task;133
13.6;Analysis Services Execute DDL Task;133
13.7;DDL Configuration;134
13.8;Analysis Services Processing Task;135
13.9;Bulk Insert Task;136
13.10;Data Mining Query Task;140
13.11;Execute DTS 2000 Package Task;141
13.12;Execute Package Task;142
13.13;Execute Process Task;143
13.14;Execute SQL Task;146
13.15;File System Task;148
13.16;FTP Task;149
13.17;Message Queue Task;150
13.18;Script Task;151
13.19;Send Mail Task;153
13.20;Transfer Database Task;154
13.21;Transfer Error Messages Task;154
13.22;Transfer Jobs Task;155
13.23;Transfer Logins Task;156
13.24;Transfer Master Stored Procedures Task;156
13.25;Transfer SQL Server Objects Task;157
13.26;Web Service Task;158
13.27;WMI Data Reader Task;166
13.28;WMI Event Watcher Task;166
13.29;XML Task;166
13.30;Summary;175
14;Maintenance Plans;176
14.1;Back Up Database;176
14.2;Check Database Integrity;179
14.3;Execute SQL Server Agent Job;180
14.4;Execute T- SQL Statement;181
14.5;History Cleanup;181
14.6;Maintenance Cleanup;183
14.7;Notify Operator;184
14.8;Rebuild Index;185
14.9;Reorganize Index;186
14.10;Shrink Database;187
14.11;Update Statistics;187
14.12;Summary;188
15;Data Flow Data Sources;189
15.1;DataReader Source;189
15.2;Excel Source;196
15.3;Flat File Source;200
15.4;OLEDB Source;209
15.5;Raw File Source;212
15.6;XML Source;213
15.7;Summary;216
16;Basic Data Flow Transformations;217
16.1;SSIS Data Types;217
16.2;Data Viewers;218
16.3;Audit;222
16.4;Character Map;222
16.5;Conditional Split;223
16.6;Copy Column;230
16.7;Data Conversion;232
16.8;Derived Column;233
16.9;Export Column;236
16.10;Import Column;238
16.11;Lookup;239
16.12;Merge;243
16.13;Merge Join;250
16.14;Multicast;252
16.15;OLE DB Command;253
16.16;Percentage Sampling;254
16.17;Row Count;255
16.18;Row Sampling;256
16.19;Sort;256
16.20;Union All;257
16.21;Summary;258
17;Advanced Data Flow Transformations;259
17.1;Aggregate;260
17.2;Data Mining Query;263
17.3;Fuzzy Grouping;263
17.4;Fuzzy Lookup;266
17.5;Pivot;272
17.6;Script Component;276
17.7;Slowly Changing Dimension;281
17.8;Term Extraction;286
17.9;Term Lookup;291
17.10;Unpivot;294
17.11;Summary;298
18;Data Flow Destinations;299
18.1;Data Mining Model Training;299
18.2;DataReader Destination;301
18.3;Dimension Processing;302
18.4;Excel Destination;305
18.5;Flat File Destination;309
18.6;OLE DB Destination;310
18.7;Partition Processing;314
18.8;Raw File Destination;318
18.9;Recordset Destination;320
18.10;SQL Server Destination;321
18.11;SQL Server Mobile Destination;324
18.12;Summary;326
19;Optimization for SSIS;327
19.1;Decisions: The Basics;327
19.2;Identifying Performance Issues;331
19.3;SQL Server Tweaks;348
19.4;SSIS- Specific Optimizations;349
19.5;Summary;353
20;SSIS Security;355
20.1;SSIS Security Options;356
20.2;Custom Security Options;369
20.3;Summary;371
21;Scripting, .NET Style;372
21.1;Development Environments;372
21.2;OOP;373
21.3;Design Patterns;379
21.4;. NET Concepts;380
21.5;Classes in the Script Component;382
21.6;Script Component Crash Course;386
21.7;Summary;402
22;Custom Components;403
22.1;What Flavor Would You Like?;404
22.2;What Makes a Custom Component?;405
22.3;Deriving from and Overriding SSIS Classes;408
22.4;Putting It All Together;415
22.5;Designers;468
22.6;Summary;472
23;Interview with Donald Farmer;474
24;The Package Object;478
24.1;Package Properties;478
24.2;Package Methods;488
25;The Control Flow Object;492
25.1;Control Flow Common Properties;492
25.2;Control Flow Task Properties;495
26;Maintenance Plans Reference;524
26.1;Maintenance- Plan Tasks Common Properties;524
26.2;Maintenance- Plan Tasks;528
27;Data Flow Object Reference;534
28;Index;538