Visual Studio 2013

Question

How can I create a new SSAS, SSIS, or SSRS project?  When I click on New Project, I don't see the options as the older VS version has.

---

newbie

Answer 1

Hi Ash,

You need to isntall the specific SSDT-BI for your VS2013.

Reference:

http://connect.microsoft.com/SQLServer/feedback/details/806079/ssdt-bi-add-visual-studio-2013-support-to-sql-server-data-tools-for-business-intelligence

Download:

http://www.microsoft.com/en-us/download/details.aspx?id=42313

Best Regards,

---

We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
Click HERE to participate the survey.

Answer 2

Thank you, Jack.

I'm using SQL 2012.  If I create projects with VS2013, would they work when deploy to SQL 2012?  or  do I need VS2012 or earlier version? 

---

newbie

Answer 3

@ Ash_,

You're welcome! J

I'm using SQL 2012.  If I create projects with VS2013, would they work when deploy to SQL 2012?  or do I need VS2012 or earlier version? 

As my understanding, it would have some limitations, for example, VS2013 SSIS projects can target only SQL Server 2014.

Reference:

http://blogs.technet.com/b/dataplatforminsider/archive/2013/11/13/microsoft-sql-server-data-tools-update.aspx

You know that one thread for one issue, if you really want to know more about it, you could post this issue to the SQL Server forum here like this thread:

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/home?category=sqlserver&filter=alltypes&sort=lastpostdesc

Best Regard,

---

We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
Click HERE to participate the survey.