One one my friends asked mw if it is possible to copy the directory structure information with size to a text file. This can be done via any front end application. If you want to do this from SQL Server you can make use of system procedure xp_cmdshell

Consider the follwoing code

DECLARE @cmd sysname
SET @cmd = 'Dir F:\ > f:\dir_out.txt'
EXEC master..xp_cmdshell @cmd

The above code will copy the directory structure information of F drive to the text file named dir_out.txt. The sysmbol > is in this usage used to copy to a specified file. If you want to copy a file content from one place to another you can use that.