O'Reilly logo

SQL Server 2017 Integration Services Cookbook by Dejan Sarka, Matija Lah, Christian Cote

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

There's more...

This simple recipe shows you how easily we can now use SSDT for Visual Studio 2015 with prior SSIS versions. If you open an existing SSIS project that is developed in the SQL Server 2012 or 2014 SSDT version, the designer (SSDT) will be smart enough to select the right target version (2012 or 2014) without upgrading your project or packages.

The default Target Server version is SQL Server 2016. If you created your SSIS project without setting this property and try to deploy it on a prior version to 2016, the deployment will fail. Also, if you change this property from, for example, SQL Server 2016 down to SQL Server 2014 and your package uses new SSIS functionality, the project won't build and therefore you will not be able ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required