A Data Transformation Requirement

Let’s consider a true-life data export requirement that is best served by using SSIS. The requirement is for a small business intelligence data mart (on SQL Server 2012) to be spun off each week from the main OLTP database (also on SQL Server 2012) that addresses a product sales manager’s needs to see the total year-to-date business that a customer has generated. This data mart is merely a standard SQL Server database and tables that have been transformed (that is, aggregated) for a targeted purpose. As an option, the manager would also like to spin off an Excel version of this (or at least a comma-delimited .csv file for Excel), which will be distributed via email to all salespeople in the region. This overall ...

Get Microsoft® SQL Server 2012 Unleashed now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.