O'Reilly logo

Practical Business Intelligence: with SQL Server 2005 by Roger Toren, John C. Hancock

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Summary

ETL processes are defined in Integration Services packages. A package consists of a control flow definition, which describes the high-level flow of a process. A process flow can invoke a data flow, which describes the details of any transformations a data source must go through before being stored in a destination. Packages make it easy to intercept and redirect bad data, and simplify maintenance by making it easy to see what processes and transforms the data is undergoing. You use the BI Development Studio to create and debug your packages and to deploy your solution to other environments such as test and production. In those other environments, connections to data sources and destinations, as well as variables and other parameter ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required