Professional Microsoft SQL Server 2012 Integration Services

• Professional: Microsoft® SQL Server® 2012 Integration Services; Contents; Introduction; Chapter 1: Welcome to SQL Server Integration Services; SQL Server SSIS Historical Overview; What's New in SSIS; Tools of the Trade; Import and Export Wizard; The SQL Server Data Tools Experience; SSIS Architecture; Packages; Control Flow; Data Flow; Variables; Parameters; Error Handling and Logging; Editions of SQL Server; Summary; Chapter 2: The SSIS Tools; Import and Export Wizard; SQL Server Data Tools; Creating Your First Package; The Solution Explorer Window; The Toolbox; The Properties Windows. 
• The SSIS Package DesignerControl Flow; Connection Managers; Variables; Data Flow; Parameters; Event Handlers; Package Explorer; Executing a Package; Management Studio; Summary; Chapter 3: SSIS Tasks; SSIS Task Objects; Using the Task Editor; The Task Editor Expressions Tab; SSDTCommon Properties; Looping and Sequence Tasks; Script Task (.NET); Analysis Services Tasks; Analysis Services Execute DDL Task; Analysis Services Processing Task; Data Mining Query Task; Data Flow Task; Data Preparation Tasks; Data Profiler; File System Task; Archiving a File; FTP Task; Getting a File Using FTP. 
• Web Service TaskRetrieving Data Using the Web Service Task and XML Source Component; XML Task; Validating an XML File; RDBMS Server Tasks; Bulk Insert Task; Using the Bulk Insert Task; Execute SQL Task; Workflow Tasks; Execute Package Task; Execute Process Task; Message Queue Task; Send Mail Task; WMI Data Reader Task; WMI Event Watcher Task; Polling a Directory for the Delivery of a File; SMO Administration Tasks; Transfer Database Task; Transfer Error Messages Task; Transfer Logins Task; Transfer Master Stored Procedures Task; Transfer Jobs Task; Transfer SQL Server Objects Task; Summary. 
• Chapter 4: ContainersTask Host Containers; Sequence Containers; Groups; For Loop Container; Foreach Loop Container; Foreach File Enumerator Example; Foreach ADO Enumerator Example; Summary; Chapter 5: The Data Flow; Understanding the Data Flow; Data Viewers; Sources; OLE DB Source; Excel Source; Flat File Source; Raw File Source; XML Source; ADO.NET Source; Destinations; Excel Destination; Flat File Destination; OLE DB Destination; Raw File Destination; Recordset Destination; SQL Server and Mobile Destinations; Data Mining Model Training; DataReader Destination. 
• Dimension and Partition ProcessingCommon Transformations; Synchronous versus Asynchronous Transformations; Aggregate; Conditional Split; Data Conversion; Derived Column; Lookup; Row Count; Script Component; Slowly Changing Dimension; Sort; Union All; Other Transformations; Audit; Character Map; Copy Column; Data Mining Query; DQS Cleansing; Export Column; Fuzzy Lookup; Fuzzy Grouping; Import Column; Merge; Merge Join; Multicast; OLE DB Command; Percentage and Row Sampling; Pivot Transform; Unpivot; Term Extraction; Term Lookup; Data Flow Example; Summary. 
• Chapter 6: Using Variables, Parameters, and Expressions. 

• An in-depth look at the radical changes to the newest release of SISS Microsoft SQL Server 2012 Integration Services (SISS) builds on the revolutionary database product suite first introduced in 2005. With this crucial resource, you will explore how this newest release serves as a powerful tool for performing extraction, transformation, and load operations (ETL). A team of SQL Server experts deciphers this complex topic and provides detailed coverage of the new features of the 2012 product release. In addition to technical updates and additions, the authors present you with a new set of SISS b

Ämnesord

Client/server computing. 

Database management. 

SQL server. 

Genre

Electronic books.  (LCSH)

Publikations- och innehållstyp

QA76.9.C55 .K378 2012 (LCC)

005.7585 (DDC)

Pubdhz (kssb/8 (machine generated))