Error Filtering Recipients With External Database Table [FDA]

[ersann]

Hi,

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]'.

[pierrec70731455]

Hi,

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.

Kind regards,

Pierre

[ersann]

Hi pierrec70731455​

My table name is 'Loan', schema name is 'camp' (like dbo). This table exists on remote mssql server.