bulk insert

External Article

SQL Server Bulk Insert Row Terminator Issues

  • Article

We often need to import data into SQL Server from a file. Sometimes unwanted end of line characters are part of the source file and these can create issues when importing the data. One of the ways to avoid this issue is to use SQL Server Integration Services (SSIS), but it doesn't always make sense to use SSIS for simple operations. Rahul Mehta explains that he uses BULK INSERT sometimes faces issues with Line Feeds and Carriage Returns. In this post, Rahul shows some examples and explains how to fix the issue.

2017-03-17

3,572 reads

Blogs

Daily Coping 5 Aug 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Daily Coping 4 Aug 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

What’s next III

By

In case you didn’t know I was given notice about a month and a...

Read the latest Blogs

Forums

Truncate partition table failed due to index not partition. Help please.

By JasonO

I have 1 table which has a partition on Date column. However this table...

Finding Special Characters in Email Address

By sathishkm

Hi All, I have to find the special characters in email address apart from...

Three Mile Island And Your Databases

By Grant Fritchey

Comments posted to this topic are about the item Three Mile Island And Your...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers