Hello,
We have a project as described below.
The user uploads Excel or XML files into a SharePoint library. Then the information is exctracted from those files and conveyed into a MS SQL Server database for reporting purposes.
Since users upload very big files simultaniously we use a timer job that does transfering at night time. So users can see their new data in reports only next morning. This is not good. So can you suggest some other variants for the user to see his or her data in reports as soon as possible with minimum performance affection? A workflow? A console application?
Thanks.
So after the file has been uploaded SharePoint in some way has to let SQL Agent know that it’s time to download the file from the library? How can I do so? Event Receiver?
