DTS Problem

Hello All.

I am posting this on behalf of a friend.

"I am encountering a funny problem. I am generating a text with copyright sign as a delimiter. But got funny signs after file generation.

However, if the DTS is executed from another workstation, it works fine. I suspect this is the problem.

http://support.microsoft.com/default.aspx?scid=kb;EN-US;133732 "

Any advise?

Thank you.If you are generating the text document from DTS then in theory it should be just a standard text document which doesn't use True Type fonts so I doubt that is the problem...|||Originally posted by rokslide
If you are generating the text document from DTS then in theory it should be just a standard text document which doesn't use True Type fonts so I doubt that is the problem...

Thank you Rokslide.

I will tell my friend this.|||If you can post more information about the DTS package itself we can problem help more.

Is there any reason they are using the copyright symbol as the seperator as oposed to something more widely used like a | or ,

DTS Import "" Delimiter Bug

I have a pipe delimited file that has text fields that are quantified with double quotes "" and after the 15th column, DTS seems to not know how to deal with the quotes and appears to be buggy. It will import a column and keep the quotes on or import it and the left quote will stay on and not the right. I had another fellow programmer look at it and he could not figure it out. Any ideas? is this a bug?It sounds like you have your text qualifier set. Change it to none.