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?
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"
