BODI_1130199

[Former Member]

Hi,

I am unable to 'update the schema'when using the sql transform, i am getting the below error.

How to rectify this, please any suggestions.

Thanks

santhosh

[vnovozhilov]

Please show the SQL text used in SQL Transform.

Thank you,

Viacheslav.

[former_member208363]

Hi Santhosh,

Please use your SQL as shown below :

SELECT DEPTNO

      ,DNAME

      ,LOC

  FROM MASTER_DB.dbo.DEPT   ----( <your DB name>.<owner name>.<Table Name>)

[vnovozhilov]

Actually the error message is pointing to something else. Have this ever worked before? Tell me about your setup - did you create system DSN or User DSN in ODBC Manager? Can you see the data in tables from Local Object Library?

Thank you,

Viacheslav.