O'Reilly logo

Microsoft SQL Server 2012 Integration Services: An Expert Cookbook by Pedro Perfeito, Reza Rad

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

Execution from a scheduled SQL Server Agent job

ETL processes can be executed on a schedule, and this schedule can be daily, weekly, or at larger intervals of time. ETL or any Data Transfer process is better done during off-peak times in order to reduce resource and memory consumption; for example a database engine may have a lot of requests during daytime hours. So if the ETL process runs at daytime, this will cause long responses to requests, which will affect the performance of your server, so this process probably should be run late at night when the number of requests to the server is much lower.

SQL Server has a service that provides scheduling tasks; this service is named SQL Server Agent. The SQL Server Agent service can be installed with ...

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