Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Error Filtering Recipients With External Database Table [FDA]

ersann
Level 2
Level 2

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

1760756_pastedImage_0.png

1760757_pastedImage_1.png

1760758_pastedImage_4.png

1760764_pastedImage_8.png

2 Replies
pierrec70731455
Level 5
Level 5

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
Level 2
Level 2

Hi pierrec70731455

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