Forum Discussion

BCiampa's avatar
BCiampa
Copper Contributor
Jan 27, 2021

SQL Server - Start With Powershell

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
   xception
    + FullyQualifiedErrorId : PathNotFound,Microsoft.PowerShell.Commands.SetLocationCommand

 

 

 

No RepliesBe the first to reply

Resources