Not sure ix I follow the overall design, bug to answer the direct question: extract the nib date(s) and store in a permanent table. Then have other jobs either create a macro variable from it, or join, depending on how you wish to apply you logic. Macro variable can be created in the autoexec, pre step or in a user written transformation.
... View more
