SQL Server 2016 Integration Services (SSIS) –Summary of SQL Pass Summit 2015 session

During SQL Pass Summit 2015, Jimmy Wong (PM of SQL Server Integration Services) gave a session about the current and future improvements of Integration Services (SSIS).

If you follow my twitter account (@wstrasser) you maybe have seen the short announcements I sent during the session – here is the summary:

  • One of my favorite enhancements is incremental package deployment. You as an experienced SSIS developer may have also suffered from the fact that until SQL 2016 you had to deploy the whole SSIS project to SSIS catalog. Now this changes and incremental package deployment makes life easier (especially in hotfix situations where you only want to deploy that single package)
  • Always-On support for SSISDB
  • The name of the error column [ErrorColumnName] is now available. This makes error-handling or better said debugging easier.
  • Custom Logging Levels. Despite the four preconfigured logging levels you  can now define your own logging level (just think about a logging level “ErrorOnly”). Makes life easier!
  • A new role ssis_logreader is introduced (no need to be an admin or DBA to read SSIS execution reports). See these two blog-posts for more details (by @ssisjoost and @Ko_Ver)
  • Package Control Flow Templates. Wrap your reusable control flow objects into a template, reference the template and re-usability in SSIS starts. Configuration can be done easily. I had a first look on that concept – looks promising, but it is a V1 (so there is some place for improvements).
  • Automatic Buffersize handling – Let SSIS tune your buffers and set AutoAdjustBufferSize to true.  And in addition – MaxBufferSize can now get values up to 2G-1!!
  • Connectivity – many new sources are added to SSIS: Azure Connectivity, HDInsight, Hadoop and OnPremise sources
  • OData v4 support. There was a question during the session about what OData exactly is – here’s the according standard website and definition (cite www.odata.org: “An open protocol to allow the creation and consumption of queryable and interoperable RESTful APIs in a simple and standard way.”)
  • Support of multiple SSIS versions in ONE tool  (OneDesigner) – SSIS 2012, 2014 and 2016 will be supported. There was no timeline mentioned when this tool will be released. For current development see the SSDT download site.
  • Performance improvements of SSIS catalog views.

All in all it was a great session providing an overview about the new features of SSIS. Currently not all of them are available in the current CTP 3.0 and some of them (OneDesigner) will even not be available at SQL 2016 RTM timeframe.

Happy data integrating!




About wolfgang

Data Platform enthusiast
This entry was posted in Business Intelligence, SQL Server, SQL Server 2016, SSIS and tagged . Bookmark the permalink.

2 Responses to SQL Server 2016 Integration Services (SSIS) –Summary of SQL Pass Summit 2015 session

  1. Pingback: BI-NSIGHT – Power BI Desktop (Date Hierarchy) – Power BI(Timeline Slicer Visual, Pin Excel Range to Dashboard, Power BI User Groups, Weekly Service Update, Visual Studio Application Insights Content Pack) – Microsoft BI Reporting Road Map – SQL Se

  2. Nancy rai says:

    Great article, very detailed and well written.
    I have more SSIS package like SSIS Excel File Source/Destination, SSIS XML source, SSIS MongoDB Source/Destination, SSIS report generator its and Used all and it’s really much helpful and easy to use. There are lots of advantages of these all Package. Here I would like to share a SSIS Excel File Source. Feel free to see


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s