building an .asdatabase file from the command line

Hot Topic

SQL Server 2005 Management Tools
regarding sqlserver2005 clientserver installation
Can I update several columns with CASE expressions using SQL at the same time?
SQL DataReader Mischief ! HELP !
for loop container to process all Excel files
Help with query
How to hide a report parameter control dynamically at runtime?
SQL 2005 Enterprise June CTP Installation Error
Replicating Account Intelligence for a Financial Reporting cube
Cannot deploy assembly from VS.NET into SQL server 2005

SQL Server

SQL Mapping Almost Complete
A probably simple question
Collapsing Three Rows Into One with T-SQL Challange?
Insufficient Log Data
To know how many tables affected by SELECT Query
Causing a TableColumn/Control to fill remaining space
Using SQLExpress Manager to Create Database
SA account Locked out
how to modify stored procedure to achieve objective
How can I convert download SQL Server 2005 to a licensed version.

building an .asdatabase file from the command line

Hi,

I was wondering if anyone knew how to 'build' an 'analysis services' project (i.e - generate the .asdatabase file) from the command line, so that I could have it done automatically during a build process.

Thanks,
Kobi Reiter

Answer this question

building an .asdatabase file from the command line

  • Dean Wills MSFT

    hello Soma,

    which build of sql server do you have (specifically BIDS) i recall you might need to be on sp1 or later for this to work.



  • hrjordan

    Play around with the devenv.exe executable at the command-line.  Although I have not tried it, you might be able to use it with your project file and with a "/build" option.  The executable is the what launches when you run BI Dev Studio.  Typical setup has it located at:

    "C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\devenv.exe"

    Dave Fackler

  • velibicer

    hello,

    i would expect something like the following to work

    devenv.exe <your_solution_name>.sln /build Development /Out out.log

    Note that you might need an SP1 build for this.

    hope this helps,



  • Shrek2005

    I am also interested in this topic .... Anyone can contribute any idea(s). Thanks.

  • woaksie

    I'm also interested in this. Need to automate the build of our deployment package. Haven't been able to find any information on this.

  • lominup

    Here the command-line parameter

    devenv cube.sln /build Development /Out out.log

    But I got following error.

    ====================================

    Catastrophic failure (Exception from HRESULT: 0x8000FFFF (E_UNEXPECTED))========== Build: 0 succeeded or up-to-date, 0 failed, 0 skipped ==========

    ====================================

    When I use the /Rebuild switch instead of build throws me this error

    ====================================

    Catastrophic failure (Exception from HRESULT: 0x8000FFFF (E_UNEXPECTED))========== Rebuild All: 0 succeeded, 0 failed, 0 skipped ==========

    ====================================

    My Visual Studio installed information shows following, this clarifies that SP1 is installed on this box.

    ====================================

    Microsoft Visual Studio 2005
    Version 8.0.50727.762 (SP.050727-7600)

    ...

    .

    .

    Microsoft Visual Studio 2005 Team Suite - ENU Service Pack 1 (KB926601)
    This service pack is for Microsoft Visual Studio 2005 Team Suite - ENU.
    If you later install a more recent service pack, this service pack will be uninstalled automatically.
    For more information, visit http://support.microsoft.com/kb/926601

    ..

    .

    .

    =====================================

    Please Help,

    Soma

  • Adeel

    Unfortunately, when I try to run devenv with the /build switch, it fails:

    Package 'Visual Studio Source Control Integration Package' failed to load.
    Catastrophic failure (Exception from HRESULT: 0x8000FFFF (E_UNEXPECTED))
  • building an .asdatabase file from the command line
Answer this question