I have a DTS Pkg with the following objects:
select Min(TheDate) as TheDate from MyDateTable
Upon success, I want it to run the following:
(linked server connection)
select MyInfo1 from MyInfoTable
where MyInfoDate = TheDate --->>From the first Exec Sql
Myinfo1 --> MyInfo2
Is it possible to assign the result of the first Exec Sql to a global variable and use it in the Data Transform?