What I tried to do:
Sets the value of a parameter in the Integration Services catalog.
EXEC [SSISDB].[catalog].[set_ object_parameter_value]
@object_type=20,
@parameter_name=N' MyServerName',
@object_name=N'MyProcess',
@folder_name= N'MyProcess',
@project_name= N'MyProcess',
@value_type=R,
@parameter_value= N'MyServerName';
GO
Error message:
[SSISDB].[catalog].[set_ object_parameter_value] Cannot find the parameter because it does not exist.
Cause and Fix:
Lowercase / Uppercase of the names – environment VS SSIS parameters.
When I set the letters to be exactly the same – it worked.
EXEC [SSISDB].[catalog].[set_ object_parameter_value]
@object_type=20,
@parameter_name= N'MYSERVERNAME',
@object_name=N'MyProcess',
@folder_name= N'MyProcess',
@project_name= N'MyProcess',
@value_type=R,
@parameter_value= N'MYSERVERNAME';
GO
No comments:
Post a Comment