Visual Studio 2012 and SSIS 2012

Question

I recently downloaded and installed Visual Studio 2012.  I tried to open an SSIS package from SQL Server 2012.  It said that it was not supported in this version and open it in an older version.

Am I doing something wrong?  Can I work with SQL Server SSRS, SSIS or SSAS project in VS 2012?

Thanks for your help!

Answer 1

You have to install SSDT = SQL Server Data Tools to get the project types for VS 2012. You can get it with MS Web Platform Installer.

---

Olaf Helper
Blog Xing

Answer 2

Hi Bryan Shaw,

Microsoft Visual Studio 2010 does not support Business Intelligence Development Studio Integration Services, Report Services and Analysis Services projects, just as Olaf said, you need to download SQL Server Data Tools. For more details about the issue, please see the following KB:

You cannot open a Business Intelligence project after you upgrade the project to the format that is used by Visual Studio 2010: http://support.microsoft.com/default.aspx?scid=kb;en-us;983332

Thanks,
Eileen

 

---

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.

Answer 3

To make everything confusing: SQL Server Data Tools is hosted inside Visual Studio (or in a shell, not sure about that), so it looks like you're working with Visual Studio.

---

MCTS, MCITP - Please mark posts as answered where appropriate.

Answer 4

Sometimes I just LOVE Microsoft * tongue firmly inserted within cheek *  With all of your help, I was finally able to get it going.  Thanks!

Answer 5

Eileen, you mention VS 2010.  That version works just fine.  I was having trouble with VS 2012.

Answer 6

Hi Hi Bryan Shaw,

I am sorry for misread, visual studio 2012 is not support for SSAS,SSRS and SSIS, download SSDT is the only way. Someone have submit a feelback at the Microsoft Connect: https://connect.microsoft.com/SQLServer/feedback/details/759119/installing-sql-server-2012-developer-edition-does-not-install-a-bids-or-ssdt-project-capability-into-visual-studio-2012 . You can vote it as important if you need Visual Studio integrate with those BI features.

Thanks,
Eileen

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.

Answer 7

The SSDT available via the MS Web Platform Installer is for VS2010  is there a VS2012 version?

I am trying to use VS2012 to build and SSIS package.

-Ken

Answer 8

I don't think you can already build BI solutions with VS2012.

---

MCTS, MCITP - Please mark posts as answered where appropriate.

Answer 9

Koen:

Have you been able to verify this, i.e.:  Visual Studio 2012 is not yet ready for SSIS.

Thanks.

---

A. Wolf

Answer 10

Koen:

Have you been able to verify this, i.e.:  Visual Studio 2012 is not yet ready for SSIS.

Thanks.

---

A. Wolf

As far as I know VS2012 can't do BI projects yet.

Visual Studio 2012 does not support BI

Read the comments as well, they're useful.
Julie Strauss, member of the SQL Server team, says they are working on it, but a release date has yet to be determined.

http://social.msdn.microsoft.com/Forums/en-US/vssetup/thread/f800376f-c782-4500-8423-22fb1374cae4/

---

MCTS, MCITP - Please mark posts as answered where appropriate.

Answer 11

hapaSan,

the proper place to submit enchantments is MS Connect

---

Arthur My Blog

Answer 12

Download and install SSDT for VS 2012 from this link http://msdn.microsoft.com/en-us/jj650015

Answer 13

Download and install SSDT for VS 2012 from this link http://msdn.microsoft.com/en-us/jj650015

@mac.manoj: It's suite of tools for building SQL Server database solutions. See http://sqlblog.com/blogs/jamie_thomson/archive/2012/04/03/ssdt-what-s-in-a-name.aspx

---

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

Answer 14

I think this thread on Stack Overflow explains it quite well.

Answer 15

Today March 6, 2013, Microsoft released SQL Server Data Tools – Business Intelligence for Visual Studio 2012 (SSDT BI) templates. With SSDT BI for Visual Studio 2012 you can develop and deploy SQL Server Business intelligence projects. Projects created in Visual Studio 2010 can be opened in Visual Studio 2012 and the other way around without upgrading or downgrading – it just works.

The download/install is named to ensure you get the SSDT templates that contain the Business Intelligence projects. The setup for these tools is now available from the web and can be downloaded in multiple languages right here: http://www.microsoft.com/download/details.aspx?id=36843

This includes SSIS, SSAS, SSRS project types.

RS team blog: http://blogs.msdn.com/b/sqlrsteamblog/archive/2013/03/06/sql-server-data-tools-business-intelligence-for-visual-studio-2012-released-online.aspx

AS team blog: http://blogs.msdn.com/b/analysisservices/archive/2013/03/06/sql-server-data-tools-business-intelligence-for-visual-studio-2012-released-online.aspx

---

Didn't get enough help here? Submit a case with the Microsoft Customer Support team for deeper investigation - http://support.microsoft.com/select/default.aspx?target=assistance

Answer 16

Those of us running 64 bit can expect the installation to fail with a BlockMixedArchitectureInstall error. I presume I could let the installation create a new x86 sql instance, and perhaps it would also install a new x86 VisualStudio version with the SSDT BI templates. Not the most convenient outcome, but workable. How safe is that gamble?

Answer 17

Yes when the setup runs, Install a New instance to get it to work. I don't know about any long term side effects, but that is what I was told from the product teams who made it.

---

Didn't get enough help here? Submit a case with the Microsoft Customer Support team for deeper investigation - http://support.microsoft.com/select/default.aspx?target=assistance