cls
Import-Module AssistDeploy -Force
$DW_ServerName = "[svr].database.windows.net"
$DW_UserName = "uid"
$DW_Password = "pw"
$E_Servername = "[svr].database.windows.net"
$E_UserName = "uid"
$E_Password = "pw"
$svr = "Server=tcp:[svr].database.windows.net,1433;Initial Catalog=SSISDB;Persist Security Info=False;User ID=[id];Password=[pw];MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;"
$thisSsisPublishFilePath = "C:\Users\SQLTraining\Documents\WWI_SSIS_ETL.json"
$thisIspacToDeploy = "C:\Users\SQLTraining\source\repos\WWI_SSIS\WWI_SSIS\bin\Development\Daily ETL.ispac"
$myJsonPublishProfile = Import-Json -jsonPath $thisSsisPublishFilePath -ispacPath $thisIspacToDeploy
$ssisdb = Connect-SsisdbSql -sqlConnectionString $svr
$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
Publish-SsisEnvironmentReference -jsonPsCustomObject $myJsonPublishProfile -sqlConnection $ssisdb
Disconnect-SsisdbSql -sqlConnection $ssisdb