• Great article.

    Let me just add my thoughts on minimizing having to edit your dts packages when you move them to a different server.

    One way to avoid the need to change all those server connections in dts packages when you move them to another server is to use UDLs. you can setup UDLs in a centtral repository, say a file server and access them from that location. just make sure that you check the "always read properties from UDL file" check box.