Create either a standalone application or SSIS package that will update the CRM account data using the following logic:
1. If account number matches between CRM Account and ERP Account, update account name, address1, address2, address3, city, state, zip, and phone.
2. If account number is empty in CRM, attempt to match based on account address1, city, state and zip. If a match is found, update account name, account number, address2, address3, and phone.
3. If no match is found in CRM for the ERP account, create it and assign the owner as "SYSTEM IMPORT."
The ERP data is available via an MSSQL view.
The CRM system is Dynamics CRM 2016 hosted on premise with IFD.
The SSIS package must not be dependent on any other licensing (such as Kingsway Soft).
The application/SSIS package must be capable of running on a scheduled basis without user interaction.