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.
Why don’t you let the sql Server download the excel from the sharepoint library and use a import job.?
You can use something like the import Wizard: http://dotnetslackers.com/articles/sql/Importing-MS-Excel-data-to-SQL-Server-2008.aspx
