SSIS not able to run package in SSMS
0
votes
0
answers
578
views
It's very simple package, running fine when executed via visual studio. From the report I get:
- Visual Studio 2019 Community
- SQL2019CTP3.1
In the connection manager I am using windows authentication. The package has the following structure:
- OLE DB source - simple T-SQL statement
- OLE DB destination - create table and insert the result of the statement
Can anyone tell what can cause this error? I find some topics telling this is a security issue, but not sure what kind of access I need to grant and to whom.
As I said, when I hit the

execute
button in the context of Visual studio the package and execute, a table is created in the destination database and records are inserted.


Asked by gotqn
(4348 rep)
Jul 27, 2019, 12:32 PM
Last activity: Jul 28, 2019, 07:29 AM
Last activity: Jul 28, 2019, 07:29 AM