Get-SsisAsJson

NAME Get-SsisAsJson



SYNOPSIS

Convert Ssis project and parameters as json object.





SYNTAX

Get-SsisAsJson [-sqlConnection] <SqlConnection> [-ssisFolder] <String> [-ssisEnvironment] <String> [-ssisProject]

<String> [-ssisEnvironmentDescription] <String> [<CommonParameters>]





DESCRIPTION

Public function used to export the Ssis project to a json file that can be used by rest of module.

Not used anywhere by deployment process.

Developers can create project on ssis server and then run this function.

Or we can import older projects into json file.

Written so that we do not have to spend an age creating/updating json file.





PARAMETERS

-sqlConnection <SqlConnection>

Connection to instance that hosts project.



Required? true

Position? 1

Default value

Accept pipeline input? false

Accept wildcard characters? false



-ssisFolder <String>

Name of the folder we wish to export.



Required? true

Position? 2

Default value

Accept pipeline input? false

Accept wildcard characters? false



-ssisEnvironment <String>

Name of the environment we wish to export.



Required? true

Position? 3

Default value

Accept pipeline input? false

Accept wildcard characters? false



-ssisProject <String>

Name of the project we wish to export.



Required? true

Position? 4

Default value

Accept pipeline input? false

Accept wildcard characters? false



-ssisEnvironmentDescription <String>

Description of the environment. Can be anything



Required? true

Position? 5

Default value

Accept pipeline input? false

Accept wildcard characters? false



<CommonParameters>

This cmdlet supports the common parameters: Verbose, Debug,

ErrorAction, ErrorVariable, WarningAction, WarningVariable,

OutBuffer, PipelineVariable, and OutVariable. For more information, see

about_CommonParameters (https:/go.microsoft.com/fwlink/?LinkID=113216).



INPUTS



OUTPUTS



-------------------------- EXAMPLE 1 --------------------------



PS C:\\>$svr = "Server=.;Integrated Security=True"



$ssisdb = Connect-SsisdbSql -sqlConnectionString $svr

$projectName = "ssis_guy"

$environmentname = "terrain"

$foldername = "ssis_guy"

$desc "here be a description"

$myJsonObject = Get-SsisAsJson -sqlConnection $ssisdb -ssisEnvironment $environmentname -ssisFolder $foldername

-ssisProject $projectName -ssisEnvironmentDescription $desc

$myJsonObject | Out-File ".\\isc_publish_2.json"











RELATED LINKS