month value in vb script

• Tara-1044200

  SSCoach

  Points: 15951

  More actions

  August 6, 2009 at 7:53 am

  #134569

  I am using vb script in my ssis and within that i am trying to cocatinate 4 fields into an ID field, one of the 4 fiels is month which return only 1 digit, say if i have Jan it returns " 1 " but i am expecting "01" instead so as to make my ID unique.

  How do i retun 01 instead of 1 in vb script for month.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 737757

  More actions

  August 6, 2009 at 8:32 am

  #1035407

  Cast to string, check if it's 1 character, and if so, add a "0".

  It returns a number. "01" is not a number, according to western math.