Invalid Character value for cast specification

[jpockets]

I'm getting this error:

[DataStage][SQL Client][ODBC][DataDirect][ODBC SQL Server Driver]Invalid character value for cast specification

I know that it's trying to insert data into a column that is not the defined as. My question is i don't get any details of the record is just recieve this error:

Sales_Table_Load_Pt1..Transformer_71.DSLink72: DSD.BCIPut call to SQLExecute failed.
SQL statement:INSERT INTO .TSALES_DETL_Dev(POLICY_NO, POLICY_EFCTV_DT, ANNL_STMT_CO_CD, POLICY_XPRTN_DT, INSURED_NM, GROSS_PREMIUM_AM, GROSS_COMSN_AM, CEDED_PREMIUM_AM, CEDED_COMSN_AM, NET_PREMIUM_AM, NET_COMSN_AM, ASSUMED_PREMIUM_AM, ASSUMED_COMSN_AM, DIRECT_PREMIUM_AM, DIRECT_COMSN_AM, TREATY_PREMIUM_AM, TREATY_COMSN_AM, FAC_PREMIUM_AM, FAC_COMSN_AM, ACCT_DT, PROC_DT, COMPANY_NO, DSP_DIV_NO, DSP_SEC_CODE, DSP_PUC, TRANS_EFCTV_DT, TRANS_XPRTN_DT, REORG_DIV_NO, REORG_SECTION_CD, REORG_PUC_CD, REORG_MRKT_SEG_CD, CLOSING_DIVISION_NO, CRDT_REGION_CD, CRDT_BRANCH_CD, TAX_ST_CD, PRODUCER_NO, CONS_PRODUCER_NO, CONS_PRODUCER_NM, BUSINESS_NM, TRANS_CD, SOURCE_SYSTEM_ID, ANNL_STMT_LINE, PREMIUM_MKT_SEG_CD, WORKING_REGION_CD, WORKING_BRANCH_CD, DUNS_NO, REINS_TREATY_NO, REINS_TREATY_NM, REINS_COMPANY_NO, REINS_COMPANY_NM, LEDGER_DT, MACHINE_CD, F_DIVISION_NO, CORP_STRCT_TYPE_CD, LEDGER_MONTH, LEDGER_QUARTER, LEDGER_YEAR, YEAR_MONTH_TX, F_CRDT_REGION_CD, F_CRDT_REGION_NM, F_APC_TX, F_MARKET_SEG_CD, ULT_DUNS_NO, HOME_OFFC_UW_ID, HOME_OFFC_UW_NM, RISK_SCORE_NO, RISK_CATEGORY_DS, MKTCAP_AM, REVENUE_AM, ASSET_SIZE_AM, EMPLOYEE_CT, TICKER_SYMBOL_CD, AGGR_INDUSTRY_DS, MKTCAP_CTGRY_DS, SIC_CD, PRODUCT_ABBR, LIMIT_OCR_AM, LIMIT_AGR_AM, DED_OCR_AM, DED_AGR_AM, ATTACH_PT_AM, FORMYEAR, CLAIMS_IN, B_RPM, T_RPM, LOAD_DT, D_APC_TXT, FIN_APC_TXT, BROKER_DNB_NO, BROKER_RANK_NO, F_TRANS_CD) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
SQLSTATE=22005, DBMS.CODE=0
[DataStage][SQL Client][ODBC][DataDirect][ODBC SQL Server Driver]Invalid character value for cast specification

Is there a way to get details on the error message?

[ray.wurlod]

No. DataStage reports everything that is returned from the data source or, in this case, the ODBC driver. That's all you get. That's all you can get. One of the values in your data is inappropriate for the data type to which you are directing it.

I'm also curious about the leading "." on the table name.