sql - SSIS 验证失败并返回验证状态 "VS_ISBROKEN"

Question

我正在尝试创建一个临时表并使用临时表处理两个数据流。它在一个序列容器中，如果我只是执行容器，它运行得很好，但是当整个包运行时，它会返回此错误:

Information: 0x4004300A at V-AccidentCodesBase, SSIS.Pipeline: Validation phase is beginning.

Error: 0xC0202009 at V-AccidentCodesBase, Insert into Temp Table [69]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E14.

An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80040E14 Description: "Statement(s) could not be prepared.".

An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80040E14 Description: "Invalid object name '##TmpAccidentCode'.".

Error: 0xC004706B at V-AccidentCodesBase, SSIS.Pipeline: "Insert into Temp Table" failed validation and returned validation status "VS_ISBROKEN".

Error: 0xC004700C at V-AccidentCodesBase, SSIS.Pipeline: One or more component failed validation.

Error: 0xC0024107 at V-AccidentCodesBase: There were errors during task validation.

Answer 1

我会将 DelayValidation 属性设置为 True。您可能只需在 Sequence Container 上设置即可，或者您可能需要在子对象上重复该设置，例如您的数据流任务。