Chapter 19. Implementing Custom Code in SSIS Packages
Exam objectives in this chapter:
Extract and Transform Data
Design data flow.
Implement script tasks in SSIS.
Load Data
Design control flow.
Implement script components in SSIS.
Configure and Deploy SSIS Solutions
Deploy SSIS solutions.
There are many tasks, data sources, destinations, and transformations available in Microsoft SQL Server 2012 Integration Services (SSIS) out of the box. However, at times you might find yourself needing to perform an action that is not covered by the available tools. Fortunately, SSIS allows you to extend its capabilities by implementing your own code in a package.
There are many extension points in SSIS. For example, you can use the Execute SQL task to execute any T-SQL ...
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.