TFS - SSIS

In my last blog post we built the process to build and deploy database models to each of our environments using ms-build.  https://sqljoel.wordpress.com/2017/06/30/tfs-team-foundation-server/

In my experience, SSIS hasn't been treated as cleanly in many organizations.  Many actually believe we can not use TFS to build and deploy or SSIS packages, but I am going to show you how.

One of the reasons we many believe SSIS can not be built and deployed with TFS is that we can not use the built in tools.  In order to build, we will use a command line build step and have to call the devenv.com, be sure visual studio is installed on your build box.  In this example for our arguments we will use our solution the /rebuild and /project switches.

Here are a few of the common command line switches:

• /build - build the specified solution configuration


• /project - specifies the project to build instead of solution must specify /build to use /project


• /projectconfig specifies project configuration to build must specify /project to use /projectconfig


• /out - write build output to specified file


• /rebuild - like /build but forces a clean first


• /clean - clean up build outputs


• /deploy build the specified solution configuration and then deploy it


• /run run the specified solution configuration


• /runexit run the specified solution configuration and then terminate


• /command executes the specified internal command line after startup


• /mditabs use tabbed documents interface


• /mdi use MDI interface


• /fn use specified font name


• /fs use specified font size


• /LCID use specified language ID


• /noVSIP disables VSIP developers license key for VSIP testing


• /safemode only default environment and services load for stability


• /resetskippkgs allow VsPackages once flagged for loading failures to
  load again

Once our SSIS Project has been built, we can easily deploy to our environments in the release step.  In our release, we will again need to use the command line step and call isdeploymentwizard.exe.  This time we will need the arguments /SP or SourcePath, /DS or Destination Server and I like to use the SSIS catalog so I will use /DP or DestinationPath.

If all your security is set up correctly, you should be done!  SSIS is now in TFS using builds and deploys.