Error While importing table to SAP Data services Designer from PostgreSQL DB

[former_member542326]

Hi All,

I am getting a syntax error while trying to import a table from postgreSQL DB using SAP BODS. Please find the below screenshot and help me out solving this issue.

Thank you.

[akhileshkiran]

Hi kaushik goli,

For the column status the ddl statement is populating as the status varchar(-1) null,

As the varchar(-1) can be rewritten as nvarchar(max) / varchar(max). I suggest you to please check the checkbox in the datastore as highlighted below.

Regards,

Akhilesh Kiran N.