Failure while using Salesforce Source Task

[SKonda]

Hi,

I am using dynamic query on Salesforce Source task to download data from Salesforce using your documentation. Everything seems to be working fine until today it was giving following error message.

Dynamic select query contains 390 columns in the list will that be a problem?

When I browse the data for Row:393:Column:25  data looks good.

[Salesforce Source [803]] Error: System.Web.Services.Protocols.SoapException: MALFORMED_QUERY: 

where LastModifiedDate  >

                        ^

ERROR at Row:393:Column:25

unexpected token: '<EOF>'

   at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)

   at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)

   at CozyRoc.Sforce.Service._SforceService.query(String queryString)

   at CozyRoc.Sforce.Service.SforceService.query(String queryString)

   at CozyRoc.SqlServer.SSIS.SforceSource.PreExecute()

   at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostPreExecute(IDTSManagedComponentWrapper100 wrapper)  

******************************************************************************* 
******************************************************************************* 
This message (including any attachments) may contain proprietary,  
confidential or privileged information and is intended only for the designated 
recipient(s) named above. If you are not an intended recipient of this message 
or authorized to receive this for an intended recipient, please note that any 
use, dissemination, or reproduction of this message is strictly prohibited and 
may be unlawful.  If you have received this message in error, please notify 
the sender immediately by reply e-mail and delete this message.

[Ivan Peev]

Hi,

Check your expression used to setup the SOQL statement. Most probably the issue is there.