Hai all....
I am just trying to load a csv file into the table which i created in sql server......
evrything is fine...when i try to load the csv file which is 700 bytes..its working fine....no problem,,,
but wen i try the same with another csv file which is 63mb i get an error has
system.data.client.sqlexception:Timeout expired .the timeout period is
elapsed prior to complete the operation or the server is not
responding....
Hope i made myself clear.........
Help me......
Loading
Posted Jan 22, 2009, 10:20 PM
SqlCommand command = new SqlCommand();
command.Connection = con;
command.CommandText = "BULK INSERT snort.dbo.[Dataset]" + @" FROM 'c:\tuesday'" + "WITH" + "(" + "FIELDTERMINATOR = ','," + "ROWTERMINATOR='\n'" + ")";
command.ExecuteNonQuery();
Console.WriteLine("--------Dataset loaded sucessfully-------\n\n");
Hope i made myself clear...
Ryan AlfordPosted Jan 22, 2009, 6:54 PM