using biml (via BIDS helper in visual studio) how do i assign values to the properties of the SSIS 2008 Execute Package Task object, specifically
- Location: SQL Server
- Connection: SomeConnectionString
using BIML. I have searched for many hours and cannot find how to set these properties
Inside your
ExecutePackage
tag, you'll need to specify that it's aSqlServer
source.In the following declaration, I create two connection managers, one for a file based connection manager and one for a SQL connection to my named instance.
The Biml itself creates 2 packages. A Child and Parent. The Parent package creates two Execute Package Tasks
The resulting Execute Package Task for the SQL Server appears as