"Who's the idiot that designed the file destination? "

Hi everybody,

I'm new -- sorry, I couldn't figure out how to reply to this thread, I think because it's locked- so I started a continuation.

What I am wondering about is if you indicate "text qualified= true" then why does it still get confused by embedded commas in quote-delimited text; I would think that the "text qualified" parameter would take care of that. Can anyone explain?

So as a work around I am thinking of running a perl script via "Execute Process Task" and clean up the commas that way, since I have little control over how it is produced.. the app it comes from has no ability to contol output, and it outputs it's tables as comma seperated files, with text fields surrounded by quotes. I was hoping to stay inside SIIS for the whole etl job-- must admit some disappointment.

Any suggestions would be greatly appreciated!!

Thanks!!

jk

At the outset, I wonder if you went to the school when you were a child.|||

enric vives wrote:

At the outset, I wonder if you went to the school when you were a child.

Enric,

If you're referring to the title of the thread, that was the name of the original thread. So its not this guy's fault.

-Jamie

|||

jk-olap wrote:

Hi everybody,

I'm new -- sorry, I couldn't figure out how to reply to this thread, I think because it's locked- so I started a continuation.

What I am wondering about is if you indicate "text qualified= true" then why does it still get confused by embedded commas in quote-delimited text; I would think that the "text qualified" parameter would take care of that. Can anyone explain?

So as a work around I am thinking of running a perl script via "Execute Process Task" and clean up the commas that way, since I have little control over how it is produced.. the app it comes from has no ability to contol output, and it outputs it's tables as comma seperated files, with text fields surrounded by quotes. I was hoping to stay inside SIIS for the whole etl job-- must admit some disappointment.

Any suggestions would be greatly appreciated!!

Thanks!!

jk

Hi jk,

Could you post a sample that exhibits the problem?

Thanks

Jamie