Error occurred during the creation of the DTS Package

This morning I received a call from a client who were receiving the error “Error occurred during the creation of the DTS Package” whenever they attempted to open the SQL Server 2000 DTS designer by either editing a package or attempting to create a new package.  This error often occurs when there is an issue with the registration of the problem with DTSPkg.dll.  The DTSPkg.dll can be found in the C:\Program Files\Microsoft SQL Server\80\Tools\Binn directory.

In order to resolve the issue the dll needs to be re-registered using Regsvr32.exe.


Regsvr32.exe “C:\Program Files\Microsoft SQL Server\80\Tools\Binn\DTSPkg.dll