I must be missing somthing here, I'm no SQL expert (in fact I'd never come accross CTE's before) but that seems like an awfull lot of code for what, on...

Well, if anyone else gets this problem you need to set the text qualifier not only in the pump task but also in the source file object too. The issue...