EzAPI - Package generation API
This sample provides some functionality to easily create SSIS packages programmatically and dynamically alter their objects (tasks, components, changing metadata, connection strings, etc). This framework supports:
- Creation SSIS packages of any complexity including both SSIS runtime and pipeline (tasks, containers and components)
- BIDS like behavior (automatic column mapping in destinations, automatic metadata refresh, default values of properties, etc)
For more information, see the
post on the SSIS team blog.
Written by Evgeny Koblov