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

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: 0 / 0
RadGrid Filter Case SensitiveRating: 0 / 0
Windows Service Install System.Security.SecurityExceptionRating: 0 / 0
Paypal button and .NET aspx pageRating: 0 / 0
View Server State permisssion was denied on object 'server', database 'master'Rating: 0 / 0
Remove all objects from a SQL Schema - Cannot drop schema because it is being referenced by objectRating: 1 / 1
Visual Studio - Command to collapse all sections of code?Rating: 0 / 0
Pervasive drivers not showing up in ODBCRating: 0 / 0
Visual Studio ZoomRating: 0 / 0
Telerik radbutton IconsRating: 0 / 0

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 2017

Sign in