How to Validate Package/Project with Required Parameters

Question

I'm using SSIS 2014 and want to make use of the package/project validation features as part of our DEV testing procedures.  We have environment variables set up to handle all connection strings, and we also have several project parameters that are set at run-time.  When I right click on a deployed package/project and select "validate", the parameters that are mapped to environment variables are populated as expected.  However, the "run-time" project parameters are blank, and I can't figure out how to populate them with values for the purposes of validation.  Here is a screenshot:

I'd expect to see the "..." button that would allow me to enter a value, as it does when I execute the package instead of validate.

Answer 1

Hi Smithochris,

Based on my test, it is as you described, the validate UI doesn't allow to edit the parameter values, which seems a feature of SQL Server Management Tool. You can submit a feedback on Microsoft connect if you'd like to edit the parameter in validate UI.

As a workaround, even the parameters would be assigned with a "run-time" value, you can still set an initial value before deploying.

If you have any question, feel free to let me know.

 

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].

Answer 2

Thanks Eric.  How do I set an initial value before deploying?  In Visual Studio, my "run-time" parameters appear to have initial values, but they don't have values in the validation dialog when deployed.  Note that my parameters are set as "required" - not sure if that makes a difference.  Here are a few screenshots of the parameters in visual studio:

Package Parameter:

Project Parameters:

Answer 3

Hi Smithochiris,

The option "Required" as true does matter. Check create parameters. When false, I can see the initial value in Parameter dialog in SSMS.

Required

Requires that a value, other than the design default, is specified before the package can execute.

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].