CODEWITHSUNDEEP
sql-serverssis
user3449213
user3449213

Reputation: 17

SSIS Unknow delimiter Encountered

I am currently working on a ssis project i have a data like this 

col1þcol2þcol3þcol4

i have followed steps from here How to read a flatfile with lowercase thorn as the delimiter

but the data looks like this ?

col1þcol2þcol3þcol4 on loading in ssis Flat file connection manager !

What should be delimiter in this case ?

Upvotes: 0

Views: 185

Answers (2)

vhadalgi
vhadalgi

Reputation: 7189

þ is a thorn delimiter

then you need to change the xml code (goto view-->code)

DTS:ColumnDelimiter="_x002C_"

or as said by @jayvee paste þ or try pasting þ

Upvotes: 0

Jayvee
Jayvee

Reputation: 10875

The column delimiter drop down menu in the connection manager just lists the most common options but you can paste whatever character you need, even if it's not on the list. You can then just paste þ and it should work.

Upvotes: 2

Related Questions