INTRODUCTION

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 ....