Accessing The FileSystem With T-SQL

• Peter P

  SSCrazy

  Points: 2777

  More actions

  April 28, 2004 at 11:54 am

  #63397

  Is it possible to add the FileSystem as a Linked Server.  I have a need to loop through a large number of .dbf files as part of an historical Load in our ETL process and I'd prefer to access the files using T-SQL instead of scripts. I have no problem using scripts but its a team project and everyone is comfortable with T-SQL.

   

  Thanks,

  Pete

• May 3, 2004 at 8:00 am

  This was removed by the editor as SPAM

• rschaeferhig

  SSCrazy Eights

  Points: 8776

  More actions

  May 11, 2004 at 8:58 am

  #505990

  There's a writeup at Microsoft: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_adda_8gqa.asp on administering Linked Servers. The examples include setup of and querying a File System using the Indexing Service.

  Note: I haven't been able to get it to work yet copying the code verbatim from the article. Let me know if you can figure it out.