SSIS datatype question

• jsheldon

  SSCertifiable

  Points: 5250

  More actions

  January 17, 2008 at 1:31 pm

  #123389

  Trying to get my file in order would like some suggestions on the datatype file or data control task that needs to be performed

  check number column string (DT_STR) loads as this 00079611

  I would like it to go to the destination table as 79611 so a left trim of zeros would be needed to be done.

  Thanks

• Alexander G.

  SSCrazy

  Points: 2705

  More actions

  January 18, 2008 at 1:51 am

  #769571

  Do a datatype conversion to a numeric datatype (DT_UI4) and then back to a String (DT_STR).