Hi there... In a DTS package the First step is activeX script in which it gets the values for 3 global variables .For example Maximum custId and in later steps selects all the values which are greater then tht maxCustID.But my question is when i do the same query like everything which is greater then tht value....it does not give me any record. And thats obvious also as thts the max id.Does this mean that global var. keep the value from last run.And gets al the records which are added after the last run. but getting the values for global var. is the first step of package. so it shd replace the old values. I am totaly confused how this is whole working can some body please provide some clue. This job runs every one hour. Thanks Danny "We've heard that a million monkeys at a million keyboards could produce the complete works of Shakespeare; now, thanks to the Internet, we know that is not true."