SSIS: Setting the same variable in multiple projects in the catalog
First published on MSDN on Feb 14, 2017 Recently I was assisting a customer with a review of their SSIS implementation and one the security implementations that they had in place was service accounts for SQL Server Integration Services packages.The EXECUTE permission was denied on xp_msver
First published on MSDN on Jan 24, 2017 Recently after installing SQL Server and configuring SSIS for project deployment in a SQL Server 2012 environment, a customer was experiencing issues when attempting to execute a package deployed to the Integration Services catalog or through SQL Agent calling the package.
