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
5 REPLIES
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