I have SQL 2012 tools installed on my development workstation. If I upgrade and SSIS package to VS 2010 is it really a version for SQL 2012? It does not seem to have a version target as SSAS does. I want to make sure that if I hand off my SSIS it will be possible for the DBA team to deploy on SQL 2008 R2. I suspect it is upgraded to 2012 as the XML files has DTS:LastModifiedProductVersion="11.0.2100.60" in it at the top.

Hi Andy, I am moving your issue to the SQL Server Integration Services forum so that you can get better support. Thanks.Vicky Song [MSFT] MSDN Community Support | Feedback to us

I'm not sure if I understood your question exactly, But If you installed SSIS 2012 and you develop packages with SSDT then you cannot deploy them to SSIS 2008R2 or earlier, you need to deploy them to 2012. and SSDT for SQL Server 2012 is actually same VS 2010, just with BI project templates. http://www.rad.pasfu.com

Hi Andy Wilbourn, Visual Studio 2010 does not contain Business Intelligence Templates. We cannot deploy SSIS 2012 package to earlier version of SQL Server 2012, because 2012 would somehow be aware of 2008 structure, but earlier engine isn't aware of 2012 package structure. For more details about it, please see: http://msdn.microsoft.com/en-us/library/bb522577.aspx Thanks, Eilee TechNet Subscriber Support If you are TechNet Subscription user and have any feedback on our support quality, please send your feedback here.Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.