Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
under2811
Constraint Violating Yak Guru
366 Posts |
 Posted - 2007-07-02 : 07:46:33
|
| Hi AllI am facing problem while processing my SSIS packageThe error is:"Invalid delimited data. Text qualifier must be followed by a column delimiter (except for the last column)."The text qualifier is the double-quotes character “. Text fields are supposed to get a double quote at the beginning of the string and one at the end. The column delimiter is the upright bar or pipe character |.Some of the descriptions in table column have double-quotes embedded within the text string. When SSIS encounters one of these embedded quotes, it thinks that is the end of the text string and expects to find the column delimiter character next. It doesn’t, because the " is embedded between other alphabetic characters, so it raises an error.For example if my column value looks like Test"String"OneWhat old DTS doing:DTS make the embedded " into "". The resulting text string then would look like this:"Test ""strings"" one". When running the same data into a database using DTS, DTS recognized automatically the "" in the string and changed it to " so in the target the string looked like this: test "string" one. No problem.SSIS, however, does not allow and does not support doing this "doubling" of embedded " when you are using " as the text qualifier. So it exports the sample string above like this (I added the column delimiters as well):|"test "string" one"|.That then causes the error Please help me outT.I.A |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-02 : 11:19:15
|
| You may need choose another text qualifier. |
 |
|
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
Posted - 2007-07-05 : 15:10:18
|
| I used to have issues on DTS using double quotes as text qualifiers, I always use Tab, | or Ç.---"Try not to become a man of success but rather try to become a man of value." |
|
|
|
|
|
|
Facing problem while processing my SSIS package