< Back

Import-Json

Fri Jan 10, 2020 9:04 pm

NAME Import-Json



SYNOPSIS

Import the integration services catalog publish json file





SYNTAX

Import-Json [-jsonPath] <String> [-ispacPath] <String> [[-localVariables]] [[-variableType] <String>]

[<CommonParameters>]





DESCRIPTION

Internal function used to import the json file that stores the integration services catalog properties and

variables.





PARAMETERS

-jsonPath <String>

File path of json file.



Required? true

Position? 1

Default value

Accept pipeline input? false

Accept wildcard characters? false



-ispacPath <String>

File path of ispac file.



Required? true

Position? 2

Default value

Accept pipeline input? false

Accept wildcard characters? false



-localVariables [<SwitchParameter>]

Switch to determine whether we need to validate that variables with the name of the variableName exists or not

in current session.



Required? false

Position? 3

Default value False

Accept pipeline input? false

Accept wildcard characters? false



-variableType <String>

Existence checks for variables can be either for Powershell variables (e.g. $Foo) or Environment variables

(e.g. $Env:Foo). Deployment tools store values in different ways. This give some control as to where the

variables should be checked.



Required? false

Position? 4

Default value PS

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:\\>$ssisJson = Import-Json -jsonPath "C:\\Users\\SQLTraining\\Documents\\iscPublish.json" -ispacPath

"C:\\Users\\SQLTraining\\Documents\\iscPublish.ispac"















RELATED LINKS