Solving VS2012 start up issue with ‘Could not load type ‘Microsoft.SqlServer.Dts.Design.VisualStudio2012Utils’ error message
Package parameter that is to be mapped to an environment variable should be use with caution. Deleting an environment variable that is mapped to a previous deployed version and running the properly mapped parameter of a new version will cause an unexpected error.
Basic walk-through of Hybrid Mode in SSAS Tabular. Tabular databases with Hybrid mode are designed in DirectQuery, but published with either of the two available hybrid Query Modes.
SSISDB.catalog.get_any_parameter_values is an alternative to SSISDB.catalog.get_parameter_values to get all Project and Package parameter values.