'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Use Kingsway SSIS for Dynamics 365 Option Sets and Lookups
Question details
The user needs guidance on utilizing Kingsway SSIS option-set and lookup components to migrate multiple fields simultaneously.
- Product
- Dynamics 365 / Kingsway SSIS
- Device & OS
- not provided
- Scenario
- Setting up a database integration to migrate multiple fields in a single operation using third-party SSIS lookup components.
- Observed behavior
- The correct configuration depends entirely on whether the target integration environment is Dynamics 365, Access, or SQL Server, requiring specialized community support.
Verify your exact source and target environments (such as Dynamics 365, Access, or SQL Server) and note your current SSIS version before seeking detailed configuration guidance.
Seek Configuration Guidance in the Dynamics 365 Community
Since Kingsway SSIS is a third-party tool tailored for Microsoft integrations, the best place for Dynamics 365-specific lookup queries is the official community forum.
The Dynamics 365 Community is highly active and filled with integration experts who frequently work with third-party tools like KingswaySoft to handle complex option sets and lookup fields.
Document your specific Microsoft product version (e.g., Dynamics 365 Online or On-Premises) and the specific fields you are trying to map.
Navigate to the official Microsoft Dynamics 365 Community forums online.
Create a new thread detailing your Kingsway SSIS setup, mentioning that you are trying to migrate multiple fields using the option-set and lookup components.
Consult the SQL Server Community for SSIS Issues
If your primary challenge is related to SQL Server Integration Services (SSIS) component behavior rather than Dynamics 365 specifics, the SQL Server Community is the ideal resource.
Manage Your Migration Data Mapping with WPS Office
While WPS Office does not directly execute SSIS database integrations, it serves as an excellent, lightweight alternative for analyzing exported migration data, reviewing CSV mapping sheets, and generating integration reports without a heavy Microsoft Office subscription.
- 1. Download and Install: Get WPS Office Free from the official website and install it on your workstation.
- 2. Open your mapping files: Launch WPS Spreadsheet and open your .csv or .xlsx option-set mapping files.
- 3. Analyze and prepare data: Use built-in data filtering and text-to-columns features to clean your data before running your Kingsway SSIS package.
Frequently Asked Questions
What are Option Sets in Dynamics 365?
Option Sets, now frequently referred to as Choices, are specialized fields in Dynamics 365 that allow users to select from a predefined drop-down list of values. Mapping these correctly in SSIS requires matching the integer value behind the text label.
Why use third-party tools like Kingsway SSIS for Dynamics migrations?
Native SSIS lacks built-in, optimized connectors for complex Dynamics 365 API structures. Third-party components like KingswaySoft provide specialized adapters that natively understand Dynamics 365 metadata, handling complex tasks like option sets and lookups automatically.
Can I use Kingsway SSIS to migrate data from Microsoft Access?
Yes. While Kingsway components handle the Dynamics 365 endpoint, you can use standard SSIS OLE DB or ODBC source components to extract your legacy data directly from a Microsoft Access database.
