how to use unload component in talend?

[k526]

Hi,

am using redshift.i used select query in unload component in talend.

 it was working in redshift but in talend its not working .I was getting an error 

unterminated quoted string at or near "'

My query:

 select campaignid,code,' 'as campainmember,' ' as lead,''sun'' as leadname from ms_is.bystyn.

 is there any one to unload the file with header?

can anyone help me ?

Thank you

[Rahul_V]

Found Workaround:
Use tRedshiftinputrow component and use your "unload query" to get the headers option in all the files.

Regards,
Rahul