.
 
.

Microsoft Sql Server 2008 Integration Services Unleashed

Avtor:

.
Redna cena: 49,09 €
Rok dobave: 2-4 dni.
.
.
Količina:  
.
Strošek dostave je enoten za celo Slovenijo in znaša 2,95 €, ne glede na količino in vrsto kupljenih izdelkov.

Številni izdelki imajo oznako "brezplačna dostava", kar pomeni, da v prmeru nakupa takšnega izdelka poštnine ne boste plačali. 

Več o dostavi
Emka.si omogoča naslednje načine plačila:
  • z gotovino ob prevzemu (velja le za fizične osebe),
  • s plačilno oziroma kreditno kartico (Mastercard, Visa, ActivaMaestro, Activa, Diners, American Express),
  • s storitvijo Moneta (Mobitel in Simobil)
  • Plačilo po predračunu (pravne osebe)
  • Račun z odlogom plačila (za javna podjetja)
Več o plačilih

Pri vsakem izdelku je naveden predviden rok dostave. Glede na to katere izdelke izberete, se vam pri oddaji naročila prikaže tudi končni predviden datum dobave vašega pakete.

Večino izdelkov dostavljamo iz lastne zaloge, zato so naši dobavni roki zelo kratki.

Ko vam bomo poslali paket boste o tem obveščeni tudi po emailu. V emailu bo navedena številka vašega paketa ter povezava do Pošte Slovenije, kjer boste lahko preverili natančen status dostave.

Več o dostavi

To je spletna cena
Shrani v seznam želja
.

.

Opis

