How to find the file details from a folder using sql server?

Question

I want to get the file details like file date, size, etc... from a folder using SQL server. Please share me the suggestion of both using command shell and without using command shell.

What are you going to do after you have the file list? Maybe SSIS would be more suitable tool for you? — James Z
– James Z, Commented Mar 9, 2017 at 12:01

Venu · Accepted Answer · 2017-03-09 12:02:22Z

2

You have 3 options (at least) for doing that.

You can use xp_cmdshell for interacting with File System. CheckHere
You can create a CLR assembly and use it in the procedure. CheckHere
Using OLE Automation. Also CheckHere

Please keep in mind that both of the approaches have their procs and cons. The 1st option is easy and you need sysadmin permissions to use it directly. The 2nd option give you more control and can be used with less permissions, but you need to put some effort code the CLR assembly.

edited Mar 9, 2017 at 12:02

answered Mar 9, 2017 at 10:25

Venu

4752 silver badges8 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Gopi Over a year ago

Is there any options to get the details using stored procedure/functions in sql server.

Venu Over a year ago

@Gopi, There is additional option using OLE Automation procedures of SQL Server. Updated the post with links. I hope this helps.

Collectives™ on Stack Overflow

How to find the file details from a folder using sql server?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related