Search code examples
sql-serverdeploymentssissql-server-2014ssis-2014

Building SSIS 2014 Project deployment model from cmd line


Build SSIS 2014 Solution/project from cmd line is not working Used several scripts with no luck.

C:\Users\Source\Repos\ETL "C:\Program Files (x86)\Microsoft Visual Studio\2017\Enterprise\Common7\IDE\devenv.exe" 
\ETL.sln /build "Development|Default"

Different variations of this script does not work.


Solution

  • Try using Debug instead of "Development|Default":

    C:\Users\Source\Repos\ETL> "C:\Program Files (x86)\Microsoft Visual Studio\2017\Enterprise\Common7\IDE\devenv.exe" 
    "ETL.sln" /build Debug
    

    You can simply use devenv without specifying the full path:

    C:\Users\Source\Repos\ETL> devenv "ETL.sln" /build Debug
    

    Also try passing the solution full path as argument:

    C:\Users\Source\Repos\ETL> devenv "C:\Users\Source\Repos\ETL\ETL.sln" /build Debug
    

    References