问题描述
失败作业对应的日志如下:
The logs corresponding to the failed job are as follows:
04/11/2014 06:40:00,LPR_New,Error,0,USPHND0088,LPR_New,(作业结果),,作业失败.作业由附表 14 调用(LPR_New_Job).运行的最后一步是第 1 步(上传材料).,00:00:00,0,0,,,,0
04/11/2014 06:40:00,LPR_New,Error,1,USPHND0088,LPR_New,UploadMaterial,,作为用户执行:nestle\ussqldbserver....00.5324.00 为32 位版权 (C) Microsoft Corp 1984-2005.保留所有权利.
开始时间:上午 6:40:00 错误:2014-04-11 06:40:00.39 代码:0xC001700A 来源:描述:版本号包无效.版本号不能大于当前版本号.结束错误错误:2014-04-11 06:40:00.39
代码:0xC0016020 来源:描述:包迁移自版本 3 到版本 2 失败，错误为 0xC001700A版本包裹中的号码无效.版本号不能大于当前版本号.".结束错误错误:2014-04-1106:40:00.39 代码:0xC0010018 来源:描述:错误从节点加载值3"DTS:属性".结束错误无法加载包"\usphnd0088\dataxfer\LPR\LPR New\UploadMaterial.dtsx" 因为...Process Exit Code 5. 步骤失败.,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
推荐答案
您是否检查过项目文件内置的 BIDS 版本?当 sql server 代理的版本与用于构建 SSIS 包所在项目的版本不同时，就会发生这种情况.
Have you checked what version of BIDS the project file was built in? This happens when the sql server agent's version is different from the one used to build the project that the SSIS package lives in.
建议使用与用于运行作业的服务器代理相匹配的正确版本的 BIDS 重建项目.另一种选择是设置您要使用的 DTEXEC 文件的位置/路径(取决于您使用的版本).
There is a suggestion to rebuild the project in the correct version of BIDS that matches the server agent used to run the job. One other option is to set the location/path of the DTEXEC file you want to use (depending on which version you are using).
参考资料:MSDN/从版本 3 到版本 2 的包迁移失败，错误为 0xC001700A.包中的版本号无效.版本号不能大于当前版本号.
这篇关于SSIS 错误 - 包中的版本号无效的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！