fix: Resolve issues related to RIG move permit types with TPS migration

[john-fletcher-aot]

Description

Fix issues with migrated RIG moves. Issues resolved include:

• Potential duplicate permit numbers generated with random number suffix
• Multiplicated records in PERMIT_DATA table for RIG moves with multiple vehicles

Also added count of records migrated to ETL_PROCESSES table for tracking.

Note that changes were also made to the SSIS project - this is stored in MOTI SVN and not in git.

Fixes # ORV2-1468 (partial)

Type of change

• Bug fix (non-breaking change which fixes an issue)

How Has This Been Tested?

• Executed migrations from TPS_TEST into local ORBC database using all SSIS scripts, verified no errors and that results in database match expected

Checklist

• I have read the CONTRIBUTING doc
• I have performed a self-review of my own code
• I have commented my code, particularly in hard-to-understand areas
• I have made corresponding changes to the documentation
• My changes generate no new warnings
• I have added tests that prove my fix is effective or that my feature works
• New and existing unit tests pass locally with my changes
• Any dependent changes have already been accepted and merged

---

Thanks for the PR!

Deployments, as required, will be available below:

• Frontend
• Vehicles
• Dops
• TPS-Migration

Please create PRs in draft mode. Mark as ready to enable:

• Analysis Workflow

After merge, new images are promoted to:

• Merge Workflow

[praju-aot]

approved