information can be obtained by the xp_cmdshell external
stored procedure. Results can be inserted into a table with INSERT-EXEC statement.
DECLARE @CMD varchar(256)
SET @CMD = 'DIR F:\data\money.csv'
EXEC master..xp_cmdshell @CMD
Volume in drive F is Secondary
Volume Serial Number is E06B-AEAD
Directory of F:\data
01/30/2010 03:46 PM 114,030 money.csv
1 File(s) 114,030 bytes
0 Dir(s) 54,774,407,168 bytes free