SSISDB catalog.get_parameter_values with NULL-able @package_name input parameter - by Julie Koesmarno

Status : 

  Fixed<br /><br />
		This item has been fixed in the current or upcoming version of this product.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.


2
0
Sign in
to vote
ID 743735 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 5/24/2012 5:36:36 PM
Access Restriction Public

Description

As documented by Books Online (http://msdn.microsoft.com/en-us/library/ff878039), to obtain all project parameters and the parameters from all packages, when executing catalog.get_parameter_values, the "package_name" input parameter should be set to NULL.  However when running the  catalog.get_parameter_values stored procedure with @package_name set to NULL, it returns an error instead stating "The input parameter cannot be null".

** Excerpt from BOL - catalog.get_parameter_values  **
[ @package_name = ] package_name
 The name of the package. Specify the package name to retrieve all project parameters and the parameters from a specific package. Use NULL to retrieve all project parameters and the parameters from all packages. The package_name is nvarchar(260).

Environment:
SQL Server 2012 RTM 11.0.2100 x64
Windows Server 2008R2 Enterprise Edition x64
Microsoft SQL Server Management Studio 11.0.2100.60
Microsoft Analysis Services Client Tools 11.0.2100.60
Microsoft Data Access Components (MDAC)	6.1.7601.17514
Microsoft MSXML 3.0 6.0 
Microsoft Internet Explorer 9.0.8112.16421
Microsoft .NET Framework 4.0.30319.269
Operating System 6.1.7601
Sign in to post a comment.
Posted by Microsoft on 8/14/2012 at 11:21 PM
Hi Julie,

We've fixed this issue. Please expect recent releases.
Posted by Julie Koesmarno on 7/5/2012 at 5:27 PM
The stored procedure fix is fairly simple, I think. I have created a modified version of catalog.get_parameter_values as described here: http://www.mssqlgirl.com/get-parameter-values-from-ssisdb-catalog-a-bug.html. Please use at your own discretion.
Posted by Microsoft on 7/4/2012 at 1:38 AM
Hi Julie,

Thank you for your feedback. We are actively looking at the issue and will keep you updated.