TechNet
Export (0) Print
Expand All

What's New (Integration Services)

 

SQL Server 2014 Integration Services is unchanged from the previous release.

For information about other SQL Server 2014 products and technologies, see What's New in SQL Server 2014.

For more information about changes related to SQL Server Business Intelligence, see What's New in Analysis Services and Business Intelligence.

Validate XML documents and get rich error output by enabling the ValidationDetails property of the XML Task. Before the ValidationDetails property was available, XML validation by the XML Task returned only a true or false result, with no information about errors or their locations. Now, when you set ValidationDetails to true, the output file contains detailed information about every error including the line number and the position. You can use this information to understand, locate, and fix errors in XML documents. For more info, see Validate XML with the XML Task.

SSIS introduced the ValidationDetails property in SQL Server 2012 Service Pack 2. This new property was not announced or documented at that time. The ValidationDetails property is also available in SQL Server 2014 and in SQL Server 2016.

Features Supported by the Editions of SQL Server 2014

Show:
© 2016 Microsoft