ssis 2010 visual studio

Question

Right now I want to work with an SSIS package that was written in 2010. On my workstation, I have bids installed for visual studio 2008. I also have visual studio 2012 on my workstation to obtain C# programming code. I am also told that I should be able to look at an SSIS package written in 2010  while working with visual studio 2012.

Thus I have the following questions:
1. What do I need to obtain from the Visual studio 2012 install so that I can look at the ssis 2010 package? Where would I obtain this portion of the install package that I am missing?
2. If I want to obtain the visual studio 2010 environment to work with SSIS 2010 package, where would I obtain this donwload from the MSDN site?

Answer 1

For SSIS 2012 you can either use Visual Studio 2010 Shell (SSDT) which is included on the DVD/ISO or you could download Microsoft SQL Server Data Tools - Business Intelligence for Visual Studio 2012 so that you can open the SSIS project in Visual Studio 2012.

BIDS/Visual Studio 2008 is only for SSIS 2008, not 2012.

---

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

Answer 2

Matt Masson has a nice blog post about what development environment supports what version of SSIS: http://www.mattmasson.com/2013/10/sql-server-data-tools-business-intelligence-downloads/

You may need the templates installed by getting SSDT-BI 2012 for Visual Studio 2012 The links are in the blog post, too.

Re #2: SSIS 2012 packages get edited in SSDT2010 aka VS 2010 shell, there is no SSIS 2010. It is not a free tool (Visual Studui). It would be possible to search within your MSDN. SQL Server installation has SSDT only.

---

Arthur My Blog