Error trying to display Properties is SSMS

  • When I try to view the step details of a job in SSMS,

    I get the following error :

    Creating an instance of the COM component with CLSID {E80FE1DB-D1AA-4D6B-BA7E-040D424A925C} from the IClassFactory failed due to the following error: c001f011. (Microsoft.SqlServer.ManagedDTS)

    :angry:

    Does anyone know how to fix this?? It's a problem with SSMS and not the job, as I can view the job on another remote SSMS session.

    _____________________________________________________________________________MCITP: Business Intelligence Developer (2005)

  • Try the following

    - Open a command prompt

    - goto \Program Files\Microsoft SQL Server\90\DTS\Binn- Type in regsvr32 dts.dll

    Failing that you may need to reinstalled the Management Tools.

    Rgds

    JL

  • Thanks JL - I've give it a go

    _____________________________________________________________________________MCITP: Business Intelligence Developer (2005)

  • That worked. Thanks again JL 😀

    _____________________________________________________________________________MCITP: Business Intelligence Developer (2005)

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply