book

Professional Microsoft SQL Server 2012 Integration Services

by Brian Knight, Erik Veerman, Jessica M. Moss, Mike Davis, Chris Rock

March 2012

Intermediate to advanced

960 pages

30h 12m

English

Wrox

Read now

Unlock full access

SQL Server SSIS Historical OverviewWhat’s New in SSISTools of the TradeSSIS ArchitectureEditions of SQL ServerSummary
Import and Export WizardSQL Server Data ToolsCreating Your First PackageThe Solution Explorer WindowThe SSIS Package DesignerManagement StudioSummary
SSIS Task ObjectsLooping and Sequence TasksScript Task (.NET)Analysis Services TasksData Flow TaskData Preparation TasksRDBMS Server TasksWorkflow TasksSMO Administration TasksSummary
Task Host ContainersSequence ContainersGroupsFor Loop ContainerForeach Loop ContainerSummary
Understanding the Data FlowData ViewersSourcesDestinationsCommon TransformationsOther TransformationsData Flow ExampleSummary
Dynamic Package ObjectsUnderstanding Data TypesUsing Variables and ParametersWorking with ExpressionsSummary
The Lookup TransformationUsing the Merge Join TransformationContrasting SSIS and the Relational JoinLookup FeaturesBuilding the Basic PackageUsing the Lookup TransformationCache Connection Manager and Cache TransformSummary
Basic Transformation TutorialTypical Mainframe ETL with Data ScrubbingSummary

Introducing SSIS ScriptingGetting Started in SSIS ScriptingUsing the Script TaskUsing the Script ComponentEssential Coding, Debugging, and Troubleshooting TechniquesSummary
Data ProfilingData Extraction and CleansingDimension Table LoadingFact Table LoadingSSAS ProcessingUsing a Master ETL PackageSummary
Advanced Derived Column UseAdvanced Fuzzy Lookup and Fuzzy GroupingDQS CleansingSummary
Data ExtractionSQL Server Change Data CaptureData LoadingSummary
Excel and AccessImporting from OracleUsing XML and Web ServicesFlat FilesODBCOther Heterogeneous SourcesSummary
Restarting PackagesPackage TransactionsError OutputsScaling OutSummary
The SSIS EngineSSIS Data Flow Design and TuningPipeline Performance MonitoringSummary
Introduction to Software Development Life CyclesVersioning and Source Code ControlSummary
Using Precedence ConstraintsEvent HandlingBreakpointsError RowsLoggingSummary
The Sample ComponentsThe Pipeline Component MethodsBuilding the ComponentsUsing the ComponentsUpgrading to SQL Server 2012Summary
Three Key Steps for Designing the UI: An OverviewBuilding the User InterfaceExtending the User InterfaceOther UI ConsiderationsSummary
External Management of SSIS with Managed CodePackage OperationsApplication Object Maintenance OperationsPackage Log ProvidersPackage ConfigurationsWindows Management Instrumentation TasksSummary
InfoPath DocumentsASP.NET ApplicationsWinform .NET ApplicationsSummary
Using the SSIS CatalogDeployment ModelsUsing T-SQL with SSISCreating a Central SSIS ServerClustering SSISPackage ConfigurationCommand-Line UtilitiesSecurityScheduling Packages64-Bit IssuesMonitoring Package ExecutionsPerformance CountersSummary
What You Will Take AwayBackgroundBusiness ProblemSolution SummarySolution ArchitectureData ArchitectureCase Study Load PackagesCase Study Invoice Matching ProcessCreating a Parent Driver PackageSummary

Overview

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 best practices, based on years of real-world experience that have transpired since the previous edition was published.

Details the newest features of the 2012 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 2012 Integration Services is a valuable resource that meets the demands and high expectations of experienced SSIS professionals.