10 Comments

  1. Wamiq Ansari

    Runing the command line build task for SSIS gave me the following error:
    Executing the following command-line. (workingFolder = C:\Agent1\_work\34\s)
    “C:\Program Files (x86)\Microsoft Visual Studio 14.0\Common7\IDE\devenv.com” “C:\Agent1\_work\34\s\xyz\xyz.sln” /rebuild “Development” /project “C:\Agent1\_work\34\s\xyz\abc\xyz.dtproj”
    Error message highlight pattern:
    Warning message highlight pattern:
    Microsoft Visual Studio 2015 Version 14.0.25420.1.
    Copyright (C) Microsoft Corp. All rights reserved.
    The following files were specified on the command line:
    “C:\Agent1\_work\34\s\xyz\xyz.sln”
    These files could not be found and will not be loaded.

    Solution:
    Removing the double quotes from the ‘Arguments’ parameter worked for me. I am also lucky that my solution path and project path does not contain any space characters. So instead of:
    “$(Build.SourcesDirectory)\SSDTDemo1\SSDTDemo1.sln” /rebuild $(BuildConfiguration) /project “$(Build.SourcesDirectory)\SSDTDemo1\Integration Services Project1\Integration Services Project1.dtproj”
    I used:
    $(Build.SourcesDirectory)\SSDTDemo1\SSDTDemo1.sln /rebuild $(BuildConfiguration) /project $(Build.SourcesDirectory)\SSDTDemo1\Integration Services Project1\Integration Services Project1.dtproj

    Hope this helps.

  2. Jon Davis

    Great article, thank you! Finding it turned out to be invaluable as based on it, I just tried using a hosted agent (Team Services) with the command line to build and it worked! Based on everything I had read, I thought I would be required to have an on-premise build agent.

    Question – You mentioned using separate release step for SSRS, can you explain what task type, etc. you use to accomplish deploying the reports?

    Thank you again!

    • Joe

      Unfortunately on the hosted agent (vsts) I get an error when trying to build my SSIS project:

      d:\a\1\s\xxx\xxx\xxx.dtproj : error : The application for the project is not installed.

      using “C:\Program Files (x86)\Microsoft Visual Studio 14.0\Common7\IDE\devenv.com” as the command line tool (the project is developed using VS2015).

      how did you make that work on your hosted agent?

  3. Can you let us know how to create a build vsts for ssis project if the project and packages are password protected? do we need to take backup consideratiosn while deploying to sqldb or ssis

  4. […] Build and Deploy SSIS packages using VSTS – Life According to Abel – Oct 6, 2016. SourcesDirectory)SSDTDemo1Report Project1Report Project1.rptproj”. Deployment.exe/dtutil.exe) to deploy SSAS/SSIS with the artifacts created. Runing the command line build task for SSIS gave me the following error: […]

Leave a Reply to abel Cancel reply

Your email address will not be published. Required fields are marked *