I am pulling log table data into a flat file using the TD extract command. I am seeing some type of control character or special characters in the query id. I am pretty certain it's a surrogate key, so it seems it should just be a number of sorts. I have a photo of a small piece of the extract from Notepad ++
Any ideas as to WHY there are either control characters in the query id in the log table.... or why the extract command is creating them in the extract process?
Looks like a two byte binary value, which is usually the result of exporting a concatenated VarChar using FastExport in Text format (i.e. the length of the VarChar).
Depending on the number of rows you better use BTEW Export or switch to TPT, which supports native Deleimited output.
First - Thanks for your reply.
Secondly.... I'll be exporting an entire day's worth of log data, which can be thousands (sometimes hundreds of thousands) of rows.
So .... which export tool do you think is best?