MS SQL Server - cmdexec sql 2005 issue?

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

cmdexec sql 2005 issue?

tobemdx

2006-10-24, 6:31 pm

I have the following script in a batch job which execute successfully with no
issues:

for /F "tokens=2-4 delims=/- " %%A in ('date/T') do set var=
d:\datafiles\%%A%%B%
%C
md %var%

When I create a cmdexec step I get the following error and the directory is
not created correctly.

%%A was unexpected at this time. Process Exit Code 1. The step failed.

How can i correct/address the issue...I need a folder created daily with
date as the folder name using cmdexec in sql 2005.

Thanks

tobemdx

Sponsored Links