部署使用SQL Server Data Tools for Visual Studio 2012开发的SSIS包 [英] Deploy SSIS Packages developed using SQL Server Data Tools for Visual Studio 2012

问题描述

因此，我有一套使用Visual Studio 2008创建的SSIS软件包，目前已部署在SQL Server 2008R2实例上.但是，我想通过适用于Visual Studio 2012的SQL Server数据工具将它们升级到2012，这很容易，但是，我工作的公司没有任何计划将SQL Server很快升级到2012.因此，有一种方法可以使用SSIS 2012创建SSIS程序包并将其部署到SQL Server 2008R2实例，同时保留SSIS 2012程序包的所有新功能. IE Project连接管理器和程序包参数等...

So I have a suite of SSIS packages that we created using Visual Studio 2008 and are currently deployed on a SQL Server 2008R2 instance. However, I would like to upgrade these to 2012 via SQL Server Data Tools for Visual Studio 2012 which is easy enough, however, the company that I work for does not have any plans to upgrade the SQL Server to 2012 any time soon. So is there a way to create SSIS packages using SSIS 2012 and deploy them to a SQL Server 2008R2 instance while maintaining all of the new features of the SSIS 2012 package. IE Project Connection Managers and Package Parameters, etc...

推荐答案

不幸的是，没有. Integration Services Service是使软件包运行的引擎，必须将其安装在计算机上才能解释/运行它们.此外，除非计划从它们的.ispac容器运行程序包，否则您将无法利用其余的好东西"(例如环境)，至少不能不编写一些难看的exec调用.

Unfortunately, no. The Integration Services Service, the engine that which makes the package go, would have to be installed on the machine to be able to interpret/run them. Furthermore, unless you planned on running the packages from their .ispac containers, you wouldn't be able to take advantage of the rest of the "goodies" like the Environments, at least not without writing some ugly exec calls.

此外，如果您考虑将IS服务放到该包装盒上，那么我的理解是消耗了SQL Server许可证，并且鉴于2012年新的每核心许可模式很丑陋，因此我不乐意写这篇文章查看.不说您愿意这样做，只是当审核员停下来时，我在客户现场看到的一个令人头疼的事.

Also, if you think about slipping the IS services on that box, it is my understanding that's a SQL Server license consumed and given the ugliness that is the new per core licensing model on 2012, I wouldn't be happy writing that cheque. Not saying you'd do that, just a headache I saw at a client site when the auditors stopped by.

这篇关于部署使用SQL Server Data Tools for Visual Studio 2012开发的SSIS包的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！