SQL Server - Start With Powershell

Copper Contributor

When I expand "Integration Services Catalogs" and then right-click SSISDB in SSMS and select "Start Powershell", I get this message.  I placed {instance} in place of the server name.  Any thoughts?




cd : Cannot find path 'SQLSERVER:\SSIS\{Instance}\DEFAULT\Catalogs\SSISDB' because it does not exist.
At line:1 char:175
+ ... grationServices[@Name=''{Instance}'']/Catalog[@Name=''SSISDB'']'|cd}
+                                                                       ~~
    + CategoryInfo          : ObjectNotFound: (SQLSERVER:\SSIS...Catalogs\SSISDB:String) [Set-Location], ItemNotFoundE
    + FullyQualifiedErrorId : PathNotFound,Microsoft.PowerShell.Commands.SetLocationCommand




0 Replies