Bulk Insert with Line Feed Row Delimiter

by ebarcza 3/9/2009 12:56:00 PM

\n does not work for rows that are terminated with just a LF/AScii 10 char

use char(10) instead in dynamic SQL

3bfdf756-4a61-4e0c-8980-7e5eea9baaa8|0|.0

Tags: bulk insert, with, line feed, row delimiter

Powered by BlogEngine.NET 1.5.0.7
Theme by Mads Kristensen

About the author

Name of author

Author name
Something about me and what I do.

E-mail me Send mail

Send mail

Calendar

View posts in large calendar

Pages

Recent posts

What is a CNAMERating: 0 / 0
How to Add another admin user to Azure AccountRating: 0 / 0
Viewing the SQL Server Error Log ffffRating: 0 / 0
How to create shortcut to website on chromeRating: 0 / 0
RegisterStartupScript to open new page in new tabRating: 0 / 0
testRating: 0 / 0
Outlook 503 No recipient(s) when sendingRating: 0 / 0
Bootstrap Centering a column using offsetsRating: 0 / 0
Loop through RadGrid and read Check Boxes when not in edit modeRating: 0 / 0
Cannot read keys when either application does not have a console or when console input has been redirected from a file. Try Console.Read.Rating: 1 / 1

Recent comments

ReportViewer Control: Fit to Page (1)
Agustina Sappah wrote: Hi. I just noticed that your blog looks like it ha… [More]
XP Restart over Remote Desktop (1)
aperitivo roma wrote: I love this blog [More]
Why WebMethods cannot be static methods (1)
games wrote: Wii users will be able to download a selection of … [More]
Sys.Webforms.PageRequestManagerServerErrorException (1)
Photo to Painting wrote: Great Work Regards Rolonirst [More]
Multiple Controls for One modalPopup (1)
ebarcza wrote: huh? [More]
Canceling Application.Ontime in excel (1)
ebarcza wrote: test comment [More]
DataFormatString CSharp ASP.NET (1)
Rich wrote: GREAT POST! Is really helpful for a quick referenc… [More]
Firing Update Panel From A GridView Button (1)
kral oyun wrote: Thank you very good article [More]
Changing datasource in rdlc, VB.NET (1)
Erik wrote: Great post, thanks for the help [More]
First Blog Entry (1)
Admin wrote: comment [More]

Authors

Tags

Blogroll

Download OPML file OPML

OPML

Disclaimer

The opinions expressed herein are my own personal opinions and do not represent my employer's view in anyway.

© Copyright 2020

Sign in