The package does not run in the sql agent, it fails. Also the package runs perfect in BIDS. Here is the full text of the error:

There was an...

Its PostgreSQL

Visual studio is installed on the server where sql server resides. The DSN is setup on the machine and running the package in debug mode works. I have to...