topic Re: SAS Data Management Studio 2.9 connection error in SAS Data Management

SAS Data Management Studio 2.9 connection error

MMar — Fri, 30 Oct 2020 20:15:19 GMT

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.

Re: SAS Data Management Studio 2.9 connection error

VincentRejany — Mon, 02 Nov 2020 10:42:31 GMT

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

Re: SAS Data Management Studio 2.9 connection error

MMar — Wed, 04 Nov 2020 09:36:02 GMT

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.

Re: SAS Data Management Studio 2.9 connection error

VincentRejany — Fri, 13 Nov 2020 10:30:58 GMT

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