"Cagey" <k@c.com> wrote in message
news:uKpMekj%23EHA.2580@TK2MSFTNGP15.phx.gbl...
>
> Whilst importing a CSV file, DTS fails on fields with commas in them.
>
> The text fields are surrounded by quotes and I've managed to get other
> pieces of software to successfully read the file, but not Microsoft
> Office products.
>
>
> DTS seems to have set the Text Qualified property to Double Quote{"}
> and I've tried putting an explicit " and "" in this field to no avail.
>
>
> I'm hoping that somebody can show me where I'm going wrong with this
> to avoid me having to add a step to parse the file before impot.
>
>
> I posted similar a few days ago, but may not have worded it correctly.
> Hoping somebody can assist.
>
> Kev.

Melih SARICA wrote:
> Try to Use an Other field Delimeter
>
> "Cagey" <k@c.com> wrote in message
> news:uKpMekj%23EHA.2580@TK2MSFTNGP15.phx.gbl...
>
>>Whilst importing a CSV file, DTS fails on fields with commas in them.
>>
>>The text fields are surrounded by quotes and I've managed to get other
>>pieces of software to successfully read the file, but not Microsoft
>>Office products.
>>
>>
>>DTS seems to have set the Text Qualified property to Double Quote{"}
>>and I've tried putting an explicit " and "" in this field to no avail.
>>
>>
>>I'm hoping that somebody can show me where I'm going wrong with this
>>to avoid me having to add a step to parse the file before impot.
>>
>>
>>I posted similar a few days ago, but may not have worded it correctly.
>>Hoping somebody can assist.
>>
>>Kev.
>
>
>

"Cagey" <k@c.com> wrote in message
news:uKpMekj%23EHA.2580@TK2MSFTNGP15.phx.gbl...
>
> Whilst importing a CSV file, DTS fails on fields with commas in them.
>
> The text fields are surrounded by quotes and I've managed to get other
> pieces of software to successfully read the file, but not Microsoft
> Office products.
>
>
> DTS seems to have set the Text Qualified property to Double Quote{"}
> and I've tried putting an explicit " and "" in this field to no avail.
>
>
> I'm hoping that somebody can show me where I'm going wrong with this
> to avoid me having to add a step to parse the file before impot.
>
>
> I posted similar a few days ago, but may not have worded it correctly.
> Hoping somebody can assist.
>
> Kev.

"Cagey" <k@c.com> wrote in message
news:eqhrEwj%23EHA.1564@TK2MSFTNGP09.phx.gbl...
> Melih SARICA wrote:
> > Try to Use an Other field Delimeter
> >
> > "Cagey" <k@c.com> wrote in message
> > news:uKpMekj%23EHA.2580@TK2MSFTNGP15.phx.gbl...
> >
> >>Whilst importing a CSV file, DTS fails on fields with commas in them.
> >>
> >>The text fields are surrounded by quotes and I've managed to get other
> >>pieces of software to successfully read the file, but not Microsoft
> >>Office products.
> >>
> >>
> >>DTS seems to have set the Text Qualified property to Double Quote{"}
> >>and I've tried putting an explicit " and "" in this field to no avail.
> >>
> >>
> >>I'm hoping that somebody can show me where I'm going wrong with this
> >>to avoid me having to add a step to parse the file before impot.
> >>
> >>
> >>I posted similar a few days ago, but may not have worded it correctly.
> >>Hoping somebody can assist.
> >>
> >>Kev.
> >
> >
> >
>
> Unfortunately we cannot do that. The data is legacy data 4 years+ old,
> which no longer exists on the source system.
>