Hi

I plan to have the production SQL DB and the development SQL DB. The idea is to make any new development on the development machine and once tested and approved move it to the production SQL DB. Although the structure and all DTS will be identical (that is before changing something on the development SQL) the names of these two machines will be different. I think of using the simplest method for moving a modified DTS from development to production and that is by saving all DTS into a flat file (one of the SQL options). My question is if the name of the SQL Server machine is stored anywhere in the DTS, which may cause some problems when creating a new DTS on one machine and then trying to use it on a different one.

Does anyone have a solid experience in this area?

thanks in advance