| Symptom | Likely Cause | Fix | |---------|--------------|-----| | | Invalid OAuth token or wrong OData URL. | Run the Web Service Task manually; check the Src_Dynamics_OAuthUrl and client secret. | |
| Feature | Description | |---------|-------------| | | Microsoft Dynamics 365 (via OData) and a legacy Oracle DB (via OLE DB) | | Transformations | Data cleansing, lookup‑based enrichment, Slowly Changing Dimension (SCD) Type‑2 handling, and aggregations | | Target | Azure Synapse Analytics (dedicated SQL pool) and a staging Azure Blob storage | | Scheduling | Executed nightly via Azure Data Factory (ADF) or SQL Server Agent | | Parameters | Dynamic connection strings, date range, and “Full vs Incremental” mode | ssis-372
# From the solution folder MSBuild .\SSIS-372\SSIS-372.dtproj /p:Configuration=Release /t:Build | Symptom | Likely Cause | Fix |