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.
Rich XML validation output in the XML Task
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.