SSIS Integration Toolkit for Microsoft Dynamics SL

To connect to your Dynamics SL web services, you utilize the Dynamics SL Connection Manager. You'll need to specify the Service URL of your Dynamics SL web services, the Company you wish to connect to, and your authentication credentials (Windows Integrated Authentication or User Name/Password/Domain). This manager ensures a secure and reliable link for all your Dynamics SL data operations.

Yes, the Dynamics SL Source Component allows for precise Dynamics SL data extraction. You can select a specific Source Object (e.g., Customers) and even Child Objects (e.g., Contacts within Customers). Furthermore, you can apply SQL-like filter criteria to both Source and Child Objects to retrieve only the data you need, optimizing performance for Dynamics SL reporting and custom SL data exports.

The Dynamics SL Destination Component empowers you to efficiently manage your data within Dynamics SL. You can perform Create new records, Update existing records, and Delete records. For update and delete operations, you'll specify a Primary Key Field to uniquely identify the records. This component is key for Dynamics SL data updates, SL record management, and maintaining data integrity in your ERP system.

The Dynamics SL Destination Component offers robust error handling options. You can choose to Fail on error, Redirect rows to error output, or Ignore error. The "Redirect rows to error output" option is highly recommended for Dynamics SL integration troubleshooting, as it diverts failed records to a separate output, providing an ErrorMessage column that details the specific error reported by Dynamics SL or the component itself.