I have created a DTS package to transfer data from Access to SQL, but since this package will be used by different people and name of both databases will be different when each time Data is being transfered. Therefore, the name of database in the package has to be modified. How can I make my DTS so that I wont have to update my transform data task. Can anyone kindly give me some suggestion if this can be done? if yes, and how?
Thanks alot...