Error Data Pipeline -> Dynamics Plugin with Dataverse connector

Hi Vivien,

I have been using copy data to push data from SQL to Dynamics and have found the errors generated when copy data fails often to be obscure.

For example - 
ErrorCode=DynamicsOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Dynamics operation failed with error code: -2147204784, error message: Sql error: Generic SQL error. CRM ErrorCode: -2147204784 Sql ErrorCode: -2146232060 Sql Number: 515.,Source=Microsoft.DataTransfer.ClientLibrary.DynamicsPlugin,''Type=System.ServiceModel.FaultException`1[[Microsoft.Xrm.Sdk.OrganizationServiceFault, Microsoft.Xrm.Sdk, Version=9.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]],Message=The creator of this fault did not specify a Reason.,Source=Microsoft.DataTransfer.ClientLibrary.DynamicsPlugin,'

Generic SQL error in this case turned out to be a timeout when trying to pull data from a large entity in dataverse into SQL (attachment I think from memory)

In your case given you seem to simply be trying to push connection data from dataverse to a DB, I would suggest trying to use a query and restrict the query to a handful of rows (connection can be quite large in my experience)
e.g. (change the entity to whichever is relevant for you)

Hope it helps
--Mike