I am trying to query recipients based on some criteria stored in external database. I have joined external table as shown below and selected columns which will be imported, but when I test the query I am getting error below. Is there something am I missing?
XTK-170036 Unable to parse expression '[temp:[camp].[Loan]:@CIF]'.
your table name is weird. just keep it simple and use alphanumerical characters and if you want to separate words just use camelcase or underscores.