Note: Vulcan is a framework to dynamically create SSIS packages.
Hello World!
The above config creates package with following folder structure
•Folder Structure
••Stage Name
•••Package Name
••••Package Name.dtsx
••••Package Name.dtproj
••PackageConfigurations
•••Package Name.dtsconfig
You can have multiple Package Definition in one XML file
Connection details goes Vulcan level and it creates a separate config folder to hold the configurations.
You can define multiple Tasks in a package.
You can configure SQL Tasks as below. There are two types of Queries in Vulcan. It can be a STANDARD or EXPRESSION. For Standard the Query Body is placed in .SQL file by Vulcan and it configures File based SQL Task while creating SSIS package.
You can have expressions in a Query. They are resolved while creating the SSIS package. Remember while the SSIS package will not have these expression, they are static in SSIS.
You can have Variables to Send / Get data to a SQL task. For that you have to define a variable at package level.
The variable can be used in SQL task or other Tasks as a input or output values
You can download more config samples
Guruprasad's space 