BLOGS BY TOPIC
BLOGS BY AUTHOR
BLOGS BY YEAR
This blog summarises the main new features of SQL Server for non-administrators (that is, most of us). Most parts of SQL Server get minor changes at best, but SSAS Tabular 2017 gets a host of major improvements.
- What's new in SQL Server 2017 (differences versus 2016)
- Changes to SQL Server 2017 installation
- What's new in the T-SQL language in SQL Server 2017
- What's new in Integration Services 2017 (SSIS 2017) (this blog)
- What's new in Reporting Services 2017 (SSRS 2017)
- What's new in Analysis Services 2017 (SSAS 2017)
Posted by Andy Brown on 23 January 2018
You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.
What's new in Integration Services 2017 (SSIS 2017)?
Virtually nothing! For the average user nothing has changed:
Script tasks and script components now use a different version of C# / VB (that's the only difference I can find!).
Here is a summary of the changes from the Microsoft SSIS 2017 update website:
Like I said, for the average user nothing has changed!
So to pad out this page, here are the top three things I'd like to see in SSIS 2018:
| Change | Notes |
|---|---|
| Parameter mapping | Make it easier to specify parameter mapping to SQL commands in the Execute SQL task dialog box. |
| Separate loop tasks | Create separate tasks for looping over files, rows, etc, and make each of these individual tasks then easier to configure. |
| Separate file/folder tasks | Separate the File System Task into file tasks and folder tasks, and then make each dialog box easier to use. |
One can but dream ...
- What's new in SQL Server 2017 (differences versus 2016)
- Changes to SQL Server 2017 installation
- What's new in the T-SQL language in SQL Server 2017
- What's new in Integration Services 2017 (SSIS 2017) (this blog)
- What's new in Reporting Services 2017 (SSRS 2017)
- What's new in Analysis Services 2017 (SSAS 2017)