I am trying to migrate data from PostgreSQl to SQL Server, for which I have created a SSIS package in Visual Studio 2019 using OBDC Source (for connecting to PostgreSQL) and OLE DB Destination (to connect SQL Server in Visual Studio).
I was able to successfully establish the connection in both database and transfer the data in visual studio.
To create a SQL Agent job, I tried creating a SSISDB catalog in SQL Server under integration service catalogs and deployed my SSIS package in Visual Studio 2019 (Note: I tried to change Target server version in Visual studio same as SQL server version).
Although the execution happens successfully in Visual Studio but in SQL server when I execute the package in SSMS, it is throwing an error (highlighted in title and in the screenshot).
How to resolve this issue? Any insight on this will be very helpful.
Things I have tried
- I tried to check my access to SQL server, the error is happening even after gaining complete admin level access.
- I tried to change the target server version in Visual Studio to match with SQL server version yet it didn't help.