Set The Flat File Column Delimiter Programatically

hi guys,

i am working on a project witch involves creating packages on-the-fly to import data from txt/csv/xls files according to some definitions on the database.

so far, i have been doing fine.

now we are planning the ASP.net page that enables the customer to define the input file format that will be imported to the system. we want it to have the same listBox as the FlatFileConnectionManager Editor has to define some properties, such as - column delimeiter.

the code to set the column delimiter looks like this:

SSISRunTime.IDTSConnectionManagerFlatFile90 myFilecn = null;

myFilecn = (SSISRunTime.IDTSConnectionManagerFlatFile90)package.Connections["InputFileConnection"].InnerObject;

DtsConvert.ToConnectionManager90(package.Connections["InputFileConnection"]);

SSISRunTime.IDTSConnectionManagerFlatFileColumn90 col

col = myFilecn.Columns.Add(); //.....

string colDelimiter ="|" ; // it actually gets the data from the database... but it is the same thing

col.ColumnDelimiter = colDelimiter;



when we deal with the simple characters- "," , ";" , "|" ... we have no problems with setting the delimiter. but how can i set the delimiter to Tab? or {CR} ? {LF}?

i tried to look at the dtsx- XML , and i see that the column delimiter that is defined when i choose Tab is: _x007C_, but when i try to do something like this:

col.ColumnDelimiter = "_x007C_" ;

it doesn't work. the same happens when I try "{t}" or "Tab".

how do i solve this problem, and enable the user to select Tab as a column delimiter?

Thanks!