Error:No default type conversion from type "timestamp[m

srinivas.nettalam · Post by **srinivas.nettalam** » Wed May 04, 2011 3:48 am

I am reading a timestamp (microseconds) column from an SQL server table and using it as akey in the lookup stage following ODBC Enterprise stage.The job is aborting with an error "No default type conversion from type "timestamp[microseconds]" to type "ustring[max=32]".
But nowhere it is used as nvarchar or varchar/unicode.

Struggling with this for quite a long time and have done many trial and errors but no solution..

ray.wurlod · Post by **ray.wurlod** » Wed May 04, 2011 4:59 am

At what point is this conversion taking place and are you expecting it to be performed implicitly or are you using an explicit conversion function?

srinivas.nettalam · Post by **srinivas.nettalam** » Wed May 04, 2011 5:46 am

ray.wurlod wrote:At what point is this conversion taking place and are you expecting it to be performed implicitly or are you using an explicit conversion function? ...

I am not converting that timestamp to varchar or nvarchar at all.I am using that column as timestamp as it is in the lookup.

ray.wurlod · Post by **ray.wurlod** » Wed May 04, 2011 3:30 pm

Oh, yes you are, which is why the error message is occurring.

For example what data type is this field in the reference data set?

srinivas.nettalam · Post by **srinivas.nettalam** » Thu May 05, 2011 12:49 am

It is Nvarchar which I am reading it as timestamp microseconds

ray.wurlod · Post by **ray.wurlod** » Thu May 05, 2011 5:32 am

Try reading it as NVarChar.