Decimal To Timestamp conversion error
Posted: Wed Mar 07, 2012 9:40 pm
I am using ODBC connector stages in my job. The job has source,transformer and target. Source ODBC connector has db2 database and target is SQL Server
There are 10 columns in the source which is of data type Decimal(8,0). These contain dates in yyyymmdd format
In the target these columns are of datetime format. In the transformer I am using DecimalToTimestamp(colname,"%yyyy%mm%dd").
However I am getting error [ODBC SQL Server Driver] Invalid Date format
When I replace target ODBC connector with ODBC Enterprise stage the error goes away.
Is this some kind of bug in ODBC connector
There are 10 columns in the source which is of data type Decimal(8,0). These contain dates in yyyymmdd format
In the target these columns are of datetime format. In the transformer I am using DecimalToTimestamp(colname,"%yyyy%mm%dd").
However I am getting error [ODBC SQL Server Driver] Invalid Date format
When I replace target ODBC connector with ODBC Enterprise stage the error goes away.
Is this some kind of bug in ODBC connector