How do I code a TAB Chr(9) in SSIS

• bjohnson-684637

  SSC Enthusiast

  Points: 138

  More actions

  November 25, 2008 at 2:49 pm

  #196635

  In SSIS I need to process a tab delimited flat file with records of varying length.

  I'm using a Script Component to redefine the fields but I need to use a TAB to as the column delimiter, I've used the following for comma seperated file in the past:

  columnDelimiter() As Char = CType(",", Char())

  I can't just replace "," with Chr(9).

  Anybody ideas would be greatly appreciated.

• bjohnson-684637

  SSC Enthusiast

  Points: 138

  More actions

  November 26, 2008 at 2:57 pm

  #904063

  found it, I can use vbTab for the Chr(9) like

  Row.DB = Tokenise(Row.line, vbTab, 1)

  😀