SQL Server Quick Tip 26 – 30



Microsoft Connect Bug Reports

Just posted two bug reports to Microsoft Connect

We don’t take kindly to sensitivity ’round here…
First, I perceive it as a bug, when a foreach loop fails to list variables when a project parameter is set as sensitive. When a project parameter is set as sensitive, I get this error message when setting up the foreach loop:

MsgBox Following is the failure to populate the list of variables:


Vote here: https://connect.microsoft.com/SQLServer/feedback/details/786696/foreach-from-variable-enumerator-fails-when-one-or-more-parameters-are-marked-as-sensitive

Flexibility? MEH!
The other bug is about the file connection manager.
When adding a file connection manager as a project connection manager, I want to be able to se the connection string as an expression in a given package. But none of the project parameters are present when I open the expression builder dialog box. Huh?


Vote here: https://connect.microsoft.com/SQLServer/feedback/details/787145/project-parameters-not-present-in-file-connection-manager-expression


SQL Server Quick Tip 16-20


Run out of disk you say, eh?

In the rare occasion, that when you are executing a project from the Information Services Catalogs, and the SysAdmin didn’t foresee some, unforeseeable event causing the disk to run out of space. And the execution doesn’t fail, just waits for more disk to become available, you will maybe be tempted to stop the operation through the ‘Active Operations’ pane in SSISDB.

This cannot be done, simply because, catalog.stop_operation which is the stored procedure called, also needs to write to disk. As the following screen shots will verify, you need to restart the instance.

Active OperationsIn SQL Server Management Studio (SSMS), select the Integration Services Catalogs, and right click the SSISDB. Click Active Operations.

Active OperationsWhen you select the operation, the option to Stop the operation becomes available.

Active OperationsYou will the be prompted, if you really want to Stop the operation.

And if you select Yes, you will be met by the following error.

Active OperationsSo, in order to get the operation, which is running, to stop, you need to restart the whole instance.


SQL Server Quick Tip 11 – 15