Professional Microsoft SQL Server 2012 Integration Services

ISBN-10: 111810112X
ISBN-13: 9781118101124
Edition: 2012
Buy it from $36.64
This item qualifies for FREE shipping

*A minimum purchase of $35 is required. Shipping is provided via FedEx SmartPost® and FedEx Express Saver®. Average delivery time is 1 – 5 business days, but is not guaranteed in that timeframe. Also allow 1 - 2 days for processing. Free shipping is eligible only in the continental United States and excludes Hawaii, Alaska and Puerto Rico. FedEx service marks used by permission."Marketplace" orders are not eligible for free or discounted shipping.

30 day, 100% satisfaction guarantee

If an item you ordered from TextbookRush does not meet your expectations due to an error on our part, simply fill out a return request and then return it by mail within 30 days of ordering it for a full refund of item cost.

Learn more about our returns policy

Description: Professional Microsoft SQL Server 2011 Integration Services An in-depth look at the radical changes to the newest release of SISS Microsoft SQL Server 2011 Integration Services (SISS) builds on the revolutionary database product suite first  More...

New Starting from $36.64
what's this?
Rush Rewards U
Members Receive:
coins
coins
You have reached 400 XP and carrot coins. That is the daily max!
You could win $10,000

Get an entry for every item you buy, rent, or sell.

Study Briefs

Limited time offer: Get the first one free! (?)

All the information you need in one place! Each Study Brief is a summary of one specific subject; facts, figures, and explanations to help you learn faster.

Add to cart
Study Briefs
Calculus 1 Online content $4.95 $1.99
Add to cart
Study Briefs
Algebra Online content $4.95 $1.99
Add to cart
Study Briefs
Introduction to Logic Online content $4.95 $1.99
Add to cart
Study Briefs
Business Math Formulas Online content $4.95 $1.99

Customers also bought

Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading

Book details

Copyright year: 2012
Publisher: John Wiley & Sons, Limited
Publication date: 3/23/2012
Binding: Paperback
Pages: 960
Size: 7.50" wide x 9.25" long x 2.00" tall
Weight: 3.608
Language: English

Professional Microsoft SQL Server 2011 Integration Services An in-depth look at the radical changes to the newest release of SISS Microsoft SQL Server 2011 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 2011 product release. In addition to technical updates and additions, the authors present you with a new set of SISS best practices, based on years of real-world experience that have transpired since the previous edition was published. Details the newest features of the 2011 SISS product release, which is the most significant release since 2005 Addresses the keys to a successful ETL solution, such as using the right enterprise ETL tool and employing the right ETL architecture in order to meet the system requirements Includes additional case studies and tutorial examples to illustrate advanced concepts and techniques Professional Microsoft SQL Server 2011 Integration Services is a valuable resource that meets the demands and high expectations of experienced SSIS professionals

Chris Rock was born on February 7, 1966 in South Carolina, but grew up in Brooklyn, N.Y. Rock was involved in the New York comedy club circuit, which led to a spot on the Uptown Comedy Express and roles in several of Eddie Murphy's movies including Beverly Hills Cop II, Dr. Dolittle, and a featured role in Lethal Weapon 4. Rock was a regular on Saturday Night Live and on In Living Color. Rock co-wrote and produced the film CB4 and later created his own cable TV show, The Chris Rock Show and a comedy special, Chris Rock: Bring the Pain, which won two Emmys. He also wrote the book, Rock This, a comedic look of American society.

