A tool to create SSIS packages programmatically. For SQL Server 2016

This tool uses the SSIS Object Model and API.

Wrappers are created around a DtsObject to simplify usage and hide operations where possible. Checkout the demo examples for usage. More examples to be added.

Currently, the following are available. More to follow.

1. Package
2. Sequence Container
3. Data Flow Task
4. Execute Package Task
5. Execute Sql Task
6. Script Task

1. Conditional Split Component
2. Lookup Component
3. Derived Column Component
4. OleDb Destination Component
5. OleDb Source Component
6. Odbc Source Component
7. Flat File Source Component
8. Multicast Component
9. Script Component
10. Rowcount Component
11. Ado.Net Source Component
12. Ado.Net Destination Component
13. Excel Source Component
14. Flat File Destination Component

1. Variables
2. Parameters
3. Connection Managers
4. Event Handlers