Maintaining a db table to reflects the contents of a file tree

[nitram]

A while back I posted a tip to get a csv file into a db table using an O/S command and the 'xp_cmd_shell' call in a stored procedure.<br><br>I mentioned that I used the same principle to maintain a table to reflect the structure of a file tree. Somebody mailed me asking for a more details on this - here's my example code (<A HREF="

http://www.tardis.ed.ac.uk/~martin/sql7/synch_file_tree.txt"

TARGET="_new">

http://www.tardis.ed.ac.uk/~martin/sql7/synch_file_tree.txt</A>)<br><br>The

context it was developed for was to suck 'banner adverts' into the customer's public web site. I've edited it a little bit to remove customer-specific stuff (hope it still works <br><br>Probably not the most efficient but it seems to work ok. (I'm sure you can do better with DTS for example) <br><br>Anyway hope this is of interest and my coding style is acceptable.

 

[nitram]

Sorry - should have emphasised that this code loads the <b>structure</b> of the file-tree into the table - not the contents of the files themselves. <p>Martin Ramsay<br><a href=mailto:Martin.Ramsay@company-net.co.uk>Martin.Ramsay@company-net.co.uk</a><br><a href=

http://www.company-net.co.uk>My

employer</a><br>Looking for interesting work in Canada - any offers ?