SSIS Problem

  • What is the use of text qualifier in flat file source

  • it is so you can include characters in the text which would normally cause problems, i.e. in a csv you can't include a , in a field - but if you use the text qualifier (normally " but can be anything) - any text between the two "'s is allowed:

    To save this in a csv: Hello, My Name is...

    would result with: Hello, My Name Name is... - which is two fields

    using a text qualifier : "Hello, My Name is..." - is just one field

    Ed

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

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