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. ...
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 ...
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 ...
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. ...
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 ...
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 ...
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.