代码之家  ›  专栏  ›  技术社区  ›  akkapolk

SSIS错误代码DTS\U E\U OLEDBERROR。发生OLE DB错误。错误代码:0x80040E14

  •  0
  • akkapolk  · 技术社区  · 7 年前

    为什么我不能在循环中使用相同的连接。你能帮帮我吗?我会解释所有步骤。

    步骤如下:

    1. “按品牌获取”块(执行SQL任务):我查询品牌数据,输出
    2. “Foreach Loop by All Brand”区块:通过第一轮循环。 第二轮循环不是。即使“Gen头文件” 块(数据流任务)与第一轮连接和 从第一轮开始,一切都是一样的。

    Second round of loop is error

    “Gen头文件”块的详细信息(数据流任务): The detail of "Gen Header file" block(Data Flow Task)

    The detail of "Gen Header file" block(Data Flow Task)

    Information: 0x4004300A at Gen Header file, DTS.Pipeline: Validation phase is beginning.
    Error: 0xC0202009 at Gen Header file, OLE DB Source revise [12072]: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80040E14.
    An OLE DB record is available.  Source: "Microsoft OLE DB Provider for Oracle"  Hresult: 0x80040E37  Description: "ORA-00942: table or view does not exist
    ".
    Error: 0xC004706B at Gen Header file, DTS.Pipeline: "component "OLE DB Source revise" (12072)" failed validation and returned validation status "VS_ISBROKEN".
    Error: 0xC004700C at Gen Header file, DTS.Pipeline: One or more component failed validation.
    Error: 0xC0024107 at Gen Header file: There were errors during task validation.
    Warning: 0x80019002 at Foreach Loop by All Brand: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED.  The Execution method succeeded, but the number of errors raised (5) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
    Warning: 0x80019002 at RP_PROD_SpareServer102002211: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED.  The Execution method succeeded, but the number of errors raised (5) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
    SSIS package "RPInStaySurvey.dtsx" finished: Failure.
    
    1 回复  |  直到 7 年前
        1
  •  0
  •   akkapolk    7 年前

    因为我在循环中多次使用相同的连接。所以,我将连接名称“RetainSameConnection”的属性设置为True(默认值为False)。问题解决了。

    推荐文章