Skip to content

Instantly share code, notes, and snippets.

@RichieBzzzt

RichieBzzzt/Get-SsisAsJsonForWWISSIS.ps1

Created October 5, 2017 16:32
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save RichieBzzzt/a2366ed07173b6688b6578276e75b69f to your computer and use it in GitHub Desktop.
Save RichieBzzzt/a2366ed07173b6688b6578276e75b69f to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Get-SsisAsJsonForWWISSIS.ps1
Import-Module AssistDeploy -Force
$svr = "Server=.\hh;Integrated Security=True"
$ssisdb = Connect-SsisdbSql -sqlConnectionString $svr
$projectName = "Daily ETL"
$environmentname = "everestPublic"
$foldername = "WWI"
$desc = "This is a sql-server-sample project"
Write-Host "Beginning to extract variables" -ForegroundColor Yellow -BackgroundColor DarkCyan
$myJsonObject = Get-SsisAsJson -sqlConnection $ssisdb -ssisEnvironment $environmentname -ssisFolder $foldername -ssisProject $projectName -ssisEnvironmentDescription $desc
Write-Host "Complete." -ForegroundColor Yellow -BackgroundColor DarkCyan
$myJsonObject | out-file "C:\Users\SQLTraining\Documents\bob.json"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment