Sample Header Ad - 728x90

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: enter image description here - 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. enter image description here enter image description here
Asked by gotqn (4348 rep)
Jul 27, 2019, 12:32 PM
Last activity: Jul 28, 2019, 07:29 AM