Click here to Skip to main content
15,883,623 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
Hi,

I am getting an issue while creating a new job in SQL server Agent.

issue states like below

Creating an instance of the COM component with CLSID {AA40D1D6-CAEF-4A56-B9BB-D0D3DC976BA2}
from the IClassFactory failed due to the following error: c001f01(Microsoft.SqlServer.ManagedDTS)


I am using SQl Server 2008 R2 version.

actual my job step contains


SQL
SET NOCOUNT ON;
SET QUOTED_IDENTIFIER ON;


    DECLARE @Quoteid VARCHAR(50)

    DECLARE db_cursor CURSOR FOR

    Select QuoteID from quote with (nolock)
    where LOB=''claim'' and Deleted<>1
    and QuoteID not in (select QuoteID from claimsdata)

    OPEN db_cursor
    FETCH NEXT FROM db_cursor INTO @Quoteid

    WHILE @@FETCH_STATUS = 0
    BEGIN

     INSERT INTO ClaimsData
     SELECT * FROM Quote with (nolock) Where QuoteID=@Quoteid;


       FETCH NEXT FROM db_cursor INTO @Quoteid
    END

    CLOSE db_cursor
    DEALLOCATE db_cursor



Can you please me on this.

Thanks in advance.
Posted

1 solution

This is not a code issue but a technical issue. See http://support.microsoft.com/kb/2315727[^] for a fix from Microsoft.
 
Share this answer
 
Comments
Maciej Los 26-Dec-13 16:25pm    
10 shot!

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900