Chapter 12. Executing and Securing Packages

Exam objectives in this chapter:

  • Extract and Transform Data

    • Manage SSIS package execution.

  • Load Data

    • Design control flow.

  • Configure and Deploy SSIS Solutions

    • Configure SSIS security settings.

After a Microsoft SQL Server Integration Services (SSIS) solution has been successfully deployed to its intended environment, it can be integrated into existing production processes. Usually, the execution of SSIS processes is automated. In most cases, this means that the processes will be executed by SQL Server Agent, an integral element of the SQL Server platform, or by another, similar solution. Alternatively, the execution of SSIS processes could also be integrated into an organization’s existing proprietary solutions, ...

Get Training Kit (Exam 70-463): Implementing a Data Warehouse with Microsoft SQL Server 2012 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.