Hi Rich.
I had a similar task and for me the best way to bulk import a large number
of rows into SQL Server was to use the bcp utility. Here's a great resource
for it:
https://www.red-gate.com/simple-talk/sql/database-administration/working-with-the-bcp-command-line-utility/
I create a tab-delim
Hi All,
I am attempting to bulk merge a lot of rows quickly to an mssql server and
I understand that table value parameters are a possible option for doing so.
I set up the following test objects on the sql server (modeled after a
python example of sorts from
https://github.com/mkleehammer/pyodbc