Problem loading DATE data type in SQL server
Posted: Mon Nov 14, 2011 2:57 pm
I am having problems writing to SQL Server Database(2008) in a DATE column. We have defined DATE data type for a column and we are trying to insert value in the format of 'yyyy-mm-dd'. We get the following error.
Job Design is :
When I imported the table definition in DS, it shows as NVarchar(10) for that column. I tried following things.
1. Run with NVarchar(10) in target odbc, lookup odbc and transformer
2. Run with date(10) in target odbc, lookup odbc and transformer
3. Run with varchar(10) in target odbc, lookup odbc and transformer
First, why is it getting converted to NVarchar during import and what should I use ?
Appreciate any help.
Code: Select all
odbc_lkp: Error when checking operator: When binding output interface field "DATE_CALLED" to field "DATE_CALLED": No default type conversion from type "ustring[max=10]" to type "date".
Code: Select all
Seq File to Join stage to Transformer to ODBC stage.
another ODBC stage coming to Join stage.
1. Run with NVarchar(10) in target odbc, lookup odbc and transformer
2. Run with date(10) in target odbc, lookup odbc and transformer
3. Run with varchar(10) in target odbc, lookup odbc and transformer
First, why is it getting converted to NVarchar during import and what should I use ?
Appreciate any help.