It is good idea, but usually we and also our customers have test environment on the same server and we have to deal with different database name. In this case...
You can use Global variable and when you are calling DTS package from the job you can specify different value for this variable using parameter /~A in DTSRUN command.