Skip to Content
0
Mar 02, 2017 at 03:09 PM

sql statements generated by BODS 4.2

654 Views

hi there,

Im loading data from SAP ECC to Sql Server 2012 using BODS 4.2 I'm facing issues with date and datetime fields in the target table.

For date datatype in the target table following error message is displayed "ODBC data source <CUSIID0q\WARRANTY> error message for operation <SQLBindParameter>: <[Microsoft][ODBC SQL Server Driver]Optional feature not implemented>."

For the datetime datatype in the target table following error message is displayed "datetime field overflow".

I would like to see the sql statements that are being generated by BODS for writing to the target table. Is there any trace option that I can enable that shows me the sql code thats generated during the execution of the job to understand this error message better.

Regards,

samique