Troubleshooting SQL Server 2017 Bulk Copy Problems If you have problems with SQL Server 2017 bulk copy, review this troubleshooting checklist to find potential solutions. 1. You may receive error 595 when you bulk insert with another outstanding result set. To work around this problem, you should run bulk insert statement with XACT_ABORT on. 2. The error 674 may occur...
Tag: bulk copy
Tips for using bulk copy in SQL Server 2017
Tips for using bulk copy in SQL Server 2017 Consider using BULK INSERT to insert data from files stored in Azure Blob storage. Beginning with SQL Server 2017 BULK INSERT command enable access data directly from a file specified as CSV format, and from files stored in Azure Blob storage through the new BLOB_STORAGE option of EXTERNAL DATA SOURCE. Use...
Troubleshooting SQL Server 2016 Bulk Copy Problems
Troubleshooting SQL Server 2016 Bulk Copy Problems If you have problems with SQL Server 2016 bulk copy, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2016 service pack. Because many SQL Server 2016 bulk copy bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack. At the...
Some tips for using bulk copy in SQL Server 2016
Some tips for using bulk copy in SQL Server 2016 Consider using minimally logged bulk copy whenever possible. The minimally logged bulk copy is much faster than other bulk copy methods, but to use it you must provide all the following conditions: 1. The database option ‘select into/bulkcopy’ is set to true (by the way, using this option causes the […]
Tips for using bulk copy in SQL Server 2014
Tips for using bulk copy in SQL Server 2014 Use native mode bulk copy whenever possible. Because native mode bulk copies are generally faster than character mode, you should use native mode bulk copy whenever possible. Note. Now the bcp utility supports native data files compatible with SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2,...
Troubleshooting SQL Server 2012 Bulk Copy Problems
Troubleshooting SQL Server 2012 Bulk Copy Problems If you have problems with SQL Server 2012 bulk copy, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2012 service pack. Because some SQL Server 2012 bulk copy bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack. At the...
Tips for using SQL Server 2012 bulk copy
Tips for using SQL Server 2012 bulk copy Use the -K option of the bcp utility. This option was first introduced in SQL Server 2012. If you specify "ReadOnly" for the -K option the read-only access to a secondary replica in an AlwaysOn availability group will be used. Consider using minimally logged bulk copy whenever possible. The minimally logged bulk...
Troubleshooting problems with bulk copy in SQL Server 2008 R2
Troubleshooting problems with bulk copy in SQL Server 2008 R2 If you have problems with bulk copy in SQL Server 2008 R2, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2008 R2 service pack. Because many SQL Server 2008 R2 bulk copy bugs were fixed in SQL Server service packs, you should install the...