Error converting data type varchar to numeric.
Posted: Mon Aug 13, 2007 6:37 am
Hi,
I have designed job with source and targets are SQL Server tables. Source metadata is Varchar and Target metadata is Numeric.
I am getting below error, even I used the StringToDecimal conversion function.
APT_CombinedOperatorController,0: [DataDirect][ODBC SQL Server Driver][SQL Server]Error converting data type varchar to numeric.
Please help on this.
I have designed job with source and targets are SQL Server tables. Source metadata is Varchar and Target metadata is Numeric.
I am getting below error, even I used the StringToDecimal conversion function.
APT_CombinedOperatorController,0: [DataDirect][ODBC SQL Server Driver][SQL Server]Error converting data type varchar to numeric.
Please help on this.