If the Data Transformation Services (DTS) Designer unexpectedly disappeared after you upgraded to SQL Server 2000 Service Pack 3 (SP3), Microsoft has a fix for you. Because of an unhandled access violation, the DTS Designer and Enterprise Manager might both disappear after you upgrade to SP3. The supported fix, described in the Microsoft article "FIX: DTS Designer May Generate an Access Violation After You Install SQL Server 2000 SP3," is intended only for computers that are experiencing this problem. Microsoft notes that the fix might receive additional testing, so if you aren't severely affected by this problem, Microsoft recommends that you wait for the next SQL Server 2000 service pack that contains the fix.

   http://support.microsoft.com/default.aspx?scid=kb;en-us;814113