我可以部署 &在没有安装 SQL Server 2008 的机器上使用 SSIS SQL 服务器 DTS DLL 吗? [英] Can I deploy & Use SSIS SQL server DTS DLL's onto a machine that does not have SQL server 2008 installed?

问题描述

问好.我开发了一些 SSIS 包，我想在 C# 代码中加载和执行这些包.C# 代码部署在我们的应用程序机器上.我在我的 C# 项目中引用了 SQLServer.ManagedDTS DLL.

Greets. I've developed some SSIS packages that I want to load up and execute in C# code. The C# code is deployed on our application machine. I've referenced the SQLServer.ManagedDTS DLL in my C# project.

我尝试在我们的登台应用程序框上编译该 DLL，顺便说一句，这似乎也需要对 SQLServer.DTSRuntimeWrap DLL 进行编译.

I tried gac'ing that DLL on our staging application box, which incidentally also seemed to require gac'ing the SQLServer.DTSRuntimeWrap DLL as well.

执行包的代码是这样的

Runtime.Package package = new Runtime.Application().LoadPackage(ssisPackageFilePath, null);
package.Variables["FilePath"].Value = sourceFilePath;
//Excute Package to insert data from source csv file into a SQL table
Runtime.DTSExecResult results = package.Execute();

当我尝试运行该进程时，出现以下错误

When I try to run the process I get the following error

An Integration Services class cannot be found. 
Make sure that Integration Services is correctly installed on the computer that is running the application. 
Also, make sure that the 64-bit version of Integration Services is installed if you are running a 64-bit application

我想我应该能够简单地 gac(安装)我用来开发执行 SSIS dtsx 包文件的代码的一个 DLL.

I figured I should be able to simply gac (Install) the one DLL I used to develop the code that executes an SSIS dtsx package file.

我在 Visual Studio 2008 BIDS 项目中开发了该包，该项目生成了 dtsx 文件.我在 Visual Studio 2010 项目中引用了 SqlServer.ManagedDTS DLL 来从代码执行 dtsx 文件.本地测试和调试成功.

I developed the package in a Visual studio 2008 BIDS project which results in a dtsx file. I referenced the SqlServer.ManagedDTS DLL in a visual studio 2010 project to execute the dtsx file from code. Tested and debugged locally with success.

我需要做什么来设置我的应用程序框，以便我的代码能够执行 SSIS 包?

What do I need to do to setup my application box in order for my code to be able to execute an SSIS package?

我希望我不限于只能在安装了 SQL Server 或 IntegrationServices 实例的机器上从代码执行包；这可能意味着需要另一个许可证.

I'm hoping I'm not limited to only being able to execute packages from code on a box that has an instance of SQL server or IntegrationServices installed; which may mean the need for another license.

我需要在我的应用程序盒上安装集成服务吗?

Do I need to install Integration Services on my app box?

推荐答案

是的，您需要安装 Integration Services 才能在服务器上运行包.仅将 DLL 部署到 GAC 中并不能帮助执行包.

Yes, you need to install Integration Services to run the package on a server. Just deploying DLLs into GAC won't help in executing a package.

这是描述运行的MSDN链接以编程方式在远程计算机上的 SSIS 包.

Here is the MSDN link that describes about Running an SSIS Package Programmatically on a Remote Computer.

您需要至少安装一台带有集成服务的服务器才能执行 MSDN 文章中描述的操作.

You need to have at least one server with Integration Services installed to be able to do what the MSDN article describes.

这篇关于我可以部署 &在没有安装 SQL Server 2008 的机器上使用 SSIS SQL 服务器 DTS DLL 吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！