DECLARE @FilePath varchar(200);

SET @FilePath = 'dir C:\temp\*.pdf /-C '

--EXEC master.dbo.xp_cmdshell 'dir /?'
--EXEC master.dbo.xp_cmdshell 'dir c:\*.txt /-C '

DECLARE @Files TABLE (FileName varchar(200), FileSize varchar (20), DateCreated datetime);
DECLARE @Dir TABLE (FileInfo varchar(1000));

INSERT INTO @Dir
EXEC master.dbo.xp_cmdshell @FilePath;

DELETE FROM @Dir WHERE ISDATE(SUBSTRING(FileInfo, 1, 21)) = 0;

INSERT INTO @Files (DateCreated, FileSize, FileName)
SELECT
	DateCreated = CONVERT(datetime, SUBSTRING(FileInfo, 1, 21)),
	FileSize = SUBSTRING(LTRIM(SUBSTRING(FileInfo, 21, LEN(FileInfo))), 0, 
		CHARINDEX(' ', LTRIM(SUBSTRING(FileInfo, 21, LEN(FileInfo))))),
	FileName = SUBSTRING(LTRIM(SUBSTRING(FileInfo, 21, LEN(FileInfo))),
		CHARINDEX(' ', LTRIM(SUBSTRING(FileInfo, 21, LEN(FileInfo)))), 
		LEN(LTRIM(SUBSTRING(FileInfo, 21, LEN(FileInfo))))) 
FROM @Dir;

SELECT * FROM @Files;