Set the package path to "Run the package task" from the integration service catalog in SSIS 2012

Question

I would like to name the SSIS package dynamically based on the configuration of various packages. I deployed SSIS 2012 in the Integration Services Catalog.

At runtime, I have a package name, but I cannot set the path to the SSIS package from the integration directory. I can do this from the file location, but since I use 2012, so you need to use the integration service.

Answer 1

For this you need to use expressions.

Example

Assuming that:

• Packages are located in the following directory:

  MSDB\MyPackages\Import\
  

• @[User::Variable]

, OLEDB Connection manager SQL Server, .

Execute Package . SQL Server .

Execute Package Task ( F4, ) .

:

"\\MyPackages\\Import\\" + @[User::Variable]

: , MSDB\MyPackages\Import\,