Hi, I am having a file which is contain 70,000 data. i try to upload this file into sql server table using front end sharepoint site.i am getting time out period expired error. But i have added connection timeout=100000 property in connection string still i am facing the same problem So please help me to solve this issue Regards S.Madeswaran

I'm sorry, do you mean a 70 mb file ? You can't upload a file directly into SQL from sharePoint. Are you using SharePoint and uploading into SharePoint? If you are getting a time out look at increasing you connection timeout in Central Admin.Kris Wagner, MVP, MCITP, MCTS Twitter @sharepointkris Blog: http://www.sharepointkris.com/blog

Hi Kris Wagner, Actually 70,000 thousand data file,i am uploading this file into sql server table from front end sharepoint site.i have uploaded successfully this file when my data is only 10,000. But now 70,000 data so now i cant upload the same file. I am using C# code.the code is below Code: using (SqlBulkCopy bulkCopy = new SqlBulkCopy("Server=12.42.5.100; Database=Live; User Id=Live123; password=Live123;")) { bulkCopy.DestinationTableName = "Bulk"; bulkCopy.WriteToServer(dtbBankStmt); } dtbBankStmt is dataset name. I tried to debug the code dataset having value.after i press F10 i am getting this error 'timeout period elapsed prior to completion of the operation' So please help me to solve this issue Regards S.Madeswaran

You should never directly modify a SharePoint db's, it's one against best practices and two could void your warranty with microsoft. That being said I saw your post on MSDN and how to fix the time out. Are you good now and is your problem fixed?Kris Wagner, MVP, MCITP, MCTS Twitter @sharepointkris Blog: http://www.sharepointkris.com/blog