SSIS错误
遇到一个奇怪的问题,用SSIScopy文件并改名,然后导入数据。如果预选创建好文件,导入没问题,但是如果没文件,就会报错。我设计的流程是 copy创建文件---导入数据,走逻辑上来说事先应该会创建好文件,事实上如果把导入数据的节点禁用运行能成功,如果不禁用...就是这下面的错误,哪位帮忙看下,在此谢过。
标题: Package Validation Error
------------------------------
Package Validation Error
------------------------------
其他信息:
Error at Data Flow Task [Excel Destination [61]]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E37.
Error at Data Flow Task [Excel Destination [61]]: Opening a rowset for "Excel_Destination" failed. Check that the object exists in the database.
Error at Data Flow Task [SSIS.Pipeline]: "component "Excel Destination" (61)" failed validation and returned validation status "VS_ISBROKEN".
Error at Data Flow Task [SSIS.Pipeline]: One or more component failed validation.
Error at Data Flow Task: There were errors during task validation.
(Microsoft.DataTransformationServices.VsIntegration)
------------------------------
------解决方案--------------------不懂,我帮楼主把贴顶上去,等高手。
------解决方案--------------------问题解决,原因是组建有个属性delayvalidation,这个地方默认是false,改成True就成了,作用似乎是让程序等执行到具体组件时候才判断相对应的参数值