Error Messages
Error Message: MALFORMED_QUERY: unexpected token: True
Action: While using the Salesforce Source, the following error message was returned. Error Message: 'MALFORMED_QUERY: unexpected token: True' Solution: MALFORMED_QUERY is a dead giveaway that the query sent to Salesforce was not in proper syntax. ...Error Message: You need to enter the Server Password
Action: When executing a package that includes Salesforce Source Component I get the following error message: Error Message: You need to enter the Server Password Solution: In the Package properties, there is a property called ...Error Message: "Failed to process ... for column COLUMN_NAME"
Action: The Salesforce object I am using has new columns and I am trying to add the new columns and map them to our destination table. When I execute the package I get the following error: Error Message: "Failed to process ...Error Message: No such column exists
Action: When executing a package with Salesforce Source I get the following error message: Error Message: No such column exists Solution: 1. Please make sure the columns names in your package are spelled correct. ...Error Message: No such column 'contractid' on entity 'Opportunity'.
Action: When executing an SSIS package containing a COZYROC task and/or component, the following error is encountered. Error Message: No such column 'contractid' on entity 'Opportunity'. Solutions: By default Contract field on ...Error Message: License file C:\Program Files (x86)\CozyRoc\SSIS\License.dat is busy.
Action: Deployed package to SSIS catalog Ran it and noticed it was running very slow – it used to take ~50 seconds but was now taking ~1,000 seconds Looked at SSIS message log and saw several messages saying “access to License.dat is denied” Error ...Under SQL 2005, when I try to get list of Salesforce objects I get error: "Object reference not set to an instance of an object."
Make sure you have at least SP2 installed. To determine current version open SSMS and enter the following query: select @@version The reported version should be 9.00.3042.00 or above.
Book a Presales Call
Are you new to COZYROC and evaluating our solutions?
Book a Presales Call with us now and get 5% off SSIS+.
Book a Presales Call with us now and get 5% off SSIS+.
Popular Articles
How To verify Microsoft Integration Services is installed on SQL Server
SQL Server Integration Services (SSIS) is a component of SQL Server and can be installed with or without SQL Server. The same SQL Server setup can be used to install Integration Services on the server that SQL Server is installed on. SSIS is a ...FLEE Expressions for filtering
FLEE expressions are used to define criteria for filter parameters in several COZYROC tasks and components. FLEE is a “Fast, Lightweight Expression Evaluator.” Finding documentation to help you configure a valid expression can be challenging. The ...I see a response returned from the web service, but the preview in REST Source does not show any data.
CozyRoc Rest Source Component allow you to Read data from REST API. Developer can quickly extract response data from desire endpoint using HTTP Method (GET, POST) and Output into column data. In this article we will walk through some examples that ...How long is the grace period after the subscription has expired?
We noticed that our license is going to expire soon and we are in the process of renewing the license and it might take couple of days. We are wondering if you can provide a solution to use your product in our production system temporarily without ...How to resolve File Transfer Task failing when no files exist.
This KB article is not relevant if you are using "Get Remote Files List" action on File Transfer Task. Instead, you can use this COZYROC prepared Javascript: https://www.cozyroc.com/ssis/script-ftp-file-exists-task If you are not sure there will be ...