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
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

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

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