March 3, 2011 at 12:10 pm
Hello,
Could somebody help me ?
I would like to create a link between our sql2008 server and a file server.
I know that it's called a linked server....
Now, how to do the configuration to have the link with 1 folder (not 1 file). Purpose is to read the folder and import the xls files (number is not known)....
Let say for ex that the file server is \\X780FS and that the share is \IMPORT.
Many Tks.
PS I have already a part of the solution to be able to read the folder http://www.sqlservercentral.com/Forums/Topic763265-392-1.aspx#bm764386.
March 4, 2011 at 12:28 am
hey,
why do you want sql server to access the file server folder? could i know the reason.
and one more thing, you have a wrong understanding on linked server.
linked server does not mean linking a sql server and a folder in file server, it links two database servers and you can query the databases in each other using the four part notation. it uses oledb drivers to connect to the databases on different servers or different instances on the same server.
March 4, 2011 at 1:07 am
Tks for you answer.
The purpose is to read the contents of a folder (which is composed either by XLS files or XML files).
I was thinking that to do it I had to have a linked folder....
So what's the solution?
PS I do not want to use SSIS for the moment...
March 4, 2011 at 2:19 am
i hope you can read the contents of a folder using extended stored procedures in sql server.
master..xp_cmdshell 'dir 'path to the folder''
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply