This article is to get list of file exists in some file location in File System. Some time back I found one problem, some images were getting uploaded from my web application. To cross check if the number of files uploaded matches with data entries, I need to have list of files uploaded in my SQL Server Database, So that I could have comparison between the numbers. We can do this by getting the list using command prompt and saving it in txt file and then importing it in SQL Server or by directly calling shell command in SQL Server.
1. First configure database to execute shell command:
2. Create table to insert the File Names:
3. Execute the following command to insert the file names in the table or you can execute the command directly without INSERT command to get the result in query window itself:
Here, ‘DIR‘ is the command to list down the files and folders ‘ E:\‘ is the path ‘ /A-D‘ is the attribute to filter the list.
Now you can compare myFileList table with the actual file names and count uploaded. You can have a look on various other attribute options available along with this shell command.
Reference for shell commands:
http://msdn.microsoft.com/en-us/library/foo18935cf4-b320-4954-b6c1-e007fcefe358.aspx
Micro Fundas... 