Microsoft SQL Server 2012 integration services : an expert cookbook : over 80 expert recipes to design, create, and deploy SSIS packages / / Reza Rad, Pedro Perfeito ; [foreword by Phil Brammer]

• Autore: Rad Reza
• Pubblicazione: Olton, Birmingham [England], : Packt Pub., 2012
• Edizione: 1st ed.
• Descrizione fisica: 1 online resource (564 p.)
• Disciplina: 005.7585
• Soggetto topico: Microsoft software; Data integration (Computer science)
• Altri autori: PerfeitoPedro
• Note generali: Includes index.
• Nota di contenuto: Cover; 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 ; Sending 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 ; Working 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 ; OLE 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 ; Fuzzy 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 ; Foreach Loop Container: looping through result set of a database query
• Sommario/riassunto: Over 100 expert recipes to design, create, and deploy SSIS packages with this book and ebook
• Titolo autorizzato: Microsoft SQL Server 2012 integration services
• ISBN: 9786613653628; 9781280676697; 1280676698; 9781849685252; 1849685258
• Formato: Materiale a stampa
• Livello bibliografico: Monografia
• Lingua di pubblicazione: Inglese
• Record Nr.: 9910964237503321
• Lo trovi qui: Univ. Federico II