SSIS Is there any way to change excel text values to numeric before import to sql? RRS feed

  • Question

  • User-1305858305 posted


    My excel files data contains text values. (red,blue,green etc)

    My sql table values are numeric. (1,2,3,4)

    Is there any way to change text data to numeric with condition before import in SSIS?

    Thanks in advance

    Thursday, January 15, 2015 10:49 AM