我已经查看了这个网址:如何使用SSIS包循环遍历Excel文件并将它们加载到数据库中,我按照里面提到的步骤操作,但是我收到了以下警告:
并且出现了这个错误:
[Excel Source [14]] Warning: The external columns for component
"Excel Source" (14) are out of synchronization with the data source
columns. The column "state" needs to be added to the external columns.
The external column "state " (27) needs to be removed from the external
columns.
并且出现了这个错误:
[SSIS.Pipeline] Error: "component "Excel Source" (14)" failed validation
and returned validation status "VS_NEEDSNEWMETADATA".