Sql server list all files in a directory

Sod the error message —and then the number of objects in the folder. Jfbevilaqua works fine, but does not provide the details of the subfolders and files within the subfolder. You are commenting using your WordPress. You are commenting using your Google account. You are commenting using your Twitter account.

You are commenting using your Facebook account. Notify me of new comments via email. Notify me of new posts via email. Home Post List Contact. SQL Journey. Share on Tumblr. Like this: Like Loading Peter Pirker said. Ian Wallace said. AF said. Leave a Reply Cancel reply Enter your comment here John W. Mnisi John W. Mnisi 2 2 gold badges 9 9 silver badges 16 16 bronze badges. I need to show the files on a screen. An end user that runs a certain process needs to see the files inside this folder before invoking the process.

Add a comment. Active Oldest Votes. Sam Axe Matija Grcic Matija Grcic 12k 3 3 gold badges 60 60 silver badges 88 88 bronze badges. Daylight It should work fine, never had problems with those characters. I have a problem. If some of these characters are listed in the path then it doesn't work. HemusSan: Bit late to react, but maybe it helps someone else You probably need to prefix the string with an N so the server knows it's unicode.

Otherwise it will return nothing. Depth - 1 AND d2. Steve Steve 3 3 silver badges 2 2 bronze badges. Hi Steve, can you adapt the insert clause so that only certain file types get added to the temp table? No risk of feature going away do to it being undocumented. Brad Turek 1, 2 2 gold badges 25 25 silver badges 49 49 bronze badges.

Remus Rusanu Remus Rusanu k 39 39 gold badges silver badges bronze badges. Go to properties and ensure the permission level on the Connection is setup to external Add A Sql Function to the Assembly. Here's an example which will allow you to select form your result set like a table. GetFiles path. BenMorel Jeffery Williams. Can't figure out why. Also it would be great to pull in the file date, can this be done as a field as well? Well spotted!

For example, say I have a path of:. I'll have to have a play at getting the file date into another column. Jeff Moden. Just want to correct that last post. You must be logged in to reply to this topic. Login to reply. September 23, at am Hi All, I hope this makes sense, lets say i have folder a and folder b.