Forum Discussion
BCiampa
Jan 27, 2021Copper Contributor
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