August 14, 2006 at 1:42 pm
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
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
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
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