MsBuild Tasks are a set of two tasks available in the community project supported by Microsoft (project SSISMSBuild) and hosted on Codeplex. They aim to support the build of SSIS packages from MsBuild files. This a great way to automate the build of your packages without the need of Visual Studio (and so without licences issues). Unfortunately, this project has not been updated since 2010 but the source code is still available. It means that you need to update the dependencies and compile these tasks if you want to use it with SQL Server 2012, 2014 or 2016 (or vNext).
Download the solution and open it with Visual Studio:
To “upgrade” for SSIS 2016, open the solution with Notepad++ or any other text editor. Change the hint paths (not just once but all of them) to redirect to your version of Visual Studio:
- Visual Studio 11.0 = Visual Studio 2012
- Visual Studio 12.0 = Visual Studio 2013
- Visual Studio 14.0 = Visual Studio 2015
- Visual Studio 15.0 = Visual Studio 2017
Then, it’s time to update the references to SQL Server in the project. Check the path of the dll named
Microsoft.SqlServer.ManagedDTS. Keep in mind the following matches:
- v11 = SQL Server 2012
- v12 = SQL Server 2014
- v13 = SQL Server 2016
- v14 = SQL Server vNext
You also need to sign your build. Don’t panic it’s really easy. Open the properties of your project and create a new key:
You must update the target framework to be inline with the framework of SSDT … currently .NET framework 4.5.
Build and finally copy/paste your new dll to the directory
C:\Program files (x86)\Microsoft Visual Studio 14.0\Common7\IDE\PrivateAssemblies\ (If needed change the path to target the correct version of Visual Studio).
That’s it, you now have correct version of the MsBuild tasks for SSIS, in a next blog post, I’ll explain how to use it.