我有一个SSIS包读取Excel文件(数据流源),并使用OLEDB目标数据流项目将数据传输到sql Server.用于目标的OLEDB连接管理器配置为使用Windows身份验证.包装在我的开发机器上工作正常.但是当我在另一台机器上打开相同的软件包并尝试执行它时,会在验证阶段出现以下错误
Error: 0xC020801C at DFT_NSOffers,Source – ‘Subscription Offers$’ 1 [347]: The AcquireConnection method call to the connection manager “ExcelConnection_NSOffers” Failed with error code 0xC0202009.
Error: 0xC0047017 at DFT_NSOffers,DTS.Pipeline: component “Source – ‘Subscription Offers$’ 1” (347) Failed validation and returned error code 0xC020801C.
Error: 0xC004700C at DFT_NSOffers,DTS.Pipeline: One or more component Failed validation.
Error: 0xC0024107 at DFT_NSOffers: There were errors during task validation
我使用sql Server 2005(版本 – 9.0.1399)
我该如何解决？我需要安装任何其他组件或服务包吗？
