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..
Error:No default type conversion from type "timestamp[m
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 134
- Joined: Tue Jun 15, 2010 2:10 am
- Location: Bangalore
Error:No default type conversion from type "timestamp[m
N.Srinivas
India.
India.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 134
- Joined: Tue Jun 15, 2010 2:10 am
- Location: Bangalore
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 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? ...
N.Srinivas
India.
India.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 134
- Joined: Tue Jun 15, 2010 2:10 am
- Location: Bangalore
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: