sql server data warehouse: need help with msmdarch -- sql server data warehouse

need help with msmdarch

Zachary M.C. Harris
4/24/2004 3:49:37 PM

sql server data warehouse:

I am trying to handle some code using msmdarch and keep getting an error

exec xp_cmdshell "cd C:\Program Files\Microsoft Analysis
Services\Bin\msmdarch.exe" /a zacwin2k "C:\Program Files\Microsoft Analysis
Services\Data\" "FoodMart 2000" "C:\FoodMart.cab"

Incorrect syntax near '/'

need help STAT

please email me directly

Re: need help with msmdarch

ermedin.selmanovic NO[at]SPAM moorestephens.com
4/26/2004 5:51:14 AM

Hi,

I think it is something to do with xp_cmdshell being able to accept
just one parameter, in your case the first string "c:\prog...".

Try this:

declare @String nvarchar(4000)

set @String = '"C:\Program Files\Microsoft Analysis
Services\Bin\msmdarch" /a MSCLDEVT \\MSCLDEVT\D$\AS\Data\System\
AutomotiveDemo \\MSCLDEVT\D$\Backups\AS\AutomotiveDemo.CAB'
exec master..xp_cmdshell @String

ermedin

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server data warehouse group.