DSXchange

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..

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?

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.

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?

It is Nvarchar which I am reading it as timestamp microseconds

Try reading it as NVarChar.