LEADER 05136nam 2200745 a 450 001 9910964237503321 005 20240516183939.0 010 $a9786613653628 010 $a9781280676697 010 $a1280676698 010 $a9781849685252 010 $a1849685258 035 $a(CKB)2670000000204377 035 $a(EBL)946951 035 $a(OCoLC)797916818 035 $a(SSID)ssj0000678366 035 $a(PQKBManifestationID)12288386 035 $a(PQKBTitleCode)TC0000678366 035 $a(PQKBWorkID)10698406 035 $a(PQKB)11668773 035 $a(Au-PeEL)EBL946951 035 $a(CaPaEBR)ebr10567592 035 $a(CaONFJC)MIL365362 035 $a(PPN)228030714 035 $a(FR-PaCSA)88850736 035 $a(MiAaPQ)EBC946951 035 $a(FRCYB88850736)88850736 035 $a(DE-B1597)723465 035 $a(DE-B1597)9781849685252 035 $a(EXLCZ)992670000000204377 100 $a20120612d2012 uy 0 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt 182 $cc 183 $acr 200 10$aMicrosoft SQL Server 2012 integration services $ean expert cookbook : over 80 expert recipes to design, create, and deploy SSIS packages /$fReza Rad, Pedro Perfeito ; [foreword by Phil Brammer] 205 $a1st ed. 210 $aOlton, Birmingham [England] $cPackt Pub.$d2012 215 $a1 online resource (564 p.) 225 0 $aQuick answers to common problems 300 $aIncludes index. 311 08$a9781849685245 311 08$a184968524X 327 $aCover; Copyright; Credits; Foreword; About the Authors; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Getting Started with SQL Server Integration Services; Introduction; Import and Export Wizard: First experience with SSIS; Getting started with SSDT; Creating the first SSIS Package; Getting familiar with Data Flow Task; SSIS 2012 versus previous versions in Developer Experience; Chapter 2: Control Flow Tasks; Introduction; Executing T-SQL commands: Execute SQL Task; Handling file and folder operations: File System Task 327 $aSending and receiving files through FTP: FTP TaskExecuting other packages: Execute Package Task; Running external applications: Execute Process Task; Reading data from web methods: Web Service Task; Transforming, validating, and querying XML: XML Task; Profiling table statistics: Data Profiling Task; Batch insertion of data into a database: Bulk Insert Task; Querying system information: WMI Data Reader Task; Querying system events: WMI Event Watcher Task; Transferring SQL server objects: DBMS Tasks; Chapter 3: Data Flow Task Part 1-Extract and Load; Introduction 327 $aWorking with database connections in Data FlowWorking with flat files in Data Flow; Passing data between packages-Raw Source and Destination; Importing XML data with XML Source; Loading data into memory-Recordset Destination; Extracting and loading Excel data; Change Data Capture; Chapter 4: Data Flow Task Part 2-Transformations; Introduction; Derived Column: adding calculated columns; Audit Transformation: logging in Data Flow; Aggregate Transform: aggregating the data stream; Conditional Split: dividing the data stream based on conditions; Lookup Transform: performing the Upsert scenario 327 $aOLE DB Command: executing SQL statements on each row in the data streamMerge and Union All transformations: combining input data rows; Merge Join Transform: performing different types of joins in data flow; Multicast: creating copies of the data stream; Working with BLOB fields: Export Column and Import Column transformations; Slowly Changing Dimensions (SCDs) in SSIS; Chapter 5: Data Flow Task Part 3-Advanced Transformation; Introduction; Pivot and Unpivot Transformations; Text Analysis with Term Lookup and Term Extraction transformations; DQS Cleansing Transformation-Cleansing Data 327 $aFuzzy Transformations-how SSIS understands fuzzy similaritiesChapter 6: Variables, Expressions, and Dynamism in SSIS; Introduction; Variables and data types; Using expressions in Control Flow; Using expressions in Data Flow; The Expression Task; Dynamic connection managers; Dynamic data transfer with different data structures; Chapter 7: Containers and Precedence Constraints; Introduction; Sequence Container: putting all tasks in an executable object; For Loop Container: looping through static enumerator till a condition is met 327 $aForeach Loop Container: looping through result set of a database query 330 $aOver 100 expert recipes to design, create, and deploy SSIS packages with this book and ebook 606 $aMicrosoft software 606 $aData integration (Computer science) 615 0$aMicrosoft software. 615 0$aData integration (Computer science) 676 $a005.7585 700 $aRad$b Reza$0894816 701 $aPerfeito$b Pedro$01795592 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910964237503321 996 $aMicrosoft SQL Server 2012 integration services$94336977 997 $aUNINA