M
Mpumelelo S
Guest
Hello Developers,
I have been referred to the C# corner as what I am looking for looks like cannot be efficiently handled by TSQL. I am doing a piece of work where I have to import millions of files of all sorts of extensions (msg, xlsx, pdf, etc) into SQL Server database. I need to import those files as blob data. The go to SQL OPENROWSET command is taking painfully long as it operates on a row by row basis. What I would like, is to grab multiple files at a time to reduce the processing time. One of the developers in the TSQL corner suggested that a multi-threaded C# method can do, but my C# skill is not up to that level. Can someone help with a handy script please?
Kind regards,
Mpumelelo
Continue reading...
I have been referred to the C# corner as what I am looking for looks like cannot be efficiently handled by TSQL. I am doing a piece of work where I have to import millions of files of all sorts of extensions (msg, xlsx, pdf, etc) into SQL Server database. I need to import those files as blob data. The go to SQL OPENROWSET command is taking painfully long as it operates on a row by row basis. What I would like, is to grab multiple files at a time to reduce the processing time. One of the developers in the TSQL corner suggested that a multi-threaded C# method can do, but my C# skill is not up to that level. Can someone help with a handy script please?
Kind regards,
Mpumelelo
Continue reading...