Placeholder response for SO question http://stackoverflow.com/questions/29491828/text-qualifier-þ-thorn-in-ssis

Response.txt

![Connection Manager General tab ][1]


![Connection Manager preview][2]

![Data flow][3]


  [1]: http://i.stack.imgur.com/aXZqb.png
  [2]: http://i.stack.imgur.com/6i7iY.png
  [3]: http://i.stack.imgur.com/gwlze.png

so_29491828.biml

<Biml xmlns="http://schemas.varigence.com/biml.xsd">
    <Connections>
        <FlatFileConnection 
            FilePath="C:\ssisdata\ThornyTextDelimiter.csv" 
            FileFormat="FFF" 
            Name="CM_FF">         
        </FlatFileConnection>
    </Connections>
    <FileFormats>
        <FlatFileFormat 
            Name="FFF" 
            IsUnicode="true" 
            FlatFileType="Delimited"
            TextQualifer="_x00FE_"
            ColumnNamesInFirstDataRow="true">
            <Columns>
                <Column Name="Col1" DataType="Int32" Delimiter="Comma" />
                <Column Name="Col2" DataType="String" Length="5" Delimiter="Comma" TextQualified="true" />
                <Column Name="Col3" DataType="Int32" Delimiter="CRLF" />
            </Columns>
            
        </FlatFileFormat>
    </FileFormats>
    <Packages>
        <Package ConstraintMode="Linear" Name="so_29491828">
            <Tasks>
                <Dataflow Name="DFT Thorny">
                    <Transformations>
                        <FlatFileSource ConnectionName="CM_FF" Name="FF_SRC"></FlatFileSource>
                        <!--
                        
                        -->
                        <DerivedColumns Name="DER Placeholder for data viewer"></DerivedColumns>
                    </Transformations>
                </Dataflow>
            </Tasks>
        </Package>
    </Packages>
</Biml>

ThornyTextDelimiter.csv

Col1,Col2,Col3
100,þ2,000þ,300