i search a TPT syntax but i'm not sure if it's possible.
i have an input fixed file's. Two columns as a varchar(15) and a varchar(8) and the second column can contain 8 space caracter wich convert it as null value.
In the block SCHEMA or OPERATOR, is it possible to define the conversion or is it only possible to the APPLY statement with case when syntax ?
DEFINE SCHEMA FILE_xxx
, bbb VARCHAR(8)
DEFINE OPERATOR FILE_xxx_READER
TYPE DATACONNECTOR PRODUCER
VARCHAR DirectoryPath = @DirectoryPath,
VARCHAR FileName = @FileName,
VARCHAR Format = 'Text',
VARCHAR TrimColumns = 'Both',
Thanks lot for response
If file is TEXT the SCHEMA fields should be CHAR.
You must use CASE WHEN in the SELECT ... FROM OPERATOR FILE_xxx_READER.