I am reading a SQL Server DB Table and am loading another table on SQL Server DB.
Below is the job flow:
ODBC -> Copy -> ODBC
I have a problem wherein I get the below error for some tables and the rest of the tables seem to be loaded fine.
I have not defined any column definition explicitly and the target table is always dropped and recreated.
Error:
Code: Select all
ODBC_Enterprise_57,0: [DataDirect][ODBC SQL Server Driver]Invalid precision value
Can someone please help me figure out why I am getting this error for some of the tables.