As the title suggests, I’m looking to get access to the variables in a package, when it is stored in the SSIS Catalog, using powershell. The reason I’m looking to do this is that Package Variables allow me to initialise and pass objects from powershell to the SSIS script (Project Parameters and Environment Variables in the SSIS Catalog cannot have parameters/variables of type Object)
If the package is stored in the old Integration Services store (folders within the MSDB database) I can access the variables using the ManagedDTS objects.
Using the new IntegrationServices package, which is the provided way to interact with packages in the SSIS Catalog in powershell, I can’t seem to find a way to access these variables.
Is there a way to access these variables, using powershell if the SSIS project is stored in the SSIS Catalog?