Ebook: Pro SQL Server 2012 Integration Services

Pro SQL Server 2012 Integration Services teaches how to take advantage of the powerful extract, transform, and load (ETL) platform included with Microsoft SQL Server 2012. You'll learn to build scalable, robust, performance-driven enterprise ETL solutions that save time and make money for your company. You'll learn to avoid common ETL development pitfalls and how to extend the power of your ETL solutions to include virtually any possible transformation on data from any conceivable source. SQL Server Integration Services (SSIS) facilitates an unprecedented ability to load data from anywhere, perform any type of manipulation on it, and store it to any source.

Whether you are populating databases, retrieving data from the Web, or performing complex calculations on large data sets, SSIS gives you the tools to get the job done. And this book gives you the knowledge to take advantage of everything SSIS offers.

• Helps you design and develop robust, efficient, scalable ETL solutions
• Walks you through using the built-in, stock components
• Shows how to programmatically extend the power of SSIS to cover any possible scenario

---

Pro SQL Server 2012 Integration Services teaches how to take advantage of the powerful extract, transform, and load (ETL) platform included with Microsoft SQL Server 2012. You’ll learn to build scalable, robust, performance-driven enterprise ETL solutions that save time and make money for your company. You'll learn to avoid common ETL development pitfalls and how to extend the power of your ETL solutions to include virtually any possible transformation on data from any conceivable source. SQL Server Integration Services (SSIS) facilitates an unprecedented ability to load data from anywhere, perform any type of manipulation on it, and store it to any source.

Whether you are populating databases, retrieving data from the Web, or performing complex calculations on large data sets, SSIS gives you the tools to get the job done. And this book gives you the knowledge to take advantage of everything SSIS offers.

• Helps you design and develop robust, efficient, scalable ETL solutions
• Walks you through using the built-in, stock components
• Shows how to programmatically extend the power of SSIS to cover any possible scenario

---

Pro SQL Server 2012 Integration Services teaches how to take advantage of the powerful extract, transform, and load (ETL) platform included with Microsoft SQL Server 2012. You’ll learn to build scalable, robust, performance-driven enterprise ETL solutions that save time and make money for your company. You'll learn to avoid common ETL development pitfalls and how to extend the power of your ETL solutions to include virtually any possible transformation on data from any conceivable source. SQL Server Integration Services (SSIS) facilitates an unprecedented ability to load data from anywhere, perform any type of manipulation on it, and store it to any source.

Whether you are populating databases, retrieving data from the Web, or performing complex calculations on large data sets, SSIS gives you the tools to get the job done. And this book gives you the knowledge to take advantage of everything SSIS offers.

• Helps you design and develop robust, efficient, scalable ETL solutions
• Walks you through using the built-in, stock components
• Shows how to programmatically extend the power of SSIS to cover any possible scenario

Content:
Front Matter....Pages i-xviii
Introducing Integration Services....Pages 1-10
BIDS and SSMS....Pages 11-42
Hello World—Your First SSIS 2012 Package....Pages 43-81
Connection Managers....Pages 83-105
Control Flow Basics....Pages 107-161
Advanced Control Flow Tasks....Pages 163-202
Source and Destination Adapters....Pages 203-244
Data Flow Transformations....Pages 245-324
Variables, Parameters, and Expressions....Pages 325-360
Scripting....Pages 361-403
Events and Error Handling....Pages 405-425
Data Profiling and Scrubbing....Pages 427-464
Logging and Auditing....Pages 465-486
Heterogeneous Sources and Destinations....Pages 487-509
Data Flow Tuning and Optimization....Pages 511-523
Parent-Child Design Pattern....Pages 525-542
Dimensional Data ETL....Pages 543-559
Building Robust Solutions....Pages 561-577
Deployment Model....Pages 579-604
Back Matter....Pages 605-617

---

Pro SQL Server 2012 Integration Services teaches how to take advantage of the powerful extract, transform, and load (ETL) platform included with Microsoft SQL Server 2012. You’ll learn to build scalable, robust, performance-driven enterprise ETL solutions that save time and make money for your company. You'll learn to avoid common ETL development pitfalls and how to extend the power of your ETL solutions to include virtually any possible transformation on data from any conceivable source. SQL Server Integration Services (SSIS) facilitates an unprecedented ability to load data from anywhere, perform any type of manipulation on it, and store it to any source.

Whether you are populating databases, retrieving data from the Web, or performing complex calculations on large data sets, SSIS gives you the tools to get the job done. And this book gives you the knowledge to take advantage of everything SSIS offers.

• Helps you design and develop robust, efficient, scalable ETL solutions
• Walks you through using the built-in, stock components
• Shows how to programmatically extend the power of SSIS to cover any possible scenario

Content:
Front Matter....Pages i-xviii
Introducing Integration Services....Pages 1-10
BIDS and SSMS....Pages 11-42
Hello World—Your First SSIS 2012 Package....Pages 43-81
Connection Managers....Pages 83-105
Control Flow Basics....Pages 107-161
Advanced Control Flow Tasks....Pages 163-202
Source and Destination Adapters....Pages 203-244
Data Flow Transformations....Pages 245-324
Variables, Parameters, and Expressions....Pages 325-360
Scripting....Pages 361-403
Events and Error Handling....Pages 405-425
Data Profiling and Scrubbing....Pages 427-464
Logging and Auditing....Pages 465-486
Heterogeneous Sources and Destinations....Pages 487-509
Data Flow Tuning and Optimization....Pages 511-523
Parent-Child Design Pattern....Pages 525-542
Dimensional Data ETL....Pages 543-559
Building Robust Solutions....Pages 561-577
Deployment Model....Pages 579-604
Back Matter....Pages 605-617
....