SAS Data Integration Studio jobs that contain the Table Loader transformation might generate incorrect code when using table options. You can specify the options in the properties of the Table Loader transformation via the Table Options tab as Additional Table Options or as an Advanced Option (such as a Where condition).
The problem occurs when you omit the following statement from the code generated by the transformation:
%let etls_tableOptions =;
Due to the statement being missing from the generated code, the table options are applied to the source table twice during the append processing. An error message might not occur.
There is no workaround for this issue.