Data Type Help

  • I need help I am getting error and try to fix for last couple of days, Please me out, My source field has "Varchar" and target field has "Float". Please guide me how i can convert data type varchar to float. I tried to fix this problem through " Conversion Transformation" but didn't work out package didn't run if i didn't use this field package run fine. Please help me out. Thanks.

  • What is the error that you get?

    Are you sure that all strings can be converted to a numeric format?

    Normally you could use the Conversion component or the Derived Column Transformation.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply