Post reply

can the temp path be changed for the msmdarch.exe utility?

  • August 14, 2006 at 1:42 pm

    #116054

    i'm looking into how the msmdarch.exe works, and i noticed it

    uses the temp path under C:

    can this be changed?

    thoughts?

    _________________________

  • August 15, 2006 at 8:11 am

    #655063

    Hi

    Is this what you are looking for;

    http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/sql_analservbp.asp

    The following VB code snippet shells out to execute the MSMDARCH command. There is no return code; check the error log file to track success or error.

    Dim Servername As String Dim DataPath As String Dim ExePath As String Dim CabFileName As String Dim LogFileName As String Dim Execstr As String Servername = "Servername" ' Olap DataDataPath = """C:\Program Files\Microsoft Analysis Services\Data\""" ' Olap BinariesExePath = """C:\Program Files\Microsoft Analysis Services\Bin\"""' Backup FileCabFileName = """C:\temp\tutorial.cab""" ' Log File LogFileName = """C:\temp\tutorial.log""" Execstr = ExePath & "MSMDARCH.EXE"" /R " & Servername & " " & DataPath_ & " " & CabFileName & " " & CabFileName Shell Execstr, vbHide

  • August 16, 2006 at 9:12 am

    #655284

    it looked like it could have worked out ok,

    but i just checked the syntax, and some thing is

    missing. since i'm not that familiar with it

    i didn't know what to look for.

    says it's missing an END, but where i don't know.

    here's the script.

    Dim Servername As String

    Dim DataPath As String

    Dim ExePath As String

    Dim CabFileName As String

    Dim LogFileName As String

    Dim Execstr As String

    Servername = "Servername"

    ''''''''''' Olap Data

    DataPath = """C:\Program Files\Microsoft Analysis Services\Data\"""

    '''''''''''' Olap Binaries

    ExePath = """C:\Program Files\Microsoft Analysis Services\Bin\"""

    '''''''''''' Backup File

    CabFileName = """C:\temp\tutorial.cab"""

    '''''''''''' Log File

    LogFileName = """C:\temp\tutorial.log"""

    Execstr = ExePath & "MSMDARCH.EXE"" /R

    " & Servername & "

    " & DataPath_ & "

    " & CabFileName & "

    " & CabFileName

    Shell Execstr, vbHide

    thoughts?

    _________________________

  • August 18, 2006 at 12:23 am

    #655573

    Hi

    I have never run this code...But try putting it in a vb6 application....But remember to put it in a sub or function;

    Private Sub TestScript

    End sub

     

     

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply