Activity overview
Latest activity by Onyxia
We are having a similar issue. When we try to execute a package from a tSQLt test, using the SQL Test package runner it fails. When we run the SP from an SSMS query window, everything works and the SSIS package is executed. :shock: We've added print statements around each side of the package execute statement to confirm the test doesn't just shut down at the execute step in the stored procedure. We can't tell how or why the execute package step is failing, but it is because the tables are not being populated with data from the package. We thought it might be a permissions issue, but nothing in our logging indicates a security context issue. Although we still feel there is some security issue we are not able to see.
Any help or suggestions would be welcome. Anyone out there able to execute MS SQL SERVER 2012 SSIS packages from within SQL Test? :? / comments
We are having a similar issue. When we try to execute a package from a tSQLt test, using the SQL Test package runner it fails. When we run the SP from an SSMS query window, everything works and the...