Download PDF Professional Microsoft SQL Server 2014 Integration Services by Brian Knight

Sinopsis

The most important business intelligence tool╇ in the Microsoft Swiss Army knife of tools is SQL Server Integration Services (SSIS). This is because the other tools would be nothing without the cleansing and movement of data into a presentable format. The product can extract, transform, and load (ETL) data astonishingly fast. A 2010 benchmark showed movement of more than a terabyte an hour with SSIS! If you’re new to SSIS, you’ve picked a fantastic field to become involved in. The one consistent skill needed in today’s technical job market is ETL. If a company wants to establish a partnership with another company, it’ll need to communicate data back and forth between the two companies. If your company wants to launch new products, it’ll need a way to integrate those products into its website and catalog. All of these types of tasks are going to require the skill set you are developing and will learn in this book.

Companies that had never used SQL Server before are now allowing it in their environment because SSIS is such an easy-to-use and cost-effective way to move data. SSIS competes with the largest ETL tools on the market like Informatica, DataStage, and Ab Initio at a tiny fraction of the price. SQL Server 2014 now offers more components that you use to make your life even easier and the performance scales to a level never seen on the SQL Server platform.

The best thing about SSIS is its price tag: free with your SQL Server purchase. Many ETL vendors charge hundreds of thousands of dollars, if not millions, for what you will see in this book. SSIS is also a great platform for you to expand and integrate into, which many ETL vendors do not offer. Once you get past the initial learning curve, you’ll be amazed with the power of the tool, and it can take weeks off your time to market. This author team has trained hundreds of people over the years, and you’ll find that the learning curve of SSIS is shallow relative to competing platforms. In SQL Server 2012, the product matured to its third major envisioning. In that release the focus was on scalability, management, and more advanced data cleansing. In SQL Server 2014 an incremental change has happened so new content focuses on patterns in SSIS.

Content

1. Welcome to SQL Server Integration Services
2. The SSIS Tools
3. SSIS Tasks
4. The Data Flow
5. Using Variables, Parameters, and Expressions
6. Containers
7. Joining Data
8. Creating an End-to-End Package
9. Scripting in SSIS
10. Advanced Data Cleansing in SSIS 
11. Incremental Loads in SSIS 
12. Loading a Data Warehouse
13. Using the Relational Engine
14. Accessing Heterogeneous Data
15. Reliability and Scalability
16. Understanding and Tuning the Data Flow Engine
17. SSIS Software Development Life Cycle
18. Error and Event Handling
19. Programming and Extending SSIS
20. Adding a User Interface to Your Component
21. External Management and WMI Task Implementation
22. Administering SSIS

Click here to download