I have set up a loop in DTS which connects to various servers and collects
data from them. I have two parameters which are fed into my transform data
task query from global variables.

EXECUTE uspGetAlertPool @LastRun=?,@ServerID=?

For some reason, the LastRun is not updated every time it loops through but
the ServerID does change. The LastRun always stays on the first value that
was assigned to it and does not get updated for subsequent values.

How are you doing the asssignment?

You may want to look and see if case matches.

--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"DBA72" <DBA72 (AT) discussions (DOT) microsoft.com> wrote