Q:

How do I get Talend tDBBulkExec component to accept a text enclosure?

I'm trying to take data from IBM DB2 and dump it into SQL Server via the tDBBulkExec command. I have situations where there is a field that a "comment" where users can enter everything. tDBBulkExec is pretty rigid in it's options for determining the format of the remote file and only has options for the field delimiter and the row delimiter. Is there any way to get it to recognize that a field is comprised of text?

A:

tDBBulkExec doesn't allow for field enclosure. The solution was to use .replaceAll(";","") on fields that allowed or contained the column delimiter.

