Exporting from SQL Server to Postgres ERROR: column is of type boolean but expression is of type integer

Question

I am using SSMS to export a table into my Postgres DB as described here. Everything is going great, the table and columns are created in Postgres, but when the data is to be loaded it errors out with the following error message:

Error 0xc020844b: Data Flow Task 1: An exception has occurred during data insertion, the message returned from the provider is: ERROR [42804] ERROR: column "XYZ" is of type boolean but expression is of type integer;

I understand the issue, but not sure how to resolve it as I do not see an option in the export wizard to change types. And if I try to create the table ahead of time and do the export I get the following error:

Error 0xc002f210: Preparation SQL Task 1: Executing the query "CREATE TABLE "ABC" (
"XYZ" i..." failed with the following error: "ERROR [42P07] ERROR: relation "ABC" already exists;

Any help would be great. Thanks ahead of time.

mohsen · Accepted Answer · 2019-12-09 17:05:48Z

0

What I ended up doing: Do all the steps as described in the link in my question,when you get to the point in the wizard where you select your table, after selecting your table name will appear in the next column "Destination" double click it and select the correct type for your destination.

happy coding!

answered Dec 9, 2019 at 17:05

mohsen

1,7163 gold badges15 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

M.Hamza Ali Over a year ago

I already have the correct type selected but it still gives me this error.

Collectives™ on Stack Overflow

Exporting from SQL Server to Postgres ERROR: column is of type boolean but expression is of type integer

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related