I have a DTR task that uploads data from a spreadsheet to a SQL2000 database. The current DTR process takes data from a spreadsheet holding hospital admissions and populates the database with these records, no where on the spreadsheet (except for the spreadsheet name) is there any reference to the hospital these records need to be associated with, yet when the DTR session is run the records appear with the correct hospital association, there is a field in the database used to identify each hospital.

I have tried using existing DTR processes that work for different hospitals but transfering the same data only to see the test data going to the hospital associated with the DTR process not the new hospital. How can I modify or can I modify an existing process to post to the correct hospital.

Take a good look at the package properties it may be that it uses a lookup to determine what value to check and replace.

Jaime E. Maccou