Error code 0x80004005 when executing package as a scheduled job

0

The error message is:

POSTGRES dm_genders_d failed validation and returned error code 0x80004005.

I've seen several references to this almost assuredly being a permissions issue, which sounds right to me, but I have been completely unable to identify the relevant permissions.

The Postgres connection is using ODBC. The package is moving data from PostgreSQL to SQL Server. Currently both 32bit and 64bit drivers exist, but I haven't seen how to choose between them.

I have made all of the recommended changes to 32 bit for the job.

We are using Windows Authentication.

I've set up a proxy to execute the job as my user.

None of this has alleviated this error.

UPDATE: Yes, the 32 bit data source has been defined, and it is being used.

ssis
asked on Stack Overflow Jan 14, 2013 by Scott Wood • edited Jan 16, 2013 by Scott Wood

1 Answer

0

I had this error and I could solve it by Add ODBC connection in the "system DSN" instead of "User DSN" tab.

Start > ODBC Data Sources

enter image description here

Also I ran package with 32-bit runtime

for this: right click on your job in SQL Server Agent > properties > steps > edit

in the window that appear (Job Step Properties) you can set 32-bit runtime. (below picture) enter image description here

answered on Stack Overflow Apr 4, 2021 by SM.Kheyrandish • edited Apr 4, 2021 by SM.Kheyrandish

User contributions licensed under CC BY-SA 3.0