Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Sql Maitenance Job Error

Answered Sql Maitenance Job Error

  • Friday, June 08, 2012 8:37 PM
     
     
    Sign In to Vote
    0

    Hi All,

    Whenever I am trying to create maintenace job I am seeing below error:

    Server Management Studio
    ------------------------------

    Exception has been thrown by the target of an invocation. (mscorlib)

    ------------------------------
    ADDITIONAL INFORMATION:

    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)

    ------------------------------

    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)

    NOTE:

    Whenever I am trying to view any exsisting Maintenance job I am seeing below errors.

    ===================================

    Value cannot be null.
    Parameter name: component (System.Design)

    Thanks, Nani.

     

All Replies

  • Monday, June 11, 2012 5:17 AM
    Answerer
     
     
    Sign In to Vote
    1
    Please tell us what version of SQL Server are you using? SELECT @@VERSION.

    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

     
  • Monday, June 11, 2012 6:14 AM
    Answerer
     
     Answered
    Sign In to Vote
    1

    Hi Nani_sql,

    >> 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)

    Regarding to the error message, seems related to the COM component creation failed. Its possible that the component on creation tries to communicate with that process which is terminating. Failure in this may have caused the above error. 
    For this issue, you can try to register COM in dts.dll location, and run the following from the command line: REGSVR32.EXE dts.dll.

    For more information, please refer to the replies and workaround from here.

    Meanwhile I'd suggest checking for an inner exception. Please use the InnerException to gets the Exception instance that caused the current exception. An instance of Exception that describes the error that caused the current exception.

    Regards, Amber zhang

     
  • Tuesday, June 12, 2012 11:40 AM
     
     
    Sign In to Vote
    0

    Hi Nani_sql

    below is the solution for this error

    RESOLUTION
     
    It turns out that the unregistered COM in dts.dll located in C:\Program Files\Microsoft SQL Server\90\DTS\binn. I ran the following from the command line:
     
    REGSVR32.EXE dts.dll
     

    in the aforementioned directory.

    you will have the complete reference from this below url

    http://geekswithblogs.net/NutAndBolts/archive/2008/06/06/sql_server_2005_event_id_208.aspx

    Jai Please click "Propose As Answer" if a post solves your problem or "Vote As Helpful" if a post has been useful to you