var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: STORE PROCEDURE and DTS
I created a batch file to run a DTS saved as a STRUCTURED STORE FILE. Works fine on the command promt.
Can I use a SPROC to call something like a shell command to execute that batch file? If yes, how is this be possible?
check this out..
Originally Posted by ARPRINCE
EXEC master..xp_cmdshell 'osql.exe -S YourServerName -U sa -P secretcode -i [input_file]
Last edited by rudra; 03-13-06 at 17:51.
Originally Posted by rudra
Thanks for the input. It worked for me without the other parameters.
EXEC master..xp_cmdshell 'C:\DatabaseDTS\MYBATCH.BAT'