7 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?

Leave a Reply

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