I want to use CTRL-A as delimiter for TPT exports, I would like to know how to specify this in the TPT script.
Thanks & Regards,
There is an attribute for the DataConnector operator (I think still undocumented) called TextDelimiterHex.
Set that to '0A' and the DC operator should write out that character as the field delimiter.
Thank you Steve,
Alternatively, i tried specifying CTRL-A in the Textdelimiter attribute by giving CTRL-V CTRL-A through vi editor and this is able to export data with CTRL-A delimiter.
VARCHAR TextDelimiter = ^A