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!