DTS xChange has a series of enterprise-ready rules to help you migrate your DTS packages to SSIS quickly and easily. After you select the packages that you wish to migrate, you then specify the rules on the Specify Rules screen in the wizard.

By enabling this rule, duplicate connections will be consolidated into a single connection manager. If two connections in DTS contain the same information (server name, database name and user information) and they’re not being set dynamically through a Dynamic Properties Task, then they will be consolidated into a single connection manager with the name of the first connection.