how to load Text file Thorn(þ) delimited into sql-server 2012

1.2k views Asked by At

I have text file something like this

col1þcol2þcol3þcol4
aaaþbbbþcccþddd
xxxþyyyþzzzþabs
123þtyehþyetþethrr

i tried loading into sql-server using ssis package after following steps from here but i couldn't find solution,could somebody guide me in my execution

The Package fails :

here's snap shot from program execution

[Flat File Source [8]] Error: Data conversion failed. The data conversion for column:<column namesss> 

it outputs like this

enter image description here

the changes i tried making: like this

enter image description here

enter image description here

enter image description here

1

There are 1 answers

1
RBarryYoung On

Change thorn to be your column delimiter, not your Row delimiter. Then change your row delimiter to be line break (presumably).

To do any more we'll need to see your table definitions and the rest of your package definition, particularly the column assignments.