I have a scheduled DTS package that builds data from multiple sources. The information is formated into an Excel file and emailed to my users. These users then edit the spread sheet, add some information, and save the 'new' Excel file to one of our network drives. A second scheduled DTS package reads the file on the network drive reformats it into a flat file and emails this flat file to an off-site vendor. About 1/2 the time the uneditied version of the Excell file is picked up by the second DTS package instead of the saved file. The 'saved' file is there and if I re-run the package it always gets the correct file. Any ideas on why it sometimes doesn't the first time around?

Thanks

For safety sake, why not have the users post the new copies to another directory instead? How does the package know which files to select, using an ActiveX script, etc.?


Brian

Thanks. The new copy is saved into a diffreent directory. The DTS package reads it from this directory