SQL Server Data Tools Preview update for September 2015

Today we announce the latest preview of SQL Server Data Tools (SSDT). The September preview update provides new feature support in SQL Server 2016 CTP2.4, Azure SQL Database and multiple languages in Visual Studio 2015.

Who can benefit from using the Preview?

• SQL Server 2016 CTP2.4 database developers who would like to try the new CTP features.
• Azure SQL Database developers with the latest GA and Preview features.
• Database developers who would like to install Chinese, French, Italian, Japanese, Korean, Portuguese, Russian or Spanish version of SSDT in Visual Studio 2015.

Get it here:

Download SSDT September 2015 Preview for Visual Studio 2015 and Visual Studio 2013

• The version number for the latest preview in Visual Studio 2015 is 14.0.50927
• The version number for the latest preview in Visual Studio 2013 is 12.0.50927

Download Data-Tier Application Framework September 2015 Preview

• The version number for the latest preview of DacFx is 13.0.3086.1

What’s New in SSDT and DacFx?

• New feature support in SQL Server 2016 CTP2.4
• Multiple language support for SSDT in Visual Studio 2015

Contact Us

If you have any questions or feedback, please visit our forum or Microsoft Connect page.  We are fully committed to improve the SSDT experience and look forward to hearing from you!

Comments

• Anonymous
  October 04, 2015
  Hi there In which release is Windows 7 compatibility planned for SQL Server Data Tools? I think this is a big wish, whereas many companies use Windows 7 as default OS. Thank you for your answer.

• Anonymous
  October 06, 2015
  SSDT-BI? Anyone at MS listening? Bueller? Bueller?

• Anonymous
  October 06, 2015
  I did install SSDT 2015 in Visual Studio 2015 Enterprise edition, but when i don't see any Project Template for create Business Intelligence Project. Any pointer?

• Anonymous
  October 06, 2015
  Error when creating or opening an Integration Services Project in SQL Server Data Tools 2015: =================================== Method not found: 'Microsoft.SqlServer.Dts.Runtime.NameCheckResult Microsoft.SqlServer.Dts.Runtime.NameChecker.ValidateStreamName(System.String)'. (Microsoft Visual Studio)

---

Program Location:   at Microsoft.DataTransformationServices.Project.DataTransformationsProjectManager.CreateFileProjectNode(IFileProjectNode& parentNode, Int32 fileProjectNodeType, String name, String fullPath, Int32 createFileProjectNodeContext, Int32 contextOptions)   at Microsoft.DataTransformationServices.Project.DataTransformationsProjectLoader.ConstructProjectParameterNode(IFileProjectNode rootNode)   at Microsoft.DataTransformationServices.Project.DataTransformationsProjectLoader.ConstructProjectHierarchyFrom(ProjectSerialization projectSerialization)   at Microsoft.DataTransformationServices.Project.DataTransformationsProjectLoader.Deserialize(TextReader reader)   at Microsoft.DataWarehouse.VsIntegration.Shell.Project.Serialization.BaseProjectLoader.Load(IFileProjectHierarchy projectHierarchy)   at Microsoft.DataWarehouse.VsIntegration.Shell.Project.FileProjectHierarchy.Load(String pszFilename, UInt32 grfMode, Int32 iReadOnly)

• Anonymous
  October 07, 2015
  We also cannot use the B.I. tools with Visual Studio 2015 because our company standard is Windows 7.  Please consider compatibility with this O.S. Thanks.  :~]

• Anonymous
  October 07, 2015
  when can we expect SSDT suppot for PDW Database Projects.? Currently we can create Database Projects for SQL Server Databases, but not PDW Databases.

• Anonymous
  October 07, 2015
  Receiving the same NameCheckResult-error as Dan above. I can't use SSDT right now... TITLE: Microsoft Visual Studio

---

Error creating package

ADDITIONAL INFORMATION: Method not found: 'Microsoft.SqlServer.Dts.Runtime.NameCheckResult Microsoft.SqlServer.Dts.Runtime.NameChecker.ValidateStreamName(System.String)'. (Microsoft.DataTransformationServices.VsIntegration)

BUTTONS: OK

