{"product_id":"professional-microsoft-sql-server-2014-integration-services-paperback-softback-9781118850879","title":"Professional Microsoft SQL Server 2014 Integration Services (Paperback \/ softback) 9781118850879","description":"\u003cfont face=\"Georgia\"\u003e\r\n\u003cp\u003e\u003cfont size=\"6\"\u003eProfessional Microsoft SQL Server 2014 Integration Services\u003c\/font\u003e\u003cbr\u003e\r\n\r\n\r\n\r\n\r\n\r\n\u003c\/p\u003e\n\u003cp\u003e\u003cfont size=\"4\"\u003eBrian Knight (Author), Devin Knight (Author), Jessica M. Moss (Author), Mike Davis (Author), Chris Rock (Author)\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\u003cp\u003e\u003cfont size=\"3\"\u003e9781118850879, Wiley\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\u003cp\u003e\u003cfont size=\"3\"\u003ePaperback \/ softback, published 6 June 2014\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\u003cp\u003e\u003cfont size=\"3\"\u003e912 pages\u003cbr\u003e23.6 x 18.8 x 5.3 cm, 1.452 kg\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\r\n\r\n\u003cp align=\"justify\"\u003e\u003cem\u003e\u003cfont size=\"3\"\u003e\u003cp\u003e\"This book is suitable for both developers that are new to SSIS development, and experienced developers looking for a more complete understanding. I highly recommend it.\" (\u003cem\u003eI Programmer,\u003c\/em\u003e July 2014)\u003c\/p\u003e\u003c\/font\u003e\u003c\/em\u003e\u003c\/p\u003e\r\n\r\n\u003cp align=\"justify\"\u003e\u003cstrong\u003e\u003cfont size=\"3\"\u003e\u003cb\u003eFill the gap between planning and doing with SSIS 2014\u003c\/b\u003e  \u003cp\u003eThe 2014 release of Microsoft's SQL Server Integration Services provides enhancements for managing extraction, transformation, and load operations, plus expanded in-memory capabilities, improved disaster recovery, increased scalability, and much more. The increased functionality will streamline your ETL processes and smooth out your workflow, but the catch is that your workflow must change. New tools come with new best practices, and \u003ci\u003eProfessional Microsoft SQL Server 2014 Integration Services\u003c\/i\u003e will keep you ahead of the curve. SQL Server MVP Brian Knight is the most respected name in the business, and your ultimate guide to navigating the changes to use Microsoft SQL Server Integration Services 2014 to your utmost advantage.\u003c\/p\u003e \u003cul\u003e \u003cli\u003eImplement new best practices for effective use of SSIS\u003c\/li\u003e \u003cli\u003eWork through tutorials for hands-on learning of complex techniques\u003c\/li\u003e \u003cli\u003eRead case studies that illustrate the more advanced concepts\u003c\/li\u003e \u003cli\u003eLearn directly from the foremost authority on SSIS\u003c\/li\u003e \u003c\/ul\u003e \u003cp\u003eSQL Server Integration Services is a complex tool, but it's the lifeblood of your work. You need to know it inside out, and you must understand the full potential of its capabilities in order to use it effectively. You need to make sure the right architecture is in place. \u003ci\u003eProfessional Microsoft SQL Server 2014 Integration Services\u003c\/i\u003e is your roadmap to understanding SSIS on a fundamental level, and setting yourself up for success.\u003c\/p\u003e\u003c\/font\u003e\u003c\/strong\u003e\u003c\/p\u003e\r\n\r\n\u003cp\u003e\u003cfont size=\"3\"\u003e\u003cp\u003eIntroduction xxvii\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 1: Welcome to SQL Server Integration Services 1\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eSQL Server SSIS Historical Overview 2\u003c\/p\u003e \u003cp\u003eWhat’s New in SSIS 2\u003c\/p\u003e \u003cp\u003eTools of the Trade 3\u003c\/p\u003e \u003cp\u003eImport and Export Wizard 3\u003c\/p\u003e \u003cp\u003eThe SQL Server Data Tools Experience 4\u003c\/p\u003e \u003cp\u003eSSIS Architecture 5\u003c\/p\u003e \u003cp\u003ePackages 5\u003c\/p\u003e \u003cp\u003eControl Flow 5\u003c\/p\u003e \u003cp\u003eData Flow 9\u003c\/p\u003e \u003cp\u003eVariables 14\u003c\/p\u003e \u003cp\u003eParameters 14\u003c\/p\u003e \u003cp\u003eError Handling and Logging 14\u003c\/p\u003e \u003cp\u003eEditions of SQL Server 14\u003c\/p\u003e \u003cp\u003eSummary 15\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 2: The SSIS Tools 17\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eImport and Export Wizard 17\u003c\/p\u003e \u003cp\u003eSQL Server Data Tools 24\u003c\/p\u003e \u003cp\u003eThe Solution Explorer Window 26\u003c\/p\u003e \u003cp\u003eThe SSIS Toolbox 27\u003c\/p\u003e \u003cp\u003eThe Properties Windows 28\u003c\/p\u003e \u003cp\u003eThe SSIS Package Designer 28\u003c\/p\u003e \u003cp\u003eControl Flow 29\u003c\/p\u003e \u003cp\u003eConnection Managers 32\u003c\/p\u003e \u003cp\u003eVariables 33\u003c\/p\u003e \u003cp\u003eData Flow 34\u003c\/p\u003e \u003cp\u003eParameters 35\u003c\/p\u003e \u003cp\u003eEvent Handlers 35\u003c\/p\u003e \u003cp\u003ePackage Explorer 36\u003c\/p\u003e \u003cp\u003eExecuting a Package 37\u003c\/p\u003e \u003cp\u003eManagement Studio 37\u003c\/p\u003e \u003cp\u003eSummary 37\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 3: SSIS Tasks 39\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eSSIS Task Objects 40\u003c\/p\u003e \u003cp\u003eUsing the Task Editor 40\u003c\/p\u003e \u003cp\u003eThe Task Editor Expressions Tab 41\u003c\/p\u003e \u003cp\u003eLooping and Sequence Tasks 41\u003c\/p\u003e \u003cp\u003eScript Task (.NET) 41\u003c\/p\u003e \u003cp\u003eAnalysis Services Tasks 44\u003c\/p\u003e \u003cp\u003eAnalysis Services Execute DDL Task 44\u003c\/p\u003e \u003cp\u003eAnalysis Services Processing Task 44\u003c\/p\u003e \u003cp\u003eData Mining Query Task 46\u003c\/p\u003e \u003cp\u003eData Flow Task 47\u003c\/p\u003e \u003cp\u003eData Preparation Tasks 48\u003c\/p\u003e \u003cp\u003eData Profiler 48\u003c\/p\u003e \u003cp\u003eFile System Task 50\u003c\/p\u003e \u003cp\u003eArchiving a File 52\u003c\/p\u003e \u003cp\u003eFTP Task 53\u003c\/p\u003e \u003cp\u003eGetting a File Using FTP 54\u003c\/p\u003e \u003cp\u003eWeb Service Task 56\u003c\/p\u003e \u003cp\u003eRetrieving Data Using the Web Service Task and XML Source Component 59\u003c\/p\u003e \u003cp\u003eXML Task 62\u003c\/p\u003e \u003cp\u003eValidating an XML File 64\u003c\/p\u003e \u003cp\u003eRDBMS Server Tasks 66\u003c\/p\u003e \u003cp\u003eBulk Insert Task 66\u003c\/p\u003e \u003cp\u003eUsing the Bulk Insert Task 69\u003c\/p\u003e \u003cp\u003eExecute SQL Task 71\u003c\/p\u003e \u003cp\u003eWorkflow Tasks 82\u003c\/p\u003e \u003cp\u003eExecute Package Task 82\u003c\/p\u003e \u003cp\u003eExecute Process Task 84\u003c\/p\u003e \u003cp\u003eMessage Queue Task 86\u003c\/p\u003e \u003cp\u003eSend Mail Task 87\u003c\/p\u003e \u003cp\u003eWMI Data Reader Task 88\u003c\/p\u003e \u003cp\u003eWMI Event Watcher Task 91\u003c\/p\u003e \u003cp\u003ePolling a Directory for the Delivery of a File 91\u003c\/p\u003e \u003cp\u003eSMO Administration Tasks 92\u003c\/p\u003e \u003cp\u003eTransfer Database Task 93\u003c\/p\u003e \u003cp\u003eTransfer Error Messages Task 94\u003c\/p\u003e \u003cp\u003eTransfer Logins Task 94\u003c\/p\u003e \u003cp\u003eTransfer Master Stored Procedures Task 95\u003c\/p\u003e \u003cp\u003eTransfer Jobs Task 96\u003c\/p\u003e \u003cp\u003eTransfer SQL Server Objects Task 96\u003c\/p\u003e \u003cp\u003eSummary 97\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 4: The Data Flow 99\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eUnderstanding the Data Flow 99\u003c\/p\u003e \u003cp\u003eData Viewers 100\u003c\/p\u003e \u003cp\u003eSources 101\u003c\/p\u003e \u003cp\u003eOLE DB Source 102\u003c\/p\u003e \u003cp\u003eExcel Source 104\u003c\/p\u003e \u003cp\u003eFlat File Source 105\u003c\/p\u003e \u003cp\u003eRaw File Source 110\u003c\/p\u003e \u003cp\u003eXML Source 110\u003c\/p\u003e \u003cp\u003eADO.NET Source 111\u003c\/p\u003e \u003cp\u003eDestinations 111\u003c\/p\u003e \u003cp\u003eExcel Destination 112\u003c\/p\u003e \u003cp\u003eFlat File Destination 112\u003c\/p\u003e \u003cp\u003eOLE DB Destination 112\u003c\/p\u003e \u003cp\u003eRaw File Destination 113\u003c\/p\u003e \u003cp\u003eRecordset Destination 114\u003c\/p\u003e \u003cp\u003eData Mining Model Training 114\u003c\/p\u003e \u003cp\u003eDataReader Destination 114\u003c\/p\u003e \u003cp\u003eDimension and Partition Processing 114\u003c\/p\u003e \u003cp\u003eCommon Transformations 115\u003c\/p\u003e \u003cp\u003eSynchronous versus Asynchronous Transformations 115\u003c\/p\u003e \u003cp\u003eAggregate 115\u003c\/p\u003e \u003cp\u003eConditional Split 117\u003c\/p\u003e \u003cp\u003eData Conversion 118\u003c\/p\u003e \u003cp\u003eDerived Column 119\u003c\/p\u003e \u003cp\u003eLookup 121\u003c\/p\u003e \u003cp\u003eRow Count 121\u003c\/p\u003e \u003cp\u003eScript Component 122\u003c\/p\u003e \u003cp\u003eSlowly Changing Dimension 123\u003c\/p\u003e \u003cp\u003eSort 123\u003c\/p\u003e \u003cp\u003eUnion All 125\u003c\/p\u003e \u003cp\u003eOther Transformations 126\u003c\/p\u003e \u003cp\u003eAudit 126\u003c\/p\u003e \u003cp\u003eCharacter Map 128\u003c\/p\u003e \u003cp\u003eCopy Column 128\u003c\/p\u003e \u003cp\u003eData Mining Query 129\u003c\/p\u003e \u003cp\u003eDQS Cleansing 130\u003c\/p\u003e \u003cp\u003eExport Column 130\u003c\/p\u003e \u003cp\u003eFuzzy Lookup 132\u003c\/p\u003e \u003cp\u003eFuzzy Grouping 139\u003c\/p\u003e \u003cp\u003eImport Column 143\u003c\/p\u003e \u003cp\u003eMerge 145\u003c\/p\u003e \u003cp\u003eMerge Join 146\u003c\/p\u003e \u003cp\u003eMulticast 146\u003c\/p\u003e \u003cp\u003eOLE DB Command 147\u003c\/p\u003e \u003cp\u003ePercentage and Row Sampling 148\u003c\/p\u003e \u003cp\u003ePivot Transform 149\u003c\/p\u003e \u003cp\u003eUnpivot 152\u003c\/p\u003e \u003cp\u003eTerm Extraction 154\u003c\/p\u003e \u003cp\u003eTerm Lookup 158\u003c\/p\u003e \u003cp\u003eData Flow Example 160\u003c\/p\u003e \u003cp\u003eSummary 164\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 5: Using Variables, Parameters, and Expressions 165\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eDynamic Package Objects 166\u003c\/p\u003e \u003cp\u003eVariable Overview 166\u003c\/p\u003e \u003cp\u003eParameter Overview 166\u003c\/p\u003e \u003cp\u003eExpression Overview 167\u003c\/p\u003e \u003cp\u003eUnderstanding Data Types 168\u003c\/p\u003e \u003cp\u003eSSIS Data Types 168\u003c\/p\u003e \u003cp\u003eDate and Time Type Support 170\u003c\/p\u003e \u003cp\u003eHow Wrong Data Types and Sizes Can Affect Performance 171\u003c\/p\u003e \u003cp\u003eUnicode and Non-Unicode Conversion Issues 171\u003c\/p\u003e \u003cp\u003eCasting in SSIS Expressions 173\u003c\/p\u003e \u003cp\u003eUsing Variables and Parameters 174\u003c\/p\u003e \u003cp\u003eDefining Variables 174\u003c\/p\u003e \u003cp\u003eDefining Parameters 175\u003c\/p\u003e \u003cp\u003eVariable and Parameter Data Types 176\u003c\/p\u003e \u003cp\u003eWorking with Expressions 177\u003c\/p\u003e \u003cp\u003eC#-Like? Close, but Not Completely 178\u003c\/p\u003e \u003cp\u003eThe Expression Builder 179\u003c\/p\u003e \u003cp\u003eSyntax Basics 180\u003c\/p\u003e \u003cp\u003eUsing Expressions in SSIS Packages 194\u003c\/p\u003e \u003cp\u003eSummary 204\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 6: Containers 205\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eTask Host Containers 205\u003c\/p\u003e \u003cp\u003eSequence Containers 206\u003c\/p\u003e \u003cp\u003eGroups 207\u003c\/p\u003e \u003cp\u003eFor Loop Container 207\u003c\/p\u003e \u003cp\u003eForeach Loop Container 210\u003c\/p\u003e \u003cp\u003eForeach File Enumerator Example 211\u003c\/p\u003e \u003cp\u003eForeach ADO Enumerator Example 213\u003c\/p\u003e \u003cp\u003eSummary 218\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 7: Joining Data 219\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eThe Lookup Transformation 220\u003c\/p\u003e \u003cp\u003eUsing the Merge Join Transformation 221\u003c\/p\u003e \u003cp\u003eContrasting SSIS and the Relational Join 222\u003c\/p\u003e \u003cp\u003eLookup Features 224\u003c\/p\u003e \u003cp\u003eBuilding the Basic Package 225\u003c\/p\u003e \u003cp\u003eUsing a Relational Join in the Source 227\u003c\/p\u003e \u003cp\u003eUsing the Merge Join Transformation 230\u003c\/p\u003e \u003cp\u003eUsing the Lookup Transformation 235\u003c\/p\u003e \u003cp\u003eFull-Cache Mode 235\u003c\/p\u003e \u003cp\u003eNo-Cache Mode 239\u003c\/p\u003e \u003cp\u003ePartial-Cache Mode 240\u003c\/p\u003e \u003cp\u003eMultiple Outputs 243\u003c\/p\u003e \u003cp\u003eExpressionable Properties 246\u003c\/p\u003e \u003cp\u003eCascaded Lookup Operations 247\u003c\/p\u003e \u003cp\u003eCache Connection Manager and Cache Transform 249\u003c\/p\u003e \u003cp\u003eSummary 252\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 8: Creating an End-to-End Package 253\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eBasic Transformation Tutorial 253\u003c\/p\u003e \u003cp\u003eCreating Connections 254\u003c\/p\u003e \u003cp\u003eCreating the Control Flow 257\u003c\/p\u003e \u003cp\u003eCreating the Data Flow 257\u003c\/p\u003e \u003cp\u003eCompleting the Package 259\u003c\/p\u003e \u003cp\u003eSaving the Package 260\u003c\/p\u003e \u003cp\u003eExecuting the Package 260\u003c\/p\u003e \u003cp\u003eTypical Mainframe ETL with Data Scrubbing 261\u003c\/p\u003e \u003cp\u003eCreating the Data Flow 263\u003c\/p\u003e \u003cp\u003eHandling Dirty Data 263\u003c\/p\u003e \u003cp\u003eFinalizing 268\u003c\/p\u003e \u003cp\u003eHandling More Bad Data 269\u003c\/p\u003e \u003cp\u003eLooping and the Dynamic Tasks 271\u003c\/p\u003e \u003cp\u003eLooping 271\u003c\/p\u003e \u003cp\u003eMaking the Package Dynamic 272\u003c\/p\u003e \u003cp\u003eSummary 274\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 9: Scripting in SSIS 275\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eIntroducing SSIS Scripting 276\u003c\/p\u003e \u003cp\u003eGetting Started in SSIS Scripting 277\u003c\/p\u003e \u003cp\u003eSelecting the Scripting Language 277\u003c\/p\u003e \u003cp\u003eUsing the VSTA Scripting IDE 278\u003c\/p\u003e \u003cp\u003eExample: Hello World 279\u003c\/p\u003e \u003cp\u003eAdding Code and Classes 281\u003c\/p\u003e \u003cp\u003eUsing Managed Assemblies 282\u003c\/p\u003e \u003cp\u003eExample: Using Custom .NET Assemblies 283\u003c\/p\u003e \u003cp\u003eUsing the Script Task 286\u003c\/p\u003e \u003cp\u003eConfiguring the Script Task Editor 287\u003c\/p\u003e \u003cp\u003eThe Script Task Dts Object 288\u003c\/p\u003e \u003cp\u003eAccessing Variables in the Script Task 289\u003c\/p\u003e \u003cp\u003eConnecting to Data Sources in a Script Task 293\u003c\/p\u003e \u003cp\u003eRaising an Event in a Script Task 303\u003c\/p\u003e \u003cp\u003eWriting a Log Entry in a Script Task 309\u003c\/p\u003e \u003cp\u003eUsing the Script Component 310\u003c\/p\u003e \u003cp\u003eDifferences from a Script Task 310\u003c\/p\u003e \u003cp\u003eConfiguring the Script Component Editor 311\u003c\/p\u003e \u003cp\u003eAccessing Variables in a Script Component 313\u003c\/p\u003e \u003cp\u003eConnecting to Data Sources in a Script Component 314\u003c\/p\u003e \u003cp\u003eRaising Events 314\u003c\/p\u003e \u003cp\u003eLogging 315\u003c\/p\u003e \u003cp\u003eExample: Data Validation 316\u003c\/p\u003e \u003cp\u003eSynchronous versus Asynchronous 324\u003c\/p\u003e \u003cp\u003eEssential Coding, Debugging, and Troubleshooting Techniques 327\u003c\/p\u003e \u003cp\u003eStructured Exception Handling 327\u003c\/p\u003e \u003cp\u003eScript Debugging and Troubleshooting 330\u003c\/p\u003e \u003cp\u003eSummary 333\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 10: Advanced Data Cleansing in SSIS 335\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eAdvanced Derived Column Use 336\u003c\/p\u003e \u003cp\u003eText Parsing Example 338\u003c\/p\u003e \u003cp\u003eAdvanced Fuzzy Lookup and Fuzzy Grouping 340\u003c\/p\u003e \u003cp\u003eFuzzy Lookup 340\u003c\/p\u003e \u003cp\u003eFuzzy Grouping 347\u003c\/p\u003e \u003cp\u003eDQS Cleansing 350\u003c\/p\u003e \u003cp\u003eData Quality Services 351\u003c\/p\u003e \u003cp\u003eDQS Cleansing Transformation 355\u003c\/p\u003e \u003cp\u003eMaster Data Management 358\u003c\/p\u003e \u003cp\u003eMaster Data Services 359\u003c\/p\u003e \u003cp\u003eSummary 362\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 11: Incremental Loads in SSIS 363\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eControl Table Pattern 363\u003c\/p\u003e \u003cp\u003eQuerying the Control Table 364\u003c\/p\u003e \u003cp\u003eQuerying the Source Table 366\u003c\/p\u003e \u003cp\u003eUpdating the Control Table 366\u003c\/p\u003e \u003cp\u003eSQL Server Change Data Capture 367\u003c\/p\u003e \u003cp\u003eBenefits of SQL Server CDC 368\u003c\/p\u003e \u003cp\u003ePreparing CDC 369\u003c\/p\u003e \u003cp\u003eCapture Instance Tables 371\u003c\/p\u003e \u003cp\u003eThe CDC API 372\u003c\/p\u003e \u003cp\u003eUsing the SSIS CDC Tools 374\u003c\/p\u003e \u003cp\u003eSummary 379\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 12: Loading a Data Warehouse 381\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eData Profiling 383\u003c\/p\u003e \u003cp\u003eInitial Execution of the Data Profiling Task 383\u003c\/p\u003e \u003cp\u003eReviewing the Results of the Data Profiling Task 386\u003c\/p\u003e \u003cp\u003eTurning Data Profile Results into Actionable ETL Steps 390\u003c\/p\u003e \u003cp\u003eData Extraction and Cleansing 391\u003c\/p\u003e \u003cp\u003eDimension Table Loading 391\u003c\/p\u003e \u003cp\u003eLoading a Simple Dimension Table 392\u003c\/p\u003e \u003cp\u003eLoading a Complex Dimension Table 397\u003c\/p\u003e \u003cp\u003eConsiderations and Alternatives to the SCD Transformation 408\u003c\/p\u003e \u003cp\u003eFact Table Loading 409\u003c\/p\u003e \u003cp\u003eSSAS Processing 421\u003c\/p\u003e \u003cp\u003eUsing a Master ETL Package 426\u003c\/p\u003e \u003cp\u003eSummary 428\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 13: Using the Relational Engine 429\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eData Extraction 430\u003c\/p\u003e \u003cp\u003eSELECT * is Bad 430\u003c\/p\u003e \u003cp\u003eWHERE is Your Friend 432\u003c\/p\u003e \u003cp\u003eTransform during Extract 433\u003c\/p\u003e \u003cp\u003eMany ANDs Make Light Work 437\u003c\/p\u003e \u003cp\u003eSORT in the Database 437\u003c\/p\u003e \u003cp\u003eModularize 439\u003c\/p\u003e \u003cp\u003eSQL Server Does Text Files Too 440\u003c\/p\u003e \u003cp\u003eUsing Set-Based Logic 444\u003c\/p\u003e \u003cp\u003eData Loading 446\u003c\/p\u003e \u003cp\u003eDatabase Snapshots 446\u003c\/p\u003e \u003cp\u003eThe MERGE Operator 448\u003c\/p\u003e \u003cp\u003eSummary 452\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 14: Accessing Heterogeneous Data 453\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eExcel and Access 455\u003c\/p\u003e \u003cp\u003e64-Bit Support 455\u003c\/p\u003e \u003cp\u003eWorking with Excel Files 457\u003c\/p\u003e \u003cp\u003eWorking with Access 462\u003c\/p\u003e \u003cp\u003eImporting from Oracle 469\u003c\/p\u003e \u003cp\u003eOracle Client Setup 469\u003c\/p\u003e \u003cp\u003eImporting Oracle Data 470\u003c\/p\u003e \u003cp\u003eUsing XML and Web Services 472\u003c\/p\u003e \u003cp\u003eConfiguring the Web Service Task 472\u003c\/p\u003e \u003cp\u003eWorking with XML Data as a Source 483\u003c\/p\u003e \u003cp\u003eFlat Files 486\u003c\/p\u003e \u003cp\u003eLoading Flat Files 487\u003c\/p\u003e \u003cp\u003eExtracting Data from Flat Files 489\u003c\/p\u003e \u003cp\u003eODBC 491\u003c\/p\u003e \u003cp\u003eOther Heterogeneous Sources 494\u003c\/p\u003e \u003cp\u003eSummary 495\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 15: Reliability and Scalability 497\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eRestarting Packages 498\u003c\/p\u003e \u003cp\u003eSimple Control Flow 499\u003c\/p\u003e \u003cp\u003eContainers within Containers and Checkpoints 501\u003c\/p\u003e \u003cp\u003eVariations on a Theme 503\u003c\/p\u003e \u003cp\u003eInside the Checkpoint File 505\u003c\/p\u003e \u003cp\u003ePackage Transactions 507\u003c\/p\u003e \u003cp\u003eSingle Package, Single Transaction 508\u003c\/p\u003e \u003cp\u003eSingle Package, Multiple Transactions 509\u003c\/p\u003e \u003cp\u003eTwo Packages, One Transaction 511\u003c\/p\u003e \u003cp\u003eSingle Package Using a Native Transaction in SQL Server 512\u003c\/p\u003e \u003cp\u003eError Outputs 513\u003c\/p\u003e \u003cp\u003eScaling Out 516\u003c\/p\u003e \u003cp\u003eArchitectural Features 516\u003c\/p\u003e \u003cp\u003eScaling Out Memory Pressures 517\u003c\/p\u003e \u003cp\u003eScaling Out by Staging Data 517\u003c\/p\u003e \u003cp\u003eScaling Out with Parallel Loading 522\u003c\/p\u003e \u003cp\u003eSummary 528\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 16: Understanding and Tuning the Data Flow Engine 529\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eThe SSIS Engine 530\u003c\/p\u003e \u003cp\u003eUnderstanding the SSIS Data Flow and Control Flow 530\u003c\/p\u003e \u003cp\u003eHandling Workflows with the Control Flow 533\u003c\/p\u003e \u003cp\u003eData Processing in the Data Flow 533\u003c\/p\u003e \u003cp\u003eMemory Buffer Architecture 534\u003c\/p\u003e \u003cp\u003eTypes of Transformations 534\u003c\/p\u003e \u003cp\u003eAdvanced Data Flow Execution Concepts 543\u003c\/p\u003e \u003cp\u003eSSIS Data Flow Design and Tuning 549\u003c\/p\u003e \u003cp\u003eData Flow Design Practices 550\u003c\/p\u003e \u003cp\u003eOptimizing Package Processing 555\u003c\/p\u003e \u003cp\u003eTroubleshooting Data Flow Performance Bottlenecks 558\u003c\/p\u003e \u003cp\u003ePipeline Performance Monitoring 559\u003c\/p\u003e \u003cp\u003eSummary 562\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 17: SS IS Software Development Life Cycle 563\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eIntroduction to Software Development Life Cycles 565\u003c\/p\u003e \u003cp\u003eSDLCs: A Brief History 566\u003c\/p\u003e \u003cp\u003eTypes of Software Development Life Cycles 566\u003c\/p\u003e \u003cp\u003eVersioning and Source Code Control 567\u003c\/p\u003e \u003cp\u003eSubversion (SVN) 568\u003c\/p\u003e \u003cp\u003eTeam Foundation Server, Team System, and SSIS 573\u003c\/p\u003e \u003cp\u003eSummary 590\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 18: Error and Event Handling 591\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eUsing Precedence Constraints 592\u003c\/p\u003e \u003cp\u003ePrecedence Constraint Basics 592\u003c\/p\u003e \u003cp\u003eAdvanced Precedence Constraints and Expressions 593\u003c\/p\u003e \u003cp\u003eEvent Handling 601\u003c\/p\u003e \u003cp\u003eEvents 602\u003c\/p\u003e \u003cp\u003eUsing Event Handlers 603\u003c\/p\u003e \u003cp\u003eEvent Handler Inheritance 611\u003c\/p\u003e \u003cp\u003eBreakpoints 612\u003c\/p\u003e \u003cp\u003eError Rows 616\u003c\/p\u003e \u003cp\u003eLogging 622\u003c\/p\u003e \u003cp\u003eLogging Providers 622\u003c\/p\u003e \u003cp\u003eLog Events 623\u003c\/p\u003e \u003cp\u003eCatalog Logging 627\u003c\/p\u003e \u003cp\u003eSummary 629\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 19: Programming and Extending SSIS 631\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eThe Sample Components 632\u003c\/p\u003e \u003cp\u003eComponent 1: Source Adapter 632\u003c\/p\u003e \u003cp\u003eComponent 2: Transform 633\u003c\/p\u003e \u003cp\u003eComponent 3: Destination Adapter 634\u003c\/p\u003e \u003cp\u003eThe Pipeline Component Methods 634\u003c\/p\u003e \u003cp\u003eDesign-Time Functionality 635\u003c\/p\u003e \u003cp\u003eRuntime 639\u003c\/p\u003e \u003cp\u003eConnection Time 640\u003c\/p\u003e \u003cp\u003eBuilding the Components 642\u003c\/p\u003e \u003cp\u003ePreparation 642\u003c\/p\u003e \u003cp\u003eBuilding the Source Component 648\u003c\/p\u003e \u003cp\u003eBuilding the Transformation Component 660\u003c\/p\u003e \u003cp\u003eBuilding the Destination Adapter 671\u003c\/p\u003e \u003cp\u003eUsing the Components 679\u003c\/p\u003e \u003cp\u003eInstalling the Components 679\u003c\/p\u003e \u003cp\u003eDebugging Components 680\u003c\/p\u003e \u003cp\u003eDesign Time 680\u003c\/p\u003e \u003cp\u003eBuilding the Complete Package 682\u003c\/p\u003e \u003cp\u003eRuntime Debugging 682\u003c\/p\u003e \u003cp\u003eUpgrading to SQL Server 2014 687\u003c\/p\u003e \u003cp\u003eSummary 687\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 20: Adding a User Interface to Your Component 689\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eThree Key Steps for Designing the UI: An Overview 690\u003c\/p\u003e \u003cp\u003eBuilding the User Interface 690\u003c\/p\u003e \u003cp\u003eAdding the Project 691\u003c\/p\u003e \u003cp\u003eImplementing IDtsComponentUI 693\u003c\/p\u003e \u003cp\u003eSetting the UITypeName 697\u003c\/p\u003e \u003cp\u003eBuilding the Form 699\u003c\/p\u003e \u003cp\u003eExtending the User Interface 704\u003c\/p\u003e \u003cp\u003eRuntime Connections 704\u003c\/p\u003e \u003cp\u003eComponent Properties 707\u003c\/p\u003e \u003cp\u003eHandling Errors and Warnings 708\u003c\/p\u003e \u003cp\u003eColumn Properties 711\u003c\/p\u003e \u003cp\u003eOther UI Considerations 712\u003c\/p\u003e \u003cp\u003eSummary 712\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 21: External Management and WMI Task Implementation 715\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eExternal Management of SSIS with Managed Code 716\u003c\/p\u003e \u003cp\u003eSetting Up a Test SSIS Package for Demonstration Purposes 716\u003c\/p\u003e \u003cp\u003eThe Managed Object Model Code Library 717\u003c\/p\u003e \u003cp\u003eCatalog Management 718\u003c\/p\u003e \u003cp\u003eFolder Management 719\u003c\/p\u003e \u003cp\u003eEnvironments 720\u003c\/p\u003e \u003cp\u003eThe DTS Runtime Managed Code Library 722\u003c\/p\u003e \u003cp\u003eSSIS Deployment Projects 722\u003c\/p\u003e \u003cp\u003eParameter Objects 723\u003c\/p\u003e \u003cp\u003eServer Deployment 725\u003c\/p\u003e \u003cp\u003eExecuting SSIS Packages Deployed to the SSIS Catalog 726\u003c\/p\u003e \u003cp\u003eEnvironment References 727\u003c\/p\u003e \u003cp\u003ePackage Operations 728\u003c\/p\u003e \u003cp\u003eApplication Object Maintenance Operations 729\u003c\/p\u003e \u003cp\u003ePackage Operations 729\u003c\/p\u003e \u003cp\u003ePackage Monitoring 732\u003c\/p\u003e \u003cp\u003eProject, Folder, and Package Listing 734\u003c\/p\u003e \u003cp\u003eA Package Management Example 735\u003c\/p\u003e \u003cp\u003ePackage Log Providers 745\u003c\/p\u003e \u003cp\u003eSpecifying Events to Log 747\u003c\/p\u003e \u003cp\u003eProgramming to Log Providers 748\u003c\/p\u003e \u003cp\u003eSQL Server 2014 Operation Logs 749\u003c\/p\u003e \u003cp\u003ePackage Configurations 751\u003c\/p\u003e \u003cp\u003eCreating a Configuration 752\u003c\/p\u003e \u003cp\u003eProgramming the Configuration Object 753\u003c\/p\u003e \u003cp\u003eConfiguration Object 754\u003c\/p\u003e \u003cp\u003eWindows Management Instrumentation Tasks 755\u003c\/p\u003e \u003cp\u003eWMI Reader Task Explained 755\u003c\/p\u003e \u003cp\u003eWMI Data Reader Example 756\u003c\/p\u003e \u003cp\u003eWMI Event Watcher Task 762\u003c\/p\u003e \u003cp\u003eWMI Event Watcher Task Example 763\u003c\/p\u003e \u003cp\u003eSummary 766\u003c\/p\u003e \u003cp\u003e\u003cb\u003eChapter 22: Ad ministering SSIS 767\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eUsing the SSIS Catalog 768\u003c\/p\u003e \u003cp\u003eSetting the SSIS Catalog Properties 768\u003c\/p\u003e \u003cp\u003eSSISDB 771\u003c\/p\u003e \u003cp\u003eDeployment Models 772\u003c\/p\u003e \u003cp\u003eProject Deployment Model 773\u003c\/p\u003e \u003cp\u003ePackage Deployment Model 775\u003c\/p\u003e \u003cp\u003eUsing T-SQL with SSIS 781\u003c\/p\u003e \u003cp\u003eExecuting Packages 781\u003c\/p\u003e \u003cp\u003eUsing Parameters 782\u003c\/p\u003e \u003cp\u003eQuerying Tables for Parameter Values 783\u003c\/p\u003e \u003cp\u003eUsing Environments 784\u003c\/p\u003e \u003cp\u003eUsing Data Taps 789\u003c\/p\u003e \u003cp\u003eCreating a Central SSIS Server 790\u003c\/p\u003e \u003cp\u003eClustering SSIS 792\u003c\/p\u003e \u003cp\u003ePackage Configuration 794\u003c\/p\u003e \u003cp\u003eCommand-Line Utilities 798\u003c\/p\u003e \u003cp\u003eDTExec 798\u003c\/p\u003e \u003cp\u003eDTExecUI 799\u003c\/p\u003e \u003cp\u003eDTUtil 804\u003c\/p\u003e \u003cp\u003eSecurity 806\u003c\/p\u003e \u003cp\u003eSecuring the SSIS Catalog 806\u003c\/p\u003e \u003cp\u003eLegacy Security 809\u003c\/p\u003e \u003cp\u003eScheduling Packages 811\u003c\/p\u003e \u003cp\u003eSQL Server Agent 811\u003c\/p\u003e \u003cp\u003eProxy Accounts 813\u003c\/p\u003e \u003cp\u003e64-Bit Issues 814\u003c\/p\u003e \u003cp\u003eMonitoring Package Executions 815\u003c\/p\u003e \u003cp\u003eBuilt-in Reporting 815\u003c\/p\u003e \u003cp\u003eCustom Reporting 819\u003c\/p\u003e \u003cp\u003ePerformance Counters 819\u003c\/p\u003e \u003cp\u003eSummary 820\u003c\/p\u003e \u003cp\u003e\u003cb\u003eAppendix A: SS IS Crib Notes 821\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eWhen to Use Control Flow Tasks 821\u003c\/p\u003e \u003cp\u003eWhen to Use Data Flow Transforms 822\u003c\/p\u003e \u003cp\u003eCommon Expressions and Scripts 824\u003c\/p\u003e \u003cp\u003e\u003cb\u003eAppendix B: SS IS Internal Views and Stored Procedures 829\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eViews 829\u003c\/p\u003e \u003cp\u003eStored Procedures 830\u003c\/p\u003e \u003cp\u003e\u003cb\u003eAppendix C: Interviewing for an ETL Developer Position 833\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eQuestions 833\u003c\/p\u003e \u003cp\u003eAnswers 834\u003c\/p\u003e \u003cp\u003eIndex 839\u003c\/p\u003e\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\u003cp\u003e\u003cfont size=\"3\"\u003eSubject Areas: Computer networking \u0026amp; communications [\u003ca title=\"See our other books on Computer networking \u0026amp; communications\" href=\"https:\/\/freshlyprintedbooks.co.uk\/search?q=%22Computer%20networking%20\u0026amp;%20communications%20%5BUT%5D%22\"\u003eUT\u003c\/a\u003e]\u003c\/font\u003e\u003c\/p\u003e\r\n\r\n\r\n\u003c\/font\u003e","brand":"Wrox","offers":[{"title":"Brand New","offer_id":52470039478552,"sku":"9781118850879","price":31.97,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0730\/2037\/5320\/files\/9781118850879.jpg?v=1785629334","url":"https:\/\/freshlyprintedbooks.co.uk\/products\/professional-microsoft-sql-server-2014-integration-services-paperback-softback-9781118850879","provider":"Freshly Printed Books","version":"1.0","type":"link"}