ELTO Monthly BAU process
How often does this need to be done?
Once per month. 14th of the month or the next available business date after the 14th.
Why?
See Attached document -> ELTO Processes.docx
How?
We need to run an SSIS package that creates an upload file.
The upload file needs to be placed into Sharepoint – the business consumes the file.
Clone the Operation Reporting ssis solution from the GIT repository in Accelins organisation.
Open the Operational Reporting solution locally in Visual Studio 2019 or higher.
Open the BelgiumVPT package.
Go to the [Underwriting].[dbo].[tEltoSubmissionBelgium] database table on PRODUCTION. Look at the table and determine the next FileSubmissionIDStr e.g. where the SubmissionDate is NULL. This will be used in the SSIS package variables to create the file. The table looks like the example below.
Update the package variable FileSequenceNumber with the next FileSubmissionIDStr.
Make sure that you have a local folder created to hold the ELTO files and set the Package variable as necessary. In the example above, I am using the F:\ELTO\Belgium folder.
No need to change any other Package variables.
Run the package. This will usually take around 1minute to run. The datetime will be updated in the tEltoSubmissionTable shown above.
You will see a header, footer and body file created in your local folder.
Upload the produced file to the Sharepoint folder using the link below:
https://accelins.sharepoint.com/sites/TechnologyTeam/Shared%20Documents/Forms/AllItems.aspx?id=%2Fsites%2FTechnologyTeam%2FShared%20Documents%2FELTO%20Reports%2FMonthly%20ELTO%20Submissions%2FAK02%20%28Belgium%29&viewid=f57630c7%2D549f%2D4fa5%2D9a14%2D996ba4ae7444