• Anonymous
  October 07, 2015
  The current build only includes SSIS projects. When do you expect to have a release supporting full BI functionality for Visual Studio 2015?

• Anonymous
  October 07, 2015
  Also receiving the same NameCheckResult-error as Dan and Dennis above

• Anonymous
  October 08, 2015
  NameCheckResult +1 (MS MVP)

• Anonymous
  October 09, 2015
  NameCheckResult +1 and can not find a resolution anywhere

• Anonymous
  October 09, 2015
  Model.xml file that is generated in SQL Server Data Tools projects is HUGE.  In one project, we have a 400+ MB model.xml file, and another is generating a 900+ MB file. The majority of it is from the XML tag <Annotation Type="SqlInlineConstraintAnnotation" /> repeated millions of times. This seems like a big bug.  It is doing it in the non-preview version as well.

• Anonymous
  October 12, 2015
  Same namecheck issue as others. Load failed for SSIS projects in solution, and SSAS/SSRS are incompatible.

• Anonymous
  October 12, 2015
  When can we expect SSDT BI for SSRS development support in Visual Studio 2015 (for SQL 2008R2 and SQL2012)???

• Anonymous
  October 13, 2015
  NameCheckResult +1

• Anonymous
  October 13, 2015
  And leaving any feedback on the connect page is just HORRIBLE.

• Anonymous
  October 14, 2015
  Not knowing when you can have SSRS support or like others are asking for other support to be released is one. But getting no feedback is very bad.

• Anonymous
  October 14, 2015
  Same error Method not found: 'Microsoft.SqlServer.Dts.Runtime.NameCheckResult Microsoft.SqlServer.Dts.Runtime.NameChecker.ValidateStreamName

• Anonymous
  October 15, 2015
  When will be the support for Reporting services will be included in SSDT for VS 2015???? We have moved all our solutions to VS 2015...but just for Reporting services we are keeping VS 2012.... When is the expected release?

• Anonymous
  October 15, 2015
  The comment has been removed

• Anonymous
  October 15, 2015
  The comment has been removed

• Anonymous
  October 16, 2015
  @Eric S. Kang +1 for NameCheckResult with SQL Server 2016 CTP2.4 installed

• Anonymous
  October 16, 2015
  The comment has been removed

• Anonymous
  October 20, 2015
  Same boat here, under windows 10, SQL2016CTP installed (just the management studio though), trying to load a SQL2012 package with the Sept 2015 SSDT fully loaded, and I get the same error.

• Anonymous
  October 21, 2015
  Receive same error as many other upon creating SSIS project in VS 2015:

---

Method not found: 'Microsoft.SqlServer.Dts.Runtime.NameCheckResult Microsoft.SqlServer.Dts.Runtime.NameChecker.ValidateStreamName(System.String)'.

Running

• Win 10
• Report Builder 2016 CTP 2.4
• VS 2015 (14.0.23107.0) Solution is highly requested :)

• Anonymous
  October 22, 2015
  Well, it gets worse :) I can't even create a new blank SSIS package without getting our "Method not found" error.

• Anonymous
  October 23, 2015
  The comment has been removed

• Anonymous
  October 24, 2015
  This is a known issue when CTP 2.4 and SSDT 2.4 are installed SXS on the same machine.  It is fixed in CTP3.  CTP3 works SXS on the same machine with both SSDT 2.4 and SSDT 3.0.

• Anonymous
  October 26, 2015
  I installed both Visual Studio 2015 and SSDT 2015.  But there is no template for Business Intelligence. I want to open Integration Services packages.

• Anonymous
  October 26, 2015
  @Janine - It's great that it's been fixed but where do we get it from?  I'm not able to work on my projects currently.

• Anonymous
  October 27, 2015
  The comment has been removed

• Anonymous
  October 27, 2015
  Edit: To clarify, I removed the entire SQL Server Express 2016 with Advanced Services package, not just Management Studio, as my former post indicates. Everything else I wrote is accurate.

• Anonymous
  October 27, 2015
  Edit: SSDT July 2015 RTM == version 14.0.507-somethin. removed. SSDT September 2015 == version 14.0.50927.0. works.