Let's start with it supporting only the advanced edit. No SQL update command available.
No video tutorial to demonstrate how to do the "where" clause.
In the end I found the ID column and connected it to the SSIS ID of the input. - Very unfriendly!
Dynamics Destination Task
Dynamics Destination Task
Last edited by Oky on Tue 16 Feb 2016 20:33, edited 1 time in total.
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: Dynamics Destination Task
Sorry for the late response.
SSIS Data Flow Components for Dynamics CRM components have the same function as other SSIS components, for example OLE DB Data Source or OLE DB Destination.
SSIS Data Flow Components have documentation. If you selected the 'Help' check box during the Devart SSIS Data Flow Components installation, the documentation can be accessed from Start Menu->All Programs->Devart SSIS Data Flow Components->Documentation. You can also find the help file at https://www.devart.com/ssis/download.html
This documentation applies to all data sources, supported by Devart SSIS Data Flow Components. The following sections can be useful for you::
1. Getting Started.
2. Tutorials - examples of using SSIS Data Flow Components for Salesforce. SSIS Data Flow Components for various sources have much in common, so you can understand how to use the components for Dynamics CRM with these examples
3. Data Source Connection Settings - Cloud CRM Connections -> Dynamics CRM
4. Custom Properties Reference.
SSIS Data Flow Components for Dynamics CRM components have the same function as other SSIS components, for example OLE DB Data Source or OLE DB Destination.
SSIS Data Flow Components have documentation. If you selected the 'Help' check box during the Devart SSIS Data Flow Components installation, the documentation can be accessed from Start Menu->All Programs->Devart SSIS Data Flow Components->Documentation. You can also find the help file at https://www.devart.com/ssis/download.html
This documentation applies to all data sources, supported by Devart SSIS Data Flow Components. The following sections can be useful for you::
1. Getting Started.
2. Tutorials - examples of using SSIS Data Flow Components for Salesforce. SSIS Data Flow Components for various sources have much in common, so you can understand how to use the components for Dynamics CRM with these examples
3. Data Source Connection Settings - Cloud CRM Connections -> Dynamics CRM
4. Custom Properties Reference.