On some computers, you might run into problems with the DTS designer and the DTS wizard failing due to COM errors. These COM errors result primarily from conflicts with Visual Studio 6.0--and, more specifically, the comcat.dll.
You can resolve this problem by reregistering the c:\mssql7\binn\dtspkg.dll (replace c: with the letter of the drive on which you've installed SQL Server) and the c:\winnt\system32\comcat.dll files by using the regsvr32 utility. To reregister each DLL, use the following syntax:regsvr32 DLL_file_name.
Source: Willard Dyche
Viewed 5178 times