Skip to content

Instantly share code, notes, and snippets.

@RichieBzzzt

RichieBzzzt/wwi_ssis_assistDeploy.ps1

Created October 5, 2017 16:38
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save RichieBzzzt/968947b71a28c6632fbcf693adc500fa to your computer and use it in GitHub Desktop.
Save RichieBzzzt/968947b71a28c6632fbcf693adc500fa to your computer and use it in GitHub Desktop.
Download ZIP
Raw
wwi_ssis_assistDeploy.ps1
cls
get-date
Import-Module AssistDeploy -Force
$thisSsisPublishFilePath = "C:\Users\SQLTraining\Documents\bob.json"
$thisIspacToDeploy = "C:\Users\SQLTraining\Downloads\sql-server-samples-master\sql-server-samples-master\samples\databases\wide-world-importers\wwi-ssis\wwi-ssis\bin\Development\Daily ETL.ispac"
$svr = "Server=.\hh;Integrated Security=True"
$myJsonPublishProfile = Import-Json -jsonPath $thisSsisPublishFilePath -ispacPath $thisIspacToDeploy -localVariables
$ssisdb = Connect-SsisdbSql -sqlConnectionString $svr
Publish-SsisFolder -jsonPsCustomObject $myJsonPublishProfile -sqlConnection $ssisdb
Publish-SsisEnvironment -jsonPsCustomObject $myJsonPublishProfile -sqlConnection $ssisdb
Publish-SsisIspac -jsonPsCustomObject $myJsonPublishProfile -sqlConnection $ssisdb -ispacToDeploy $thisIspacToDeploy
Publish-SsisVariables -jsonPsCustomObject $myJsonPublishProfile -sqlConnection $ssisdb -localVariables
Publish-SsisEnvironmentReference -jsonPsCustomObject $myJsonPublishProfile -sqlConnection $ssisdb
Disconnect-SsisdbSql -sqlConnection $ssisdb
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment