Will Visual Studio 2013 Community version able to run a SSIS package?

Question

Hi guys

Will Visual Studio 2013 Community version able to run a SSIS package? Also what is the difference between free and the subsription version? We only use it to run a SSIS package, that is all we need to use it for.

Thank you very much!

Answer 1

Hi GTO28,

Nope the Express or community versions are not enterprise ready, a subscription is pay per use / year.

Luckily, you can get a 180 days SQL Server trial which will feature SSDT - a Vis Studio like tool you can use, or just buy a SQL Server Developer edition (last time I checked it was like $50 USD).

---

Arthur

MyBlog

Twitter

Answer 2

Hello,

You can download SSDT here: Download Latest SQL Server Data Tools; if no suitable Visual Studio exists, it will install VS (Integrated Shell).

---

Olaf Helper

[ Blog] [ Xing] [ MVP]

Answer 3

Hi GTO28,

To run SSIS package in VS, we should use Business Intelligence Development Studio (BIDS) or SQL Server Data Tools (SSDT) within SQL Server. But BIDS only support SSIS 2008 R2 and lower versions packages, SSDT only support SSIS 2012 packages. From SQL Server 2014, we need a separate download SSDT-BI for Visual Studio 2013 to develop and run SSIS packages.

Please note that the SSDT “BI” version is different than the standard SSDT or VS version, which does NOT include the BI templates. SQL Server Data Tools - Business Intelligence (SSDT-BI) for Visual Studio 2013 includes BI project authoring tools and project templates for: SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS).

The tools and templates integrate into a Visual Studio 2013 shell that is also installed. The previous generations of this toolset was known as SQL Server Business Intelligence Development Studio (BIDS). SSDT-BI, like BIDs leverages the Visual Studio Shell for the common design environment where the BI templates can be used.

To execute SSIS packages, we can just download and install free SQL Server 2014 Data Tools - Business Intelligence for Visual Studio 2013 separately. Then click an application with the same icon as Visual Studio called "SQL Server Data Tools for Visual Studio 2013" from All Programs group to open the development environment.

References:
Microsoft SQL Server Data Tools Update

If there are any other questions, please feel free to ask.

Thanks,
Katherine Xiong

---

Katherine Xiong
TechNet Community Support