How do you eliminate quotes from being uploaded from a flat file to SQL Server with Integration Services?

  • How do you eliminate quotes from being uploaded from a flat file to SQL Server with Integration Services?

  • ^^^^ R a j u ^^^ (2/17/2010)


    How do you eliminate quotes from being uploaded from a flat file to SQL Server with Integration Services?

    You seem to be taking a test. Is that right?

  • Are the quotes appearing as text-field qualifiers? Or just noise in your file that you want to delete? Do you mean single or double quotes? I omitted to mention the possibility that you were were referring to input data containing actual quotations that should not be imported, though I can't tell for sure from your question.

    You could always just provide sample data to paint the picture so much more clearly.

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply