bulk insert

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

Cool Stuff in Snowflake – Part 9: ILIKE

By

I’m doing a little series on some of the nice features/capabilities in Snowflake (the cloud...

Scalar Valued Functions in SQL Server 2019

By

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get...

Read the latest Blogs

Forums

Statistics Profile Results

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Statistics Profile Results

Query web API and return JSON data

By jim.powers

Hello, We use a service that provides an API for pulling our real-time data....

Linked Table To MS Access error

By mjdemaris

Hello All, I have one table that is giving me problems. Access is the...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers