none
Convert "Month" four-byte signed integer [DT_14] to "Month" String RRS feed

  • Question

  • Hi, I am looking to convert months from an integer to string in SSIS.

    Example:

    Column1

    26/08/2011

     

    From this i have used the expression MONTH(Column1) which outputs "8" as a four-byte signed integer [DT_14].  The desired outcome is to convert "8" to a string such as "Aug" or "August".

    Does anyone have a simple solution to this other than a lookup table?

     

    Friday, August 26, 2011 1:48 AM