ppend 0''s

• Jambu Krishnamurthy

  SSCrazy

  Points: 2054

  More actions

  December 6, 2006 at 7:29 am

  #676209

  yep, you can do this very easily in your activeX script of Data Transformation task, as long as your database column is a char/varchar field

• John-79567

  SSCommitted

  Points: 1892

  More actions

  December 6, 2006 at 9:18 am

  #676276

  Thanks for the suggestion.  Fortunately, I was able to find a way to do this using a derived column task and expression.

  Example:

  Column    Action               Expression

  TableID Replace(tableID)     (len(tableID) == 3 ? "00" + tableid : TableID

   

  Explanation - the expression above is similar to a case statement.  "?" = if  and ":" = else

  So basically, "(len(tableID) == 3 ?" is the True/False check.  If (len(tableid) == 3  Then "00" + tableID else ":" tableID

• John-79567

  SSCommitted

  Points: 1892

  More actions

  December 6, 2006 at 12:06 pm

  #676374

  I found a better way to add 0's to the tableID

  Using derived column task, I add a new column with the following expression.

  RIGHT("0000", 5 - (LEN(TableID))) + TableID