ScorpioTiger
IS-IT--Management
Hi folks,
I'm on SSIS 2008 and new to SSIS. I have a single CSV containing output from mutiple tables with text columns using double quotes as qualifiers and using escaped double quotes within the text.
It seems that SSIS cannot deal with embedded quotes. This seems to be well documented.
My approach is to forget about the SSIS Flat File Connection and find another way to connect to the data that will be able to deal with the embedded quotes.
Can anyone validate this approach? Any tips on the best driver? It would seem than the Microsoft Jet OLEDB 4.0 provider should be able to do it, but I haven't been able to get it working. SSIS doesn't like the UDL that I've created even though the connection tests ok if I edit it outside SSIS.
I'm on SSIS 2008 and new to SSIS. I have a single CSV containing output from mutiple tables with text columns using double quotes as qualifiers and using escaped double quotes within the text.
It seems that SSIS cannot deal with embedded quotes. This seems to be well documented.
My approach is to forget about the SSIS Flat File Connection and find another way to connect to the data that will be able to deal with the embedded quotes.
Can anyone validate this approach? Any tips on the best driver? It would seem than the Microsoft Jet OLEDB 4.0 provider should be able to do it, but I haven't been able to get it working. SSIS doesn't like the UDL that I've created even though the connection tests ok if I edit it outside SSIS.