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.