Introduction
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
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 Designer
Control Flow
Connection Managers
Variables
Data Flow
Parameters
Event Handlers
Package Explorer
Executing a Package
Management Studio
Summary
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 Profi ler
File System Task
Archiving a File
FTP Task
Getting a File Using FTP
Web Service Task
Retrieving 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
Workfl ow 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
Containers
Task Host Containers
Sequence Containers
Groups
For Loop Container
Foreach Loop Container
Foreach File Enumerator Example
Foreach ADO Enumerator Example
Summary
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 Processing
Common 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
Using Variables, Parameters, And Expressions
Dynamic Package Objects
Variable Overview
Parameter Overview
Expression Overview
Understanding Data Types
SSIS Data Types
Date and Time Type Support
How Wrong Data Types and Sizes Can Affect Performance
Unicode and Non-Unicode Conversion Issues
Casting in SSIS Expressions
Using Variables and Parameters
Defi ning Variables
Defining Parameters
Variable and Parameter Data Types
Working with Expressions
C#-Like? Close, but Not Completely
The Expression Builder
Syntax Basics
Using Expressions in SSIS Packages
Summary
Joining Data
The Lookup Transformation
Using the Merge Join Transformation
Contrasting SSIS and the Relational Join
Lookup Features
Building the Basic Package
Using a Relational Join in the Source
Using the Merge Join Transformation
Using the Lookup Transformation
Full-Cache Mode
No-Cache Mode
Partial-Cache Mode
Multiple Outputs
Expressionable Properties
Cascaded Lookup Operations
Cache Connection Manager and Cache Transform
Summary
Creating An End-To-End Package
Basic Transformation Tutorial
Creating Connections
Creating the Control Flow
Creating the Data Flow
Completing the Package
Saving the Package
Executing the Package
Typical Mainframe ETL with Data Scrubbing
Creating the Data Flow
Handling Dirty Data
Finalizing
Handling More Bad Data
Looping and the Dynamic Tasks
Looping
Making the Package Dynamic
Summary
Scripting In Ssis
Introducing SSIS Scripting
Getting Started in SSIS Scripting
Selecting the Scripting Language
Using the VSTA Scripting IDE
Example: Hello World
Adding Code and Classes
Using Managed Assemblies
Example: Using Custom .NET Assemblies
Using the Script Task
Confi guring the Script Task Editor
The Script Task Dts Object
Accessing Variables in the Script Task
Connecting to Data Sources in a Script Task
Raising an Event in a Script Task
Writing a Log Entry in a Script Task
Using the Script Component
Diff erences from a Script Task
Confi guring the Script Component Editor
Accessing Variables in a Script Component
Connecting to Data Sources in a Script Component
Raising Events
Logging
Example: Data Validation
Synchronous versus Asynchronous
Essential Coding, Debugging, and Troubleshooting Techniques
Structured Exception Handling
Script Debugging and Troubleshooting
Summary
Loading A Data Warehouse
Data Profiling
Initial Execution of the Data Profiling Task
Reviewing the Results of the Data Profiling Task
Turning Data Profi le Results into Actionable ETL Steps
Data Extraction and Cleansing
Dimension Table Loading
Loading a Simple Dimension Table
Loading a Complex Dimension Table
Considerations and Alternatives to the SCD Transformation
Fact Table Loading
SSAS Processing
Using a Master ETL Package
Summary
Advanced Data Cleansing In Ssis
Advanced Derived Column Use
Text Parsing Example
Advanced Fuzzy Lookup and Fuzzy Grouping
Fuzzy Lookup
Fuzzy Grouping
DQS Cleansing
Data Quality Services
DQS Cleansing Transformation
Summary
Using The Relational Engine
Data Extraction
SELECT * Is Bad
WHERE Is Your Friend
Transform during Extract
Many ANDs Make Light Work

×
Free shipping on orders over $35*

*A minimum purchase of $35 is required. Shipping is provided via FedEx SmartPost® and FedEx Express Saver®. Average delivery time is 1 – 5 business days, but is not guaranteed in that timeframe. Also allow 1 - 2 days for processing. Free shipping is eligible only in the continental United States and excludes Hawaii, Alaska and Puerto Rico. FedEx service marks used by permission."Marketplace" orders are not eligible for free or discounted shipping.

Learn more about the TextbookRush Marketplace.

×