I need to load a file into SQL server where Icelandic thorn (þ) (it comes by pressing Alt+0254) is used as a text qualifier. I have given þ as text qualifier in SSIS flat file connection manager but SSIS is not recognizing it and it is considering þ also as data. I am not sure how I can proceed with this. Help would be really appreciated. Thank you!
Asked
Active
Viewed 70 times
0
-
Alternate [duplicate](http://stackoverflow.com/questions/22778719/ssis-unknow-delimiter-encountered) approaches – billinkc Apr 07 '15 at 14:43
-
@billinkc I have read the other thread. That question is regarding þ as a delimiter. But this question is related with þ as a text qualifier. – zhb_hsn Apr 08 '15 at 04:26
-
Apologies, hadn't had tea yet. I *think* you're still going to be going down the same route though, assigning the character code except instead of the column delimiter, it'll be text qualifier. Testing now – billinkc Apr 08 '15 at 04:29
-
Yup, same approach, just different field that you specify with the thorn. That enough to go on or you need a formal answer? – billinkc Apr 08 '15 at 04:43
-
Hi billinkc,apologies for extremely late reply. I was unable to do this due to time crunch and had to modifiy the delimiter. Thanks for the reply. – zhb_hsn Nov 16 '15 at 20:42