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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
