I want to pass following expression to variable and call in stored procedure

• saptek9

  Ten Centuries

  Points: 1155

  More actions

  May 30, 2018 at 8:57 am

  #368538

  In ssis package variable i would like to pass following expression. Please advise.
  Eomonth(dateadd(month,-6,het date()))

• sgmunson

  SSC Guru

  Points: 110644

  More actions

  May 30, 2018 at 2:26 pm

  #1992394

  saptek9 - Wednesday, May 30, 2018 8:57 AM

  In ssis package variable i would like to pass following expression. Please advise.
  Eomonth(dateadd(month,-6,het date()))

  Are you sure that your expression would return a value in SSIS?   And as far as using it with a stored procedure, are you seeking to pass the value of that expression, or the expression itself?   If the latter, I'd question your judgement, so my guess is it's the value you want to pass.  You would need a string expression for your query for a given source component that converts the value of that expression to DT_WSTR and appends it into the correct location in the EXEC statement for your stored procedure.

  Steve (aka sgmunson)
  Rent Servers for Income (picks and shovels strategy)