SSIS 错误 - 包中的版本号无效

Question

失败作业对应的日志如下:

04/11/2014 06:40:00,LPR_New,Error,0,USPHND0088,LPR_New,(Job outcome),,The job failed. The Job was invoked by Schedule 14 (LPR_New_Job). The last step to run was step 1 (Upload Material).,00:00:00,0,0,,,,0

04/11/2014 06:40:00,LPR_New,Error,1,USPHND0088,LPR_New,Upload Material,,Executed as user: nestle\ussqldbserver. ...00.5324.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved.
Started: 6:40:00 AM Error: 2014-04-11 06:40:00.39 Code: 0xC001700A Source: Description: The version number in the package is not valid. The version number cannot be greater than current version number. End Error Error: 2014-04-11 06:40:00.39
Code: 0xC0016020 Source: Description: Package migration from version 3 to version 2 failed with error 0xC001700A "The version number in the package is not valid. The version number cannot be greater than current version number.". End Error Error: 2014-04-11 06:40:00.39 Code: 0xC0010018 Source: Description: Error loading value "3" from node "DTS:Property". End Error Could not load package "\usphnd0088\dataxfer\LPR\LPR New\UploadMaterial.dtsx" becau... Process Exit Code 5. The step failed.,00:00:00,0,0,,,,0

Answer 1

您是否检查过项目文件是在哪个版本的 BIDS 中构建的？当 sql server 代理的版本与用于构建 SSIS 包所在项目的版本不同时，就会发生这种情况。

建议在与用于运行作业的服务器代理相匹配的正确版本的 BIDS 中重建项目。另一种选择是设置要使用的 DTEXEC 文件的位置/路径(取决于您使用的版本)。

引用文献 : MSDN /Package migration from version 3 to version 2 failed with error 0xC001700A. The version number in the package is not valid. The version number cannot be greater than current version number .