Hello I'm a noob poster.

I have been trying to replicate from Sql Server to Postgres using Enterprise Manager and the Postgres ANSI ODBC driver version 8.02.02.

I was able to copy tables over when I used the article option to "DROP existing table and re-create it" only columns of data types datetime and decimal were copied as varchar.

So I tried drop the tables manually and then creating them in postgres with the proper data types (timestamp without time zone, and numeric). I then tried changing the article option to "Keep the existing table unchanged" and I get the following error from the Distribution agent: Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.

So I then tried using the article snapshot option "Delete all data in the existing table" and I got the same error.

Anyone got any suggestions or comments?