Hello,

I have defined two package parameters in my 2014 SSIS package

1. ssas_backup_dir

2. ssas_instance

I would like to set them through the "Set Values" tab in a sql agent job. I know variables can be set as below

Property Path: \Package.Variables[User::VariableName] 
Value: SomeValue

These are not variables, but package parameters. I have tried many different variations trying to set the parameters but keep getting errors unable to set the parameter. 

DTExec: Could not set .......

Any ideas on how to set the project parameters in the set values tab in sql agent?

Thx

• Edited by precept33 6 hours 59 minutes ago

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/6dab4bb2-5917-4d3a-b1d3-afe4a9a18a51/execute-package-utility-set-values-how-to-set-property-path-and-values?forum=sqlintegrationservices

Dinesh,

Those are for setting package variables. I am looking to set package parameters.

I have tried \Package.Variables[ssas_instance].Value and many other variations.

These are not variables, and within my SSIS project they are referenced as @[$Project::ssas_instance] within my expressions task.

I can't seem to figure out how to set these parameters, but I have set variables with the methods shown in the link that you sent