Welcome to the official SSIS blog!

Hi all, welcome to this new official SSIS blog! We will be using this new blog site going forward to share information, tips and ideas about SSIS publicly here. We will keep the old blog site (http://blogs.msdn.com/b/mattm) alive but we will not posting to the old site anymore. Any new blog post will be done via…


ODBC is supported in SSIS on Linux (SQL Server 2017 CTP 2.1 refresh)

Dear all, We just announced SSIS on Linux CTP2.1 refresh, in this refresh,  besides many other improvements, we add a new feature which are queried by many customers during CTP2.1 – ODBC support. When the package is designed to use the ODBC connection, it will communicate with the ODBC driver manager and drivers installed on…


What’s New for SSIS 2016 RC0?

Hi all, The SQL Server 2016 RC0 will be out anytime soon. A preview for the SSIS community here Below is the specific improvements we added for RC0: SSIS Hadoop connector now supports ORC format. SSIS SSDT multi-version support targeting SQL versions 2012, 2014 and 2016 (One Designer) Below are some SSIS SSDT multi-version support…


Doing more with SQL Server Integration Services Feature Pack for Azure

More and more of businesses are either storing or manipulating some, if not all, of their data in the cloud. We learnt from our customers that they would prefer to leverage their existing on-premises ETL investment while seeking low cost solution to access and integrate data in the cloud. SQL Server Integration Services Feature Pack…


Error Column Improvements for SSIS Data Flow (Updated for RC2)

Most of the SSIS data flow components allow customers to log the rows with errors to a dedicated error output, which can help customers to investigate and diagnose the root cause of the error. Error output has two 4-byte int columns (ErrorCode and ErrorColumn), which indicate the error code and the id of the error column….


Using SSIS Scale Out to improve the performance of execution log writing

As you may already known, SSIS Scale Out is available in SQL Server vNext CTP1. it provides the capability to parallel package execution by distributing the execution to multiple machines. In addition, you can get better performance of execution log writing from SSIS Scale Out. For the user who is used to using verbose logging…



Hi all, I am pleased to announce that you can now download the SQL Server VNext CTP 1.0 to try out the SSIS Scale out feature and Dynamics AX/CRM Online OData Connector. https://msdn.microsoft.com/en-us/library/mt788653.aspx   I would like to hear from you directly if you have any feedback on the feature, especially about the Scale Out as…


Different approaches to inject data into Azure SQL Data Warehouse

Different approaches to inject data into Azure SQL Data Warehouse For the SQL Data Warehouse customers, the primary objective when migrating data is to populate their SQL Data Warehouse database. This process can be achieved in a number of ways, SQL Server Integration Services(SSIS) supports 3 different approaches to inject data into SQL Data Warehouse…


Validate XML with rich error output in the XML Task

  Validate XML documents and get rich error output by enabling the ValidationDetails property of the XML Task. For more info, see Validate XML with the XML Task in the SSIS documentation. SQL Server Integration Services (SSIS) introduced the ValidationDetails property in SQL Server 2012 Service Pack 2 in July of 2014. This new property was…


What’s New for SSIS 2106 CTP3.3

Hi all, See what’s new for SSIS 2016 CTP3.3: Download SQL Server 2016 CTP 3.3 is available today. http://blogs.technet.com/b/dataplatforminsider/archive/2016/02/03/technical-overview-sql-server-2016-community-technology-preview-3-3.aspx http://blogs.technet.com/b/dataplatforminsider/archive/2016/02/03/introducing-sql-server-2016-community-technology-preview-3-3.aspx   Below is the specific improvements we added for SSIS: Feature packs for Microsoft Connector for SAP BW, Attunity Oracle CDC Designer and Service, and Azure. ODBC source/destination; CDC control task; CDC source and splitter. SSIS Analysis…