1194
Part IX: Business Intelligence
- Choose the user to execute the job (either your credentials or proxy account).
- Confi gure any overrides for parameters and connection managers in exactly the
same manner in which you would if you were using the Execution method.
Summary
Integrations Services is a robust environment capable of easily moving large quantities of
data effi ciently. Its ETL-specifi c tools provide a framework where the developer can focus
on applying business logic rather than such repeatable features such as manually mapping
data with scripts. Moreover, the datafl ow provides the ability to transform data in memory
with Data Flow Transformations, giving SSIS packages major performance benefi ts over
comparable transformations performed with Transact-SQL. Those features, with its built- in
error handling and logging, and with the exciting makeover that SSIS received with the
SQL Server 2012 release, make SSIS one of the most useful tools in the realm of SQL Server.
If you happen to be a reluctant adopter of SSIS, give it one more try. A little bit of effort
learning this great tool goes a long way toward improving the lives of most developers.c52.indd 1194c52.indd 1194 7/31/2012 10:29:32 AM7/31/2012 10:29:32 AM
http://www.it-ebooks.info