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