Some of our packages are self aware of the servers they are on and know
whether to push/pull data based on that. If the package lives on a TEST
server - it would know to work with test data whereas once the same DTS
package was promoted to production - it would know to work with Prod data
with no changes whatsoever to the package.

Using this sort of environment aware control we have been able to promote a
single DTS package through each of our 4 tiers (dev, test, pre-prod, prod)
without having to change any of the connections inside the DTS.

The solutions I have come up with isn't too terriably elegant - has anyone
else came up with a solution to have their DTS packages environment self
aware and reconfigures it's connections based on that?

__________________________
Joe Horton
Database Developer / Software Engineer
WISHA/Legal Services Software Development
Department of Labor and Industries
Voice (360) 902-5928 fax (360) 902-6200

MS Sql Server LazyDBA home page