My SQL server administrator could establish a connection with our salesforce sandbox instance and could bulk insert brand new records. However, he couldn't update the existing records as the record ID is not available in the table.
We are getting the following error when we tried to update the records with the name:
Error: 0xC002F304 at Stores-Staging-Target, SF_Store : An error occurred with the following error message: "(1) Id not specified in an update call [STATUS: MISSING_ARGUMENT]".Error: 0xC02090F9 at Stores-Staging-Target, SF_Store : The SF_Store was unable to process the data.Error: 0xC0047022 at Stores-Staging-Target, SSIS.Pipeline: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "SF_Store" (2) failed with error code 0xC02090F9 while processing input "Salesforce Destination Input" (15). The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure.