Either use SqlBulkCopy or SSIS.
Using a parallel approach with 10lakhs rows will create a huge load on your SQL Server, which may lead to issues on the server side. This is not a general "don't' do it", cause with the appropriate table, index and disk structure, this may work.
SSIS is often the best solution, cause it is built for this kind of operation.
But concrete advice depends on your concrete problem (format, reoccurance, scheduling etc.).
No comments:
Post a Comment