Rename DTS Tasks for Clear Log Text

This Script will create a copy of your DTS Package; append "_Renamed" to the end of the package name; and rename every task and step in the copied package to Task/Step_TaskType_DescriptionText_Sequence.

The resulting package will lose all of it's text annotations, the layout will be the designer default rather than the original latout. It can run unnattended and will generate meaningful log text.

Please read the usage carefully because some cautions are necessary to use this script.

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands
of articles and SQL scripts, a library of free eBooks, a weekly database news roundup,
a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals
that makes it such a success.