December 5, 2003 at 8:10 pm
Ok, here is what I want to do simply:
1) Run a SQL query to request a list of file numbers from my database. For example:
SELECT DISTINCT fileNo FROM table1
2) Use the results of that query to create a folder somplace on my server for each file number returned. If the folder already exists, then I want to ignore it and move on to the next file number.
Any idea how to do this via a stored proc or dts job?
Thanks for the help.
Bob Gibilaro
December 6, 2003 at 1:42 am
exec xp_cmdshell 'mkdir c:\t'
from the putput u can check whether folder exists
My Blog:
December 6, 2003 at 2:01 am
I do it like Dinesh suggested.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
December 9, 2003 at 7:58 am
Thanks guys. It worked perfectly.
Bob
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply