SSIS Change Text File Column Delimiter in Text Editor

Ever want to change delimiter in SSIS Package without needing to open up BIDS?

Quick Ctrl+H and change out

_x0009_ Represents Tab Character
_x007C_ Represents Vertical Bar Character
_x002C_ Represents Comma
Set Delimiter to TAB ( \t )
<DTS:Property DTS:Name=”ColumnDelimiter” xml:space=”preserve”>_x0009_</DTS:Property>
Set Delimiter to Vertical Bar ( | )
<DTS:Property DTS:Name=”ColumnDelimiter” xml:space=”preserve”>_x007C_</DTS:Property>
Set Delimiter to Comma ( , )
<DTS:Property DTS:Name=”ColumnDelimiter” xml:space=”preserve”>_x002C_</DTS:Property>

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s