SSIS and Visual Studio Versions

Question

Hi all

we are looking for renew our development environment for SSIS.

Actually we have SQL Server 2008 Enterprise R2 SP1, Visual Sutdio 2008 without any source code versioning software.

I was thinking to update it to Visual Studio 2012 with TFS 2012.

What is not clear for me is if SSIS packages developed under Visual Studio 2012 (SQL Server Data Tools - Business Intelligence for Visual Studio 2012) can be run under SQL Server 2008 R2 SP1.

Also I would like to know if SSIS packages can be versined with TFS like a cs file.

best regards

-g

---

Gian Paolo Santopaolo - softwarelab.it - thedarksideof.net
Disclaimer: This post is provided "AS IS" with no warranties, and confer no rights.

Answer 1

NO, you cant. SSIS package are not backwards compatible.

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.

YES, SSIS packages can be versined with TFS like a cs file

---

Thanks and Regards, Prajesh Please use Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

Answer 2

NO, you cant. SSIS package are not backwards compatible.

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.

YES, SSIS packages can be versined with TFS like a cs file

---

Thanks and Regards, Prajesh Please use Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

This should be possible though, in my opinion. You can save an Excel file in .xls format when using Excel 2013, so it's a bit annoying they can't do the same for BIDS. I now have 3 different development environments on my PC, each for a different version of SSIS.

---

MCSE SQL Server 2012 - Please mark posts as answered where appropriate.

Answer 3

as per MSDN

http://technet.microsoft.com/en-us/library/bb522577(v=sql.100).aspx

You can load and run packages that were developed in SQL Server 2005 Integration Services (SSIS) and SQL Server 2008 Integration Services (SSIS), in the SQL Server 2012 version of SQL Server Data Tools (SSDT). When you add the package to an existing project, the package is permanently upgraded to the format that SQL Server 2012 Integration Services (SSIS) uses. When you open the package file in SQL Server Data Tools (SSDT), the package is temporarily upgraded to the format that SQL Server 2012 Integration Services (SSIS) uses. If you save the change to the package, the package is permanently upgraded.

Once saved in the format that SQL Server 2012 Integration Services (SSIS) uses, packages can no longer be opened in the corresponding SQL Server 2005 or SQL Server 2008 version of Business Intelligence Development Studio, nor run by the corresponding SQL Server 2005 Integration Services (SSIS) or SQL Server 2008 Integration Services (SSIS) tools

---

Thanks and Regards, Prajesh Please use Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

Answer 4

Although it would be useful to run old version packages in newer versions of Visual Studio... it's not possible. Let's see what they will do with SQL/SSIS 2014...

SSIS and TFS work fine, but I would not recommend multiple checkout...

---

Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

Answer 5

Thank you all for your fast responses.

It's clear that I can't upgrade to 2012, is there a way to upgrade to VS2010 and TFS 2012 ?

best regards

-g

---

Gian Paolo Santopaolo - softwarelab.it - thedarksideof.net
Disclaimer: This post is provided "AS IS" with no warranties, and confer no rights.

Answer 6

Thank you all for your fast responses.

It's clear that I can't upgrade to 2012, is there a way to upgrade to VS2010 and TFS 2012 ?

best regards

-g

---

Gian Paolo Santopaolo - softwarelab.it - thedarksideof.net
Disclaimer: This post is provided "AS IS" with no warranties, and confer no rights.

Not without upgrading SSIS itself to SQL Server 2012.

---

MCSE SQL Server 2012 - Please mark posts as answered where appropriate.

Answer 7

SSIS 2008 only works with visual studio/BIDS 2008

SSIS 2012 works with visual studio/SSDT 2010 and 2012

TFS version should be no problem: http://www.microsoft.com/en-gb/download/details.aspx?id=29983

---

Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

Answer 8

Now all it's clear 

thank you all

-g

---

Gian Paolo Santopaolo - softwarelab.it - thedarksideof.net
Disclaimer: This post is provided "AS IS" with no warranties, and confer no rights.

Answer 9

So, what version of the Visual Studio shell (or Visual Studio itself) you MUST use is tied the version of SQL that will run the SSIS packages, correct?

1. SQL 2005, you can ONLY use VS 2005
2. SQL 2008, you can ONLY use VS 2008
3. SQL 2008 R2, you can ONLY use VS 2008
4. SQL 2012, you use VS 2010 OR VS 2012

Is the above correct?

Answer 10

Yes, that's correct.

---

MCSE SQL Server 2012 - Please mark posts as answered where appropriate.