posts - 218, comments - 410, trackbacks - 27

My Links

Advertisement

News

Follow billgraziano on Twitter

Article Categories

Archives

Post Categories

Consulting

SQL Server

Using a Custom Field Delimiter in SSIS Text File Import

Recently I was writing an import in SSIS and needed to use a ASCII 127 as delimiter.  I know you can type a custom delimiter into SSIS but ASCII 127 is the delete character.  Steve Kass reminded me that SSIS' .dtsx files are just giant XML files and easy to edit.  It was as simple as changing this line:

<DTS:Property DTS:Name="ColumnDelimiter" xml:space="preserve">_x007F_</DTS:Property>

007F is the hex code for ASCII 127.  Thanks Steve!

Print | posted on Sunday, February 04, 2007 12:26 PM |

Comments have been closed on this topic.

Powered by:
Powered By Subtext Powered By ASP.NET