question

premkmr1 avatar image
premkmr1 asked

Data Flow Task : Error ODBC Source Failed Validation and returned error code 0x80004005

0

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).

1672042116827.png

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).

1672042248681.png

How to resolve this issue? Any insight on this will be very helpful.

Regards, PKR

Things I have tried

  1. I tried to check my access to SQL server, the error is happening even after gaining complete admin level access.
  2. I tried to change the target server version in Visual Studio to match with SQL server version yet it didn't help.
ssis errorsql-server-agent
1672042116827.png (66.6 KiB)
1672042248681.png (127.9 KiB)
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.