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: 110208 More actions · Answer 1

You need to declare those variables in sp_executesql as OUTPUT parameters

_____________
Code for TallyGenerator

Phil Parkin SSC Guru Points: 246960 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.

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin