datatype conversion for float datatype problem
-
Monday, February 04, 2013 9:09 AM
Hi ALL,
I have requirement like ,I have to perform incremental load,there in the comparision,I have an issue with datatype columns,
Actually in source the column is having float data type where as the destination is also same,but for the lookup mapping ,i am getting the error as "cannot map the lookup column,because of floating datatype"
sudha
All Replies
-
Monday, February 04, 2013 9:16 AM
Floating data type is not supported in lookup
Regards,Eshwar.
Please don't forget to Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful. It will helpful to other users.
- Proposed As Answer by Simon Lv Monday, February 04, 2013 9:24 AM
- Marked As Answer by Eileen ZhaoMicrosoft Contingent Staff, Moderator Monday, February 11, 2013 6:58 AM
-
Monday, February 04, 2013 9:26 AM
The join can be a composite join, which means that you can join multiple columns in the transformation input to columns in the reference dataset. The transformation supports join columns with any data type, except for DT_R4, DT_R8, DT_TEXT, DT_NTEXT, or DT_IMAGE. For more information, see Integration Services Data Types.
Why do you need to look up by a float data, what's the requirements.
Please vote if it's helpful and mark it as an answer!
- Marked As Answer by Eileen ZhaoMicrosoft Contingent Staff, Moderator Monday, February 11, 2013 6:58 AM
-
Monday, February 04, 2013 9:27 AM
DT_R4
A single-precision floating-point value.
DT_R8
A double-precision floating-point value.
Please vote if it's helpful and mark it as an answer!
.png)
