Bulk Insert

Question

Viewing 6 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

river1 SSC-Insane Points: 24315 More actions · Answer 1

Bulk command:

exec('BULK INSERT sessoes1 FROM ''c:\sgrs\SGRS_SGCTCentral_7_20111111102846.rar_Dir\sessao.txt''

with (FIRSTROW =2,FIELDTERMINATOR =''|'',

ROWTERMINATOR =''|'', tablock)')

Table structure:

create table Sessoes1(Sessao int, Codrf varchar(5))

padhis SSCommitted Points: 1762 More actions · Answer 2

this errors comes usually if the file is opened While running the bulk insert command.

river1 SSC-Insane Points: 24315 More actions · Answer 3

SSC-Insane

Points: 24315

January 9, 2012 at 6:04 am

the file is not open.

It's closed.

Devendrakumar SSC-Forever Points: 42493 More actions · Answer 4

Re-write the query to match with this example...

Example:

DECLARE @bulk_cmd varchar(1000)

SET @bulk_cmd = 'BULK INSERT AdventureWorks2008R2.Sales.SalesOrderDetail

FROM ''<drive>:\<path>\<filename>''

WITH (ROWTERMINATOR = '''+CHAR(10)+''')'

EXEC(@bulk_cmd) -- Focus here

patrickmcginnis59 SSCertifiable Points: 6483 More actions · Answer 5

make sure you check for an extra carriage return in your source text file (ie., extra line with no content).

rVadim Hall of Fame Points: 3969 More actions · Answer 6

I don't think ROWTERMINATOR should be pipe '|'. It should be '\r' or '&#92n' or '\r&#92n'. The latter is default.

--Vadim R.