Foreword... xx Part I Getting Started 1 What Is Integration Services and Why Do I Need It? 3 What Is SQL Server Integration Services?... 3 Data Import/Export Wizard... 3 ETL Tool... 3 Control Flow Engine... 4 Application Platform... 4 High Performance Data Transformation Data Pipeline 4 A Short Integration Services History... 4 How This Book Is Organized... 5 The Sample Projects... 6 Summary... 7 2 Setting Up Integration Services 9 Installing IS... 9 Setting Up Integration Services... 10 Setting Up Book Samples... 16 Where Are the Components Installed?... 17 Business Intelligence Development Studio... 17 Management Studio... 17 Import/Export Wizard... 17 Copy Database Wizard... 17 The DTS Package Migration Wizard... 18 SSIS Package Upgrade Wizard... 18 Data Profile Viewer... 18 DTExec, DTUtil... 18 DTExecUI... 18 Helpful Resources... 18 SQL Server 2008 Setup and Upgrade Forum... 19 Books Online... 19 SQLIS.COM... 19 Blogs... 19 MSDN... 20 The SQL Server Integration Services Forum... 20 Summary... 20 3 What's New in Integration Services 2008 21 What's New for DTS Users... 21 Control Flow Changes... 21 Data Flow... 22 What's New for Integration Services 2005 Users... 22 Improved Data Flow Task... 22 Improved Scripting Experience... 23 The Data Profiling Task... 23 Enhanced ADO.NET Support... 23 Wizards... 23 Improved Data Flow Lookup Component... 23 Other Improvements... 24 Known Issues... 24 Summary... 25 4 Migrating to Integration Services 2008 27 SSIS Is Not DTS... 28 The Scope of Differences... 28 Good News... 29 Available Migration Resources... 29 Upgrade Advisor... 29 The Execute DTS 2000 Package Task... 32 Migration Wizard... 32 Upgrading SSIS 2005 Packages... 36 Summary... 38 Part II Integration Services Basics 5 The Business Intelligence Development Studio 41 Getting Started... 42 The Start Page and Community Menu... 42 A New Solution... 43 The Integration Services Options... 44 The SSIS Menu... 44 The Toolboxes... 46 The Designers... 48 Visual Studio Standard Options... 68 The Solution Explorer... 69 The Properties Window... 77 Variables Window... 78 The File Menu... 79 Options Dialog Box... 80 Debugging Windows... 81 Diagnostic Windows... 84 Summary... 87 6 The Building Blocks of Integration Services 89 The Components That Compose a Package... 89 The Package and Other Objects... 90 Tasks... 91 Variables... 91 Connection Managers... 92 Log Providers... 92 Containers... 93 Precedence Constraints... 93 The Data Flow Task, Adapters, and Transforms... 93 Data Flow Adapters... 94 Data Flow Transforms... 95 Data Flow Versus Workflow--Fundamental Differences 95 Execution Model... 96 Connecting Lines... 96 Functional Gamut... 97 Summary... 98 7 Grouping Control Flow with Containers 99 The Container Concept... 100 Organizing... 100 Reducing Complexity... 100 Scoping... 101 Transaction Scope... 101 Configuration Scope... 101 LocaleID... 101 Variable Scope... 102 Execution Scope... 102 Connection Scope... 102 Logging Scope... 102 Event Handler Scope... 102 Common Container Properties... 103 Identification... 103 Execution... 103 Forced Execution... 104 Transactions... 105 Properties in the Miscellaneous Category... 106 Designer Groupings--the Noncontainers... 106 The Task and the Taskhost Container... 106 Properties Collection... 106 Persistence... 107 Package Paths and Configurations... 107 Debugging Features... 107 Custom Registration... 107 Contact Information and Graceful Load Failover 108 Isolation... 110 Sensitive Data Protection... 110 The Simple Sequence Container... 111 The Looping Containers... 113 The Package Container... 113 Important Package Properties... 115 Summary... 117 8 Building a Package--Quick Start 119 Quick Start... 119 The Scenario... 119 Configuring the Data Flow... 123 Summary... 134 Part III Control Flow Services 9 The Venerable Variable 137 Important Variable Concepts--Properties, Scope, Type, and Namespace 138 Variable Properties... 138 Variable Scope... 140 Variable Type... 143 Variable Namespaces... 144 System Variables... 146 Creating and Using Variables... 147 Execution Time Behavior... 147 Variable Tips and Tricks... 148 EvaluateAsExpression in SQL Task with Parameters 148 Hiding Parent Variables in Subpackages... 149 Storing Objects in Variables... 149 Summary... 149 10 Using Expressions 151 Expression Basics... 152 Expression Functions... 152 Literals... 153 Casts... 153 Operators... 153 Variables... 153 Columns... 154 Property Expressions... 154 A Simple Example... 154 Data Flow Property Expressions... 158 Adding Data Flow Property Expressions... 159 Variable Expressions... 160 Precedence Constraint Expressions... 161 For Loop Expressions... 162 Expression Evaluator Quick Reference... 163 Math Functions... 164 String Functions... 164 Date/Time Functions... 164 Operators... 165 Type Casts... 165 NULL Functions... 166 Summary... 166 11 The Stock Tasks and Connection Managers 169 Common Task Conventions... 170 Task User Interface... 170 Access Methods... 171 Standard Tabs... 172 Task Groups... 173 The Workflow Tasks... 173 Execute DTS 2000 Package Task... 173 File System Task... 177 Send Mail Task... 179 FTP Task... 181 Message Queue Task... 184 The WMI Tasks... 190 WMI Data Reader Task... 194 WMI Event Watcher Task... 197 Web Services Task... 200 Execute Package Task... 203 Execute Process Task... 207 The Execute SQL Task... 210 The Scripting Tasks... 215 The ActiveX Script Task... 216 The Data-Processing Tasks... 216 Bulk Insert Task... 216 XML Task... 217 The Data Profiling Task... 220 Data Flow Task... 220 Connection Manager Concepts... 220 Connection Managers... 220 Creating Connection Managers... 223 Stock Connection Managers... 224 The ADO Connection Manager... 225 The ADO.NET Connection Manager... 225 The Excel Connection Manager... 228 The File Connection Manager... 229 The Flat File Connection Manager... 231 The FTP Connection Manager... 238 The HTTP Connection Manager... 238 The MSMQ Connection Manager... 240 The Microsoft Analysis Services Connection Manager 241 The MultiFile Connection Manager... 242 The MultiFlatFile Connection Manager... 243 The ODBC Connection Manager... 244 The OLEDB Connection Manager... 247 The SMOServer Connection Manager... 248 The SMTP Connection Manager... 249 The WMI Connection Manager... 249 Data Sources and Data Source Views... 250 Introduction to Data Sources and Data Source Views 250 Summary... 256 12 Using the Script Task 259 The Script Task Environment... 260 The Script Task Editor... 260 Selecting Variables... 261 Using the Script Task... 266 The Dts Object... 266 Suggested Practices... 269 Script Task Samples... 272 Working Against the SSIS Object Model... 272 Downloading a File Using HTTP... 274 Loading the Contents of a Text File into a Variable 275 Simple Custom Logging... 276 Handling Exceptions... 276 Summary... 278 13 Using the Data Profiling Task 279 Setting Up the Data Profiling Task... 280 Setting Up Profile Requests... 280 Specifying the Output File... 281 Selecting the Profile Type... 282 Configuring the Connection Manager... 284 Selecting the Table or View to Profile... 284 Selecting the Column... 284 Configuring the Options... 285 The Quick Profile Option... 285 Analyzing Data with the Data Profile Viewer... 287 Column Statistics Profiles... 287 Column Pattern Profiles... 288 Functional Dependency Profiles... 288 Candidate Key Profiles... 290 Column Length Distribution Profiles... 291 Column Null Ratio Profiles... 291 Column Value Profiles... 292 Value Inclusion Profiles... 292 Summary... 293 14 Logging and the Stock Log Providers 295 Quickstart... 296 Default Logging... 296 Configuring Package Logging... 296 The Stock Log Providers... 300 Windows Event Log Provider... 300 Text File Log Provider... 300 XML Log Provider... 301 SQL Server Log Provider... 302 SQL Profiler Log Provider... 302 Designer Log Events Viewer--The "Virtual Log Provider" 302 Logging Providers and Logging Options... 303 Log Providers... 303 Logging Options... 303 Logging Schema... 304 Log Events... 305 Custom Logging... 309 Using the Script Task and Script Component. 309 Using the SQL Task... 309 Summary... 311 15 Looping and Foreach Enumerators 313 The For Loop... 313 InitExpression... 314 EvalExpression... 314 AssignExpression... 315 The Foreach Loop... 316 Foreach Enumerators... 316 Stock Foreach Enumerators... 319 Foreach File... 319 Foreach Item... 320 Foreach ADO... 323 Foreach ADO.NET Schema Rowset... 325 Foreach From Variable... 328 Foreach NodeList... 329 Foreach SMO... 331 Summary... 333 Part IV Management Services 16 SQL Server Management Studio 337 SQL Server Management Studio Overview... 337 Object Explorer... 338 Connecting to the Integration Services Server... 340 Starting the Integration Services Server... 340 Connecting to a Local Server... 341 Connecting to a Remote SSIS Server... 342 Managing Packages... 342 Running Packages... 342 Stored Packages... 343 Managing DTS 2000 Packages... 346 Server Caching... 347 Using SQL Server Agent to Execute Packages... 348 Summary... 350 17 Using Source Control 351 What Is Source Control?... 352 The Source Repository... 352 Syncing... 352 Checking Out/Checking In... 352 Diffing... 353 Labeling... 353 Branching... 353 Merging... 353 Source Control in the Designer (BIDS)... 353 Setting Up... 354 Using Source Control... 355 Summary... 359 18 Securing Packages 361 Controlling Package Access... 362 Stored in the Integration Services Server... 362 Stored in SQL Server... 364 Identifying Sensitive Data... 366 Protecting Packages and Other Files... 368 The Package Protection Levels... 368 Summary... 373 Part V The Data Flow Task 19 Introducing the Data Flow Task 377 Pipeline Philosophy 101... 378 Low-Cost Additive Transformations... 378 High Performance--No Copying, No Kidding... 378 Data Sandboxing... 378 Extensibility... 379 Data Flow Terms... 379 Data Flow Properties... 381 Expressionable Component Properties... 381 Storage Paths... 384 Buffer Size Properties... 384 Engine Threads... 384 RunInOptimizedMode... 384 Summary... 384 20 The Stock Data Flow Components 385 Common Component Conventions... 386 Custom Component Editors and the Advanced Editor 386 Source Adapters... 393 Enhanced ADO.Net Support... 393 ADO.NET Source... 394 Excel Source and Destination... 397 Flat File Source and Destination... 400 OLE DB Source and Destination... 402 Raw File Source and Destination... 404 XML Source... 405 Flow Control Transforms... 407 Conditional Split... 407 Derived Column... 409 Merge... 412 Merge Join... 414 Multicast... 415 Union All... 416 Lookup... 418 Import Column... 419 Export Column... 422 Auditing Transforms... 424 Audit... 424 Percentage and Row Sampling... 426 RowCount... 427 Data Manipulation Transforms... 429 Aggregate... 429 Character Map... 431 Copy Column... 432 Data Conversion... 432 OLE DB Command... 435 Sort... 436 Destination Adapters... 439 ADO.NET Destination... 439 DataReader Destination... 440 RecordSet Destination... 441 SQL Server Destination... 442 Summary... 444 21 Using the Script Component 445 Introduction to the Script Component... 445 The Script Component Is Performant... 446 Building Proofs of Concept... 446 Accessing Unusual or Unsupported Sources... 446 Creating a Source Adapter... 446 Creating the Component... 447 Creating a Destination Adapter... 451 Creating the Component... 452 Creating a Transformation... 456 Creating the Component... 456 Asynchronous Outputs... 460 Making a Script Output Asynchronous... 460 Summary... 461 22 Advanced Data Flow Transformations 463 The Slowly Changing Dimension Wizard and Transform (SCD) 464 A Typical Slowly Changing Dimension... 464 Additional Slowly Changing Dimension Types. 466 The Slowly Changing Dimension Wizard... 467 The Generated Data Flow... 473 Performance Considerations... 476 Data Cleansing Components... 477 Fuzzy Lookup... 478 The Fuzzy Grouping Transform... 482 Setting Up the Fuzzy Grouping Transform... 483 Text Mining and Document Warehousing Components. 486 The Problem with Text... 486 Term Extraction... 488 The Term Extraction Transformation Editor... 488 The Term Lookup Transform... 489 The Lookup Component... 491 New Features... 492 Setting Up the Lookup Transform... 495 Summary... 498 23 Data Flow Task Internals and Tuning 499 Data Flow Task Under the Hood... 499 General Concepts... 500 Layout Subsystem... 501 Buffers... 501 Buffer Subsystem... 503 Execution Engine... 504 Turnkey Settings for Speedup... 509 Eliminating Unnecessary Work... 509 Optimizing the Data Flow... 511 Insert Performance... 515 An Approach to Data Flow Optimization... 515 The Theory of Constraints... 516 Identifying and Prioritizing Resource Constraints 516 Deciding How to Exploit the Constraint... 520 Subordinating and Synchronizing Everything Else to the Preceding Decisions... 521 Elevating the Bottlenecks... 521 If in Any of the Previous Steps the Constraint Has Shifted, Go Back to Step 1... 522 Summary... 522 Part VI Solving Common Challenges 24 Configuring and Deploying Solutions 525 Package Configurations... 526 How Package Configurations Work... 526 The Package Configurations Organizer... 531 Package Configuration Types... 533 XML Configuration File... 534 Configurations Editor... 536 Environment Variable... 537 Registry Entry... 540 Parent Package Variable... 541 SQL Server Table... 543 Package Configurations Summary... 546 Deploying Packages... 548 The Deployment Utility... 548 Configuration and Deployment Approaches... 552 Location Dependence and Machine-Resident Configurations 553 Database Objects That Move... 553 Overriding Configurations... 554 Configuring Connection Managers... 555 Summary... 556 25 Common Challenges 557 Tips and Tricks... 557 Variables... 558 Designer and DTExec... 558 Configurations... 561 Data Flow Task and Scripting... 563 Data Flow Performance Tips... 564 Tools... 564 Best Practices... 569 General Guidance... 569 Resources... 571 MSDN Forums... 571 SQLIS.COM... 571 Jamie Thomson's Blog... 572 Michael Entin's Blog... 572 Phil Brammer's Blog... 572 Ashvini Sharma's Blog... 572 Codeplex... 572 Summary... 572 Part VII Advanced Package Concepts and Patterns 26 Troubleshooting Packages 575 Avoiding the Fuss... 575 Log Appropriately... 576 Breakpoints... 576 In the Script Component and Task... 576 In the Control Flow... 578 In the Data Flow... 578 Execution Results... 579 Classes of Issues... 581 Security... 581 Configuration and Deployment... 581 Data Flow Truncation or Datatype... 582 Control Flow... 583 Script Task and Component... 584 Isolating the Issue... 585 Simplifying Packages... 585 Refactoring the Package... 586 Control/Child Packages... 586 When All Else Fails... 586 SSIS Forum... 587 Summary... 587 27 Building Advanced Packages 589 Checkpoints and Restartability... 589 Configuring Checkpoints... 592 Loop-Driven Workflow... 595 Expression-Driven Packages... 599 Specifying Foreach Enumerator Settings... 599 Moving and Renaming Files... 600 Summary... 604 Part VIII Programming Integration Services 28 Building Custom Tasks 607 Custom Runtime Components... 607 Requirements for Building Custom Components 608 Deciding to "Roll Your Own"... 610 Starting an SSIS Custom Component Project... 611 Creating the Solution... 611 Adding a Strong Name and Key File... 612 Referencing SSIS and Other Assemblies... 613 Defining the Class... 614 Compiling and Installing... 617 How the Runtime Finds Your Installed Tasks... 620 Developing and Debugging the Task... 621 Giving the Task an Identity... 621 Adding Feature-Specific Properties and Functions 622 Adding SSIS-Specific Properties and Functions 625 Creating Custom Events... 627 Creating Custom Log Events... 627 Errors Are Not Failures... 631 The Execute Method... 632 Building the Task User Interface... 642 Building the Sample TaskUI (Simple)... 642 Building a Sophisticated TaskUI (Complex)... 648 Custom Task Best Practices... 661 Conventions and Constraints... 662 Task UI... 663 General Guidelines... 664 Summary... 664 29 Building Custom Data Flow Components 665 Custom Component Concepts... 665 Design Time... 666 Runtime... 668 The Sample Components... 670 JPG File EXIF Reader Source Adapter... 671 Data Profiler Transform... 672 The SQL Client and ODBC Destination Adapters 672 Sample Transform UI... 672 The Design Time Methods... 673 ProvideComponentProperties... 673 ReinitializeMetaData... 673 Validate... 673 AcquireConnections and ReleaseConnections. 674 RegisterEvents... 674 RegisterLogEntries... 674 PerformUpgrade... 675 The Runtime Methods... 675 PrepareForExecute... 675 PreExecute... 675 PrimeOutput... 675 ProcessInput... 676 PostExecute... 676 Cleanup... 676 Writing a Source Adapter... 676 Setup and the Design Time Methods... 677 Writing a Destination Adapter... 689 The Destination Adapter General Approach... 689 The ReinitializeMetaData Method... 690 The PreExecute Method... 693 The ProcessInput Method... 697 Getting Data from the Input Buffer... 697 Writing a Transform... 698 Types of Transforms... 699 Setting Up the Transform... 699 Performing the Transformation... 702 Summary... 703 TOC, 9780672330322, 1/13/09
.
.
.

O avtorju - Kirk Haselden

Obvestite me o novi knjigi tega avtorja

Želite, da vas po elektronski pošti obvestimo, ko izide nova knjiga ali ponatis katere od knjig tega avtorja?

DA - obveščajte me o novostih avtorja
.
.
.
.

Podrobnosti o izdelku

  • Obseg/št. strani: 792
  • Datum Izida:
  • Jezik: angleški
  • Vezava: Mehka
  • ISBN/EAN: 9780672330322
  • Mere izdelka vxš: 23,2 x 17,8 cm
  • Založba Sams Publishing
  • Avtor:
  • Povprečna ocena:
    Ocena kupcev: 0
    (0)

Mnenja kupcev

  0  ocen:
5 zvezdice
0%
(0)
4 zvezdice
0%
(0)
3 zvezdice
0%
(0)
2 zvezdice
0%
(0)
1 zvezdica
0%
(0)
Povprečna ocena kupcev:
Ocena kupcev: 0
(0 ocen uporabnikov )
.
Ocenite izdelek s klikom na zvezdice:
 
.
.
.
.
.

Oznake kupcev o tem izdelku

Kliknite na posamezno oznako za prikaz vseh izdelkov označenih s to oznako:

Dodaj oznako:

Dodaj
.