how to pass datetime variable from Execute SQL task to the execute process task

• seshagirikudaravalli 20366

  SSC Enthusiast

  Points: 113

  More actions

  August 28, 2020 at 1:08 pm

  #3784391

  i have created two datetime variables in execute sql task and wanted to pass those variable to executed procees task following it.  I was able to create the variables in the result set of Execute SQL task but they are not passed on to the next task. any suggestions are welcome. thanks

• Sergiy

  SSC Guru

  Points: 110209

  More actions

  August 28, 2020 at 3:20 pm

  #3784412

  You need to declare those variables in sp_executesql as OUTPUT parameters

  _____________
  Code for TallyGenerator

• Phil Parkin

  SSC Guru

  Points: 247180

  More actions

  August 28, 2020 at 3:21 pm

  #3784413

  Sergiy wrote:

  You need to declare those variables in sp_executesql as OUTPUT parameters

  And map them to package variables, to use them in subsequent tasks.

  ---