SQLTeam.com | Weblogs | Forums

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:

This is a companion discussion topic for the original entry at http://billg.sqlteam.com/2007/02/04/using-a-custom-field-delimiter-in-ssis-text-file-import/