SAS Data Management Studio 2.9 connection error

[MMar]

Hello SAS Community,

I'm workin on a migration project from an older version of Dataflux to the version 2.7 and I am dealing with an error that I can't understand, so I wanted to share it and see if you can suggest some possible ways to solve it.

The error happens when I run a test data job on the new version and it says this in the log for data source level:  

[1:SOURCE_ODBC:Data Source 1] [42000] Syntax error at or near "." (-2118139636)

Any ideas on how to tackle this?

Thanks a lot and kind regards.

[VincentRejany]

You may have to surround the table name or schema with double quotes

[MMar]

Are you talking about the input table used by the dataflux job or another one?

Also where is it possible to edit the mentioned table name?

Thanks a lot for the help.

[VincentRejany]

Can you try to use a SQL Query input and evaluate if you get the same error?