title: Deploy and set Ispac connectionstring property in the Connection Manager tab with Powershell
body: <p>I can successfully deploy the ssis project with powershell using the code below however, i also wanted to set the connectionstring property (at the project level) in the Connection Managers tab. i tried to search but can't find any sources. can someone please help?<a href="https://i.stack.imgur.com/4EF5p.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/4EF5p.png" alt="enter image description here"></a></p>
  
  <pre><code># Variables
  $SSISNamespace = "Microsoft.SqlServer.Management.IntegrationServices"
  
  $TargetServerName = "localhost"
  $TargetFolderName = "Project1Folder"
  $ProjectFilePath = "C:\Projects\Integration Services Project1\Integration Services Project1\bin\Development\Integration Services Project1.ispac"
  $ProjectName = "Integration Services Project1"
  
  # Load the IntegrationServices assembly
  $loadStatus = [System.Reflection.Assembly]::Load("Microsoft.SQLServer.Management.IntegrationServices, "+
      "Version=14.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91, processorArchitecture=MSIL")
  
  # Create a connection to the server
  $sqlConnectionString = `
      "Data Source=" + $TargetServerName + ";Initial Catalog=master;Integrated Security=SSPI;"
  $sqlConnection = New-Object System.Data.SqlClient.SqlConnection $sqlConnectionString
  
  # Create the Integration Services object
  $integrationServices = New-Object $SSISNamespace".IntegrationServices" $sqlConnection
  
  # Get the Integration Services catalog
  $catalog = $integrationServices.Catalogs["SSISDB"]
  
  # Create the target folder
  $folder = New-Object $SSISNamespace".CatalogFolder" ($catalog, $TargetFolderName,
      "Folder description")
  $folder.Create()
  
  Write-Host "Deploying " $ProjectName " project ..."
  
  # Read the project file and deploy it
  [byte[]] $projectFile = [System.IO.File]::ReadAllBytes($ProjectFilePath)
  $folder.DeployProject($ProjectName, $projectFile)
  
  Write-Host "Done."
  </code></pre>