在编辑SQL作业时遇到问题

问题描述

我在SQL Server Agent中创建新作业时出现问题。



发布状态如下



使用CLSID创建COM组件的实例{AA40D1D6-CAEF-4A56-B9BB-D0D3DC976BA2}

由于以下错误导致IClassFactory失败：c001f01（Microsoft.SqlServer.ManagedDTS）





我使用的是SQl Server 2008 R2版本。



实际我的工作步骤包含

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

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.

推荐答案

这篇关于在编辑SQL作业时遇到问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！