CRM SSIS Integration Components for Dynamics CRM

• Connection Manager
• Source Adapter
• Destination Adapter

Connection Manager

• Online & Onpremise support
• Connection Timeout
• IFD (onpremise), Active Directory (online & onpremise), Office365 (online)
• Impersonate User
• SSL
• Port
• Username & Password

Source Adapter

• FetchXML Query

Destination Adapter

• Batch Size
• All operations are Execute Multiple using 2 threads with batchsize set
• Mapping entities depending the operation type.
• Return GUID on Create operations and al rows processed
• Force specific culture
• Map to specific entity type for lookups.
• Mapping Refresh
• Ouputs: CRM OK with all outputs without errors. CRMErrors with all error outputs.

Supported Operations.

• Create
• Update
• Delete
• Upsert
• Status
• Execute Workflow

Check Wiki for more details