无论如何要部署在 VS 2013 中构建的 SSIS 2012 项目?
首先，我喜欢非常清晰地描述了 SSIS 工具的版本.>:(
我为 Visual Studio 2013 安装了 SSDT BI，并在其中构建了一个不错的小项目来生成测试数据.在 VS 2013 中，我运行了数百次.我可以从 IDE 中部署它(右键单击项目...部署).但是我无法使用 .ispac 文件部署它.
I installed SSDT BI for Visual Studio 2013 and built a nice little project in it to generate test data. Within VS 2013, I ran this thing hundreds of times. I can deploy it from within the IDE (right click on project...deploy). However I can't deploy it using the .ispac file.
经过多次搜索，我发现 VS 2013 正在构建 SSIS 2014 .ispac 文件 (PackageFormat=8)，而这些文件不会部署到 SSIS 2012 服务器 (PackageFormat=6).
After much searching, I figured out that VS 2013 is building SSIS 2014 .ispac files (PackageFormat=8) and these won't deploy to a SSIS 2012 server (PackageFormat=6).
我的问题是，如果 VS 可以将 VS 2013 中内置的包部署到 SSIS 2012，有没有办法通过 .ispac 文件实现这一点?我无法部署到我的任何服务器(仅在本地)，因为我不在同一个域中(实际上，我在本地工作，不在域中).
My question is, if VS can deploy the package built in VS 2013 to SSIS 2012, is there a way to get this to happen via the .ispac file? I can't deploy to any of my servers (only locally), because I'm not in the same domain (actually, I'm working locally, outside of a domain).
是的 - 版本控制"很棒！不是.. 对此的简单答案是否定的，您不能在 Sql Server 2012 上使用 VS 2013 中内置的 SSIS 包-您可以部署并设置它等-但是您将获得版本 8 到版本 6 的废话..
Yeah - the 'versioning' is awesome! NOT.. The simple answer to this is NO, you cannot use a SSIS package built in VS 2013 on Sql Server 2012 - you can deploy is and set it up, etc - but you will get that version 8 to version 6 nonsense..
此链接 sql-server-data-tools-business-intelligence-for-visual-studio-2013-ssdt-bi 给你一张漂亮的图片，基本上说明VS 2013 您可以在 Sql Server 2008、2012 和 2014 上执行 SSRS 和 SSAS，但只能在 2014 年执行 SSIS ..
This link sql-server-data-tools-business-intelligence-for-visual-studio-2013-ssdt-bi gives you a pretty picture that basically states with VS 2013 you can do SSRS and SSAS on Sql Server 2008, 2012, and 2014 but SSIS only on 2014..
要将 SSIS 包部署到 SQL Server 2012，您需要从 VS 2010 或 2012 构建和部署...
To deploy SSIS packages to SQL Server 2012 you need to build and deploy from VS 2010 or 2012...
这是解释所有版本的页面 - 互操作性和共存(集成服务) 我试图发布个别链接 - 但我是新人，不允许...
Here is the page that explains all the versions - Interoperability and Coexistence (Integration Services) I tried to post the individual links - but I'm new and not allowed...
希望这会有所帮助 - 这让我发疯......
Hope this helps - this was driving me crazy...