Call Package From JAVA And Pass DB Connection Data To It

Hello everyone,


I have implemented a package, which loads data from a flat file into an OLE DB destination. I have added the properties of the OLE DB Connection Manager to the package configuration (XML file), in order to give me enough flexibility for running the package on different databases.


Now I wanted to integrate my package into the application that would call it and I ran into these problems.


A. Call a package from a JAVA application:
I have a JAVA web application, which should provide the source file and finally trigger the load operation.

A1: How can I execute a package from within a JAVA application?

A2: How can I pass parameters to this package?


B. Parallel Package Execution:
If I was able to trigger the package execution from my application, then I can encounter a situation where the package is triggereed to be executed again with different input data before the first package has finished.


B1: Is it possible (from SSIS point of view) that the same package gets executed parallely with different input?


C. Run the package against several databases:
Assuming that I have 5 databases where I load data using this package.
I have created 5 configuration.xml files with the corresponding DB connection properties.


C1: How can I tell the package which configuration file to read from, in order to load the source data into the correct destination? Is it possible to pass the path of the configuration.xml file when executing a package?


Thanks in advance.


Regards,
Samar