rowcount

• coool_sweet

  SSCommitted

  Points: 1892

  More actions

  April 6, 2015 at 1:26 pm

  #295789

  hi

  i am using 1 int32 variable in row count transformation.

  now i am using this in my script task, in footer.

  max length allow is 8, so if i get count 1234,it should display 00001234.

  how to do it with variable

• PB_BI

  SSCoach

  Points: 17463

  More actions

  April 7, 2015 at 5:52 am

  #1789158

  If I get what you're saying correctly, you want to pad out your rowcount with leading zeros up to 8 characters?

  If so, you would first need to convert the rowcount to a string and then use this expression in a variable:

  REPLICATE(“0?, 8 – LEN([i]converted_rowcount[/i])) + [i]converted_rowcount[/i]

  ---

  I'm on LinkedIn