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
Related Articles
How to modify the source dynamically at runtime
The Object, ObjectFilter or Statement parameters are available for setup in the data flow properties list. Follow these steps to set up an expression: Right-click on the data flow canvas and select Properties from the menu. Scroll-down and find a ...When I try to select entity in Dynamics CRM Source component I get error: "No connection could be made because the target machine actively refused it". Dynamics CRM Connection Manager 'Test Connection' command works fine.
If you have recently reinstalled your Dynamics CRM server and selected different access port, you have to make additional updates on your server. For more information review KB947423.Error Message: Object reference not set to an instance of an object - When TargetServerVersion set to SQL Server 2012.
Action: After switching the TargetServerVersion in Visual Studio to SQL Server 2012, I received the following error message. (This is reproduceable in VS2019 and VS2017.) Error Message: "Object reference not set to an instance of an object" Solution: ...Salesforce Destination: How to modify a Salesforce Destination object dynamically at runtime
The destination object is available in the data flow properties list. Follow these steps to set up an expression: Create a variable that can be loaded with the desired name of the destination object. Right-click on data flow canvas and select ...Error Message: "Could not initialize component for use in the designer."
Action: While creating a new CRM destination, the following error is encountered. Error Message: TITLE: Microsoft Visual Studio ------------------------------ The component could not be added to the Data Flow task. Verify that this component is ...