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

Question

Post reply

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

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Sergiy SSC Guru Points: 110206 More actions · Answer 1

You need to declare those variables in sp_executesql as OUTPUT parameters

_____________
Code for TallyGenerator

Phil Parkin SSC Guru Points: 246686 More actions · Answer 2

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.

If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.