Incorrect syntax near the keyword 'WHERE'.

One Star

Incorrect syntax near the keyword 'WHERE'.

Hi All,
I am doing a simple jobs to load data from 1 table to another.. but when i try to run the job..this message-Incorrect syntax near the keyword 'WHERE' appear. Even though the job is actually successful, but is anybody know why it still prompt out the message during the execution of that job?

attached is the screenshot of my job. thank you

regards,
fuzaimi
One Star

Re: Incorrect syntax near the keyword 'WHERE'.

Hi
You didn't upload the screenshot successfully.
Best regards!
Pedro
One Star

Re: Incorrect syntax near the keyword 'WHERE'.

Hi Pedro,
below is the attachments.
regards,
Fuzaimi
One Star

Re: Incorrect syntax near the keyword 'WHERE'.

Hi
With that error it means that you've constructed the query incorrectly.
Please show me the query in tMSSQLInput.
Best regards!
Pedro
One Star

Re: Incorrect syntax near the keyword 'WHERE'.

Hi Pedro,
This is the query from the tMSSQLInput1 in my job. Sorry because most of the column is in Malay language. But from what I have seen in this query there are no 'where' statement on it. I have try to put 2 columns in the target table instead of 1 column, and it works fine. I am just wondering why if I try to put single column on the target table the message Incorrect syntax near the keyword 'WHERE' appear.
"SELECT S_CC_ADUAN.ID_ADUAN,
S_CC_ADUAN.ID_LOG,
S_CC_ADUAN.NAMA,
S_CC_ADUAN.NO_KP,
"+
" S_CC_ADUAN.NO_TELEPON,
S_CC_ADUAN.EMAIL,
S_CC_ADUAN.ALAMAT,
S_CC_ADUAN.ALAMAT2,
S_CC_ADUAN.ALAMAT3,
"+
" S_CC_ADUAN.KOD_NEGERI,
S_CC_ADUAN.TARIKH_ADUAN,
S_CC_ADUAN.MASA_ADUAN,
S_CC_ADUAN.TAJUK,
"+
" S_CC_ADUAN.ID_KATEGORI,
S_CC_ADUAN.ID_PROJEK,
S_CC_ADUAN.ID_SUMBER,
S_CC_ADUAN.SALURAN,
"+
" S_CC_ADUAN.KOD_BAHAGIAN,
S_CC_ADUAN.PENERIMA,
S_CC_ADUAN.TARIKH_DAFTAR,
"+
" S_CC_ADUAN.PENDAFTAR
FROM S_CC_ADUAN"

regards,
fuzaimi

Re: Incorrect syntax near the keyword 'WHERE'.

Hi mfuzaimi,
is your output a straight insert or is it an update?
Regards,
Brandon

Calling Talend Open Studio Users

The first 100 community members completing the Open Studio survey win a $10 gift voucher.

Start the survey

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Why Companies Move to the Cloud: 7 Success Stories

Learn how and why companies are moving to the Cloud

Read Now