July 8, 2003 at 5:44 am
Does anyone know if the status of a DTS Step is available in a variable after a step completes? When you run DTS interactively, the dialog box that pops up has a status column. This is the information that I would
like to retrieve and evaluate in an ActiveX script task.
Thanks in advance,
Scott Lindsey
Sr. DBA, Highlights for Children
July 8, 2003 at 7:16 am
The only way that I can think of doing that is by setting a global variable WITHIN THE STEP with the status. That would mean that you would have to use ActiveX scripts in any task that you want to gather the status from.
Hopefully someone else can think of a better way.
David
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply