When using the Dynamics CRM source from the CozyRoc CRM connection manager, the following error message is received.
The connection tests successfully and viewing data through the data flow task is possible, but it failed with the error during validation.
Delegate token node not found.
The soap envelope also returns the following<s:Reason><s:Text xml:lang="en-GB">ID3242: The security token could not be authenticated or authorized.</s:Text>
</s:Reason>
Please check what your Package Protection Level is. If it is DontSaveSensitive, then all sensitive information like passwords are completely removed from the package. This option can only be used if you provide your passwords from external configuration file or a table.