Fix: DTS Designer Disappears After SP3 Upgrade

If the Data Transformation Service (DTS) Designer unexpectedly disappeared after you upgraded to SQL Server 2000 Service Pack 3 (SP3), Microsoft has a fix for you.

ITPro Today

April 23, 2003

1 Min Read
ITPro Today logo in a gray background | ITPro Today

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

Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.

You May Also Like