要在 SQL Server Data Tools 之外运行 SSIS 包，您必须安装 Move File to Archive of Integration Services 或更高版本 [英] To run a SSIS package outside of SQL Server Data Tools you must install Move File to Archive of Integration Services or higher

问题描述

我正在测试从 VS2005 项目升级到 VS2013(包部署模型)项目的 SSIS 包.这是一个非常简单的包，它只是从特定位置一个一个地处理文件，并根据这些文件更新数据库，一旦完成，它就会根据结果将文件移动到存档或非解析目录.我遇到了奇怪的错误，我找不到解决方案.

I am testing SSIS package that I upgraded from VS2005 project to VS2013 (package deployment model) project. This is very simple package which just processes files one by one from specific location and updates database based on those files and once done it moves file to archive or non-parsing directory based on outcome. And I am getting odd error and I cant find solution for that.

问题是我的包运行良好，它完全按照预期执行(从文件中提取数据并插入到表中).但此操作的一部分是将文件移动到存档(文件系统任务).我收到此错误说明:要在 SQL Server Data Tools 之外运行 SSIS 包，您必须安装将文件移动到集成服务存档或更高版本."

Issue is my package runs fine and it does exactly what it suppose to do (extracting data from file and inserting into table). But part of this operation is to move file to archive (file system task). And I am getting this error "Description: To run a SSIS package outside of SQL Server Data Tools you must install Move File to Archive of Integration Services or higher."

我在 2014 年使用 VS2013 和 SSDT BI，SSIS 设计器版本与我的开发测试 VM(12.0.2000.8 x64 位)中的 dtexec 实用程序匹配.以下是 CLI 的输出.

I have used VS2013 with SSDT BI for 2014 and SSIS Designer version matches with dtexec utility in my dev test VM (12.0.2000.8 x64 bit). Below is output from CLI.

Microsoft (R) SQL Server 执行包实用程序64 位版本 12.0.2000.8版权所有 (C) 微软公司.保留所有权利.

Microsoft (R) SQL Server Execute Package Utility Version 12.0.2000.8 for 64-bit Copyright (C) Microsoft Corporation. All rights reserved.

开始时间:上午 10:45:58进展:2016-02-11 10:45:59.20来源:截断 StagingTable正在执行查询TRUNCATE TABLE StagingTable".:100% 完成结束进度进展:2016-02-11 10:45:59.25来源:插入登台执行查询exec dbo.staging @xml_fileName,NULL,'C...".:100％ 完全的结束进度进展:2016-02-11 10:45:59.25来源:移至 MasterXML正在执行查询exec dbo.insertXML".:100% 完成结束进度错误:2016-02-11 10:45:59.25代码:0xC000F427来源:将文件移动到存档描述:要在 SQL Server Data Tools 之外运行 SSIS 包，您必须安装 Move File to Archive of Integration Services 或更高版本.结束错误进展:2016-02-11 10:45:59.30来源:执行 SQL get_next_file正在执行查询exec get_next_file".:100% 完成结束进度进展:2016-02-11 10:45:59.51来源:执行 SQL notify_users正在执行查询exec notify_users".:100% 完成结束进度DTExec:包执行返回 DTSER_SUCCESS (0).开始时间:上午 10:45:58完成:上午 10:45:59已用时间:1.172 秒

Started: 10:45:58 AM Progress: 2016-02-11 10:45:59.20 Source: Truncate StagingTable Executing query "TRUNCATE TABLE StagingTable".: 100% complete End Progress Progress: 2016-02-11 10:45:59.25 Source: Insert into Staging Executing query "exec dbo.staging @xml_fileName,NULL,'C...".: 100 % complete End Progress Progress: 2016-02-11 10:45:59.25 Source: Move to MasterXML Executing query "exec dbo.insertXML".: 100% complete End Progress Error: 2016-02-11 10:45:59.25 Code: 0xC000F427 Source: Move File to Archive Description: To run a SSIS package outside of SQL Server Data Tools you must install Move File to Archive of Integration Services or higher. End Error Progress: 2016-02-11 10:45:59.30 Source: Execute SQL get_next_file Executing query "exec get_next_file".: 100% complete End Progress Progress: 2016-02-11 10:45:59.51 Source: Execute SQL notify_users Executing query "exec notify_users".: 100% complete End Progress DTExec: The package execution returned DTSER_SUCCESS (0). Started: 10:45:58 AM Finished: 10:45:59 AM Elapsed: 1.172 seconds

最新努力，我在尝试运行此程序包的同一台机器上安装了 VS2013 和 SSDT BI for SQL Server 2014.如果我使用 VS，程序包运行良好，但是一旦我尝试使用以下命令通过 CLI 运行此程序包，它仍然会失败并显示相同的消息，

In latest effort, I installed VS2013 and SSDT BI for SQL Server 2014 in same machine where I am trying to run this package. And if I use VS, package runs fine but as soon as I try to run this package over CLI with following command it still fails with same message,

"C:\Program Files\Microsoft SQL Server\120\DTS\Binn\dtexec.exe"/f "C:\SSIS\Load_Files.dtsx"/ConfigFile "C:\SSIS\loadFiles_SSIS_Configuration.dtsconfig"

我确信它与 SSIS 在 VS2005 到 VS2013 中的工作方式有关，但只是不知道在哪里看.有什么建议吗?

I am sure it has something to do about how SSIS works in VS2005 to VS2013 but just don't know where to look. Any suggestions ?

推荐答案

只是为了给未来的访问者一些东西看看，就我而言，问题是我在同一台机器上安装了两个不同版本的 SSIS.一个是 2005 年，另一个是 2014 年.奇怪的是，即使我在我的命令中明确指出更新版本(如帖子的后面部分所示)，它也总是使用旧版本.

Just to give future visitors something to look on, in my case issue was I had two different version of SSIS installed on same machine. One was for 2005 and another for 2014. And oddly enough even I was explicitly pointing to newer version (as shown in later part of post) in my command, it was always using old version.

一旦我有一个干净的系统，只有 SQL Server 2014 (& SSIS) 相同的包运行没有任何问题.因此，它似乎存在某种限制，不允许在同一台机器上运行两个不同版本的 SSIS.

Once I had clean system with just SQL Server 2014 (& SSIS) same package ran without any issue. So it appears a limitation of some sort which doesn't allow to run two different versions of SSIS on same machine.

这篇关于要在 SQL Server Data Tools 之外运行 SSIS 包，您必须安装 Move File to Archive of Integration Services 或更高版本的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！