I have a package that is developed in SSIS 2012 using Visual Studio 2010.
我有一个使用Visual Studio 2010在SSIS 2012开发的软件包。
-
Is it possible to deploy/attach this package on SQL Server 2008
是否可以在SQL Server 2008上部署/附加这个包
-
If it is possible, does the licence of the sql server matter
如果可能，那么sql服务器的许可证很重要。
3 个解决方案
#1
24
no, you cant. SSIS package are not backwards compatible.
不,你不能。SSIS包不能向后兼容。
Also it doesn't make much sense if you think about it. If it was the other way around, "maybe" it could be done because 2012 would somehow be aware of 2008 structure, but 2008 engine isn't aware of 2012 package structure.
而且如果你仔细想想，这也没有多大意义。如果是反过来的话，“也许”可以这么做，因为2012年不知何故会意识到2008年的结构，但2008年的引擎却不知道2012年的包结构。
#2
9
You cannot run it with the 2008 version of dtexec and you certainly cannot deploy it into the catalog, but if you could install the minimum you need to run SSIS 2012 onto a server somewhere you could then execute the package from filesystem with the 2012 version of dtexec.
您不能使用2008年版本的dtexec来运行它，当然也不能将它部署到目录中，但是如果您可以将运行SSIS 2012的最低要求安装到服务器上，那么您就可以使用2012年版本的dtexec从文件系统中执行这个包。
See also http://msdn.microsoft.com/en-us/library/bb522577.aspx
参见http://msdn.microsoft.com/en-us/library/bb522577.aspx
#3
3
Best guess would be no. The engine to run the SSIS package would have to match the release level of the code. You have not been able to run any SSIS package on any release level below the developed level of the package (i.e. 2005 server will not run a 2008 package etc.)
最好的猜测是不会。运行SSIS包的引擎必须匹配代码的发布级别。您无法在包的开发级别以下的任何发布级别上运行任何SSIS包(例如，2005年服务器不会运行2008年的包等)。
It is not a license issue, it is an engine issue. The SSIS engine code changes with each release and therefore the code would be running in an engine that doesn't support the features or structure of the package.
这不是许可证问题，而是引擎问题。SSIS引擎的代码会随着每个版本而改变，因此代码将在一个不支持包的特性或结构的引擎中运行。
#1
24
no, you cant. SSIS package are not backwards compatible.
不,你不能。SSIS包不能向后兼容。
Also it doesn't make much sense if you think about it. If it was the other way around, "maybe" it could be done because 2012 would somehow be aware of 2008 structure, but 2008 engine isn't aware of 2012 package structure.
而且如果你仔细想想，这也没有多大意义。如果是反过来的话，“也许”可以这么做，因为2012年不知何故会意识到2008年的结构，但2008年的引擎却不知道2012年的包结构。
#2
9
You cannot run it with the 2008 version of dtexec and you certainly cannot deploy it into the catalog, but if you could install the minimum you need to run SSIS 2012 onto a server somewhere you could then execute the package from filesystem with the 2012 version of dtexec.
您不能使用2008年版本的dtexec来运行它，当然也不能将它部署到目录中，但是如果您可以将运行SSIS 2012的最低要求安装到服务器上，那么您就可以使用2012年版本的dtexec从文件系统中执行这个包。
See also http://msdn.microsoft.com/en-us/library/bb522577.aspx
参见http://msdn.microsoft.com/en-us/library/bb522577.aspx
#3
3
Best guess would be no. The engine to run the SSIS package would have to match the release level of the code. You have not been able to run any SSIS package on any release level below the developed level of the package (i.e. 2005 server will not run a 2008 package etc.)
最好的猜测是不会。运行SSIS包的引擎必须匹配代码的发布级别。您无法在包的开发级别以下的任何发布级别上运行任何SSIS包(例如，2005年服务器不会运行2008年的包等)。
It is not a license issue, it is an engine issue. The SSIS engine code changes with each release and therefore the code would be running in an engine that doesn't support the features or structure of the package.
这不是许可证问题，而是引擎问题。SSIS引擎的代码会随着每个版本而改变，因此代码将在一个不支持包的特性或结构的引擎中运行。