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.


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

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