Data Warehouse Patterns
SQL Server Integration Services is an excellent general-purpose ETL tool. Its versatility finds it used by DBAs, developers, BI professionals, and even business principals in many different scenarios. Sometimes it’s a dump truck, used for the wholesale movement of enormous amounts of data. Other times it’s more like a scalpel, carving out with precision just the right amount of data.
Unable to display preview. Download preview PDF.