DTS failing when a column is modified | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

DTS failing when a column is modified

We have a MS SQL database that through a package of transformations is transformed to a Access db. The package has like 100 transformations. When I change the name of a column or delete it, the package fails. Now I do not want to search 100 transformation to find where the mapping change and repair it. Is another way that the transformation can be repaired automatically ? Thanks a lot.
You can check www.sqldts.com for many and your DTS related queries.
Meanwhile even i will check for the solution.