SSIS dynamically Execute Package Task: Package Name is missing

Question

I want to run multiple packages using Execute Package Task. There is a table in database saves the package names. I create a SQL Query Task first. The query result is a list of package names:

Then I created 2 variables. A Variable called List, its type is system.Object. It is used to save this list of package names.

Then I added a Loop each Container to read through each record in the List variable. And give each record's value to a variable called Name (type is string)

Then I put a Execute Package Task into the Loop each Container. And set the Expression to let the PackageName to use Name variable's value. But after I clicked OK, it gave me a warning:' Package Name is missing'. Does it mean the Name variable cannot pass value to this Execute Package Task? I haven't deployed this project to SQL Server database. I just run it in VS2015 development tool. Do I have to deploy all the packages first?

Answer 1

For the execute package task, set DelayValidation to True. This will postpone validation for the task until runtime.