Does anyone have a problem to type cast a string into an integer in expression builder

• Loner

  SSC-Insane

  Points: 21279

  More actions

  April 11, 2008 at 1:19 pm

  #128491

  I have a variable defined as string and I want to change to integer in the expression builder.

  Variable - StartPeriod STRING -7

  In Expression

  SELECT (DT_WSTR,50)DATEADD("dd", DT_I8(@[USER::StartPeriod]), GETDATE())

  I got an error - Error occurred attempting from DT_WSTR to date type DT_I8

  How can I change from string to integer?

  Thanks

  BTW, I HATE SSIS :crazy:

• magasvs

  SSCertifiable

  Points: 7660

  More actions

  April 12, 2008 at 6:06 pm

  #801837

  Try this:

  1) add another variable of type Int64 (named as IntVar in this example)

  2) use expression to assign value to this variable (DT_I8) @[User::StartPeriod]

  3) change your expression to (DT_WSTR,50)DATEADD("dd", @[USER::IntVar], GETDATE())