Importing Extreamly Large Files
C#
1
Posts
1
Posters
0
Views
1
Watching
-
Hello, I am using C#.net to create a win app. I need to import extreamly large files into a SQL server database? I was wondering what is the best way to go about it. I have used SqlBulkCopy althought it is fast it times out before the import is complete due to the size of the file. I am also in the process of trying a split import with SqlBulkCopy (If I have a file that is 10 records I would import the first 5 and then import the next 5). Am I on the right track? Any suggestions would be great. Thanks j