Home Forums SQL Server 2012 SQL 2012 - General Parameter error when executing a package with the built in stored procedures RE: Parameter error when executing a package with the built in stored procedures

  • This message is returned by catalog.set_execution_parameter_value raising error 27176 when it fails to lookup your parameter in SSISDB.internal.execution_parameter_values.

    Are you able to successfully call your stored procedure from a TSQL query window (e.g. SSMS)?

    Try selecting directly from that table and see if row exists with your criteria. FWIW, none of the parameter names in my internal.execution_parameter_values table look like that.

    Also, if you haven't already run into this, be aware that much of SSISDB functionality is crippled for users who are not sysadmin or ssis_admin members --most or all of the views in the catalog schema have this criteria hard-coded into the view definition.