It also looks like you are not performing regular frequent transaction log backups.  In SQL Server - when the database is not in simple recovery model, you must take frequent...

I would take the time to reinstall/reconfigure the workstations - using a CNAME alias instead of the actual server name.  In the future when you have to perform another upgrade...

That is very interesting - learn something new every day.  Thanks for the update.

Is this part of an availability group?

So you changed it from Azure to an Azure Managed Instance - and no, it isn't currently possible to setup an AG with an on-prem instance and an Azure Managed...

Another option is to use SSRS instead of SSIS - which then gives the end users a portal where they can access the 'report' and export it whenever and however...

It should be possible - I think it depends on the version and maybe edition.  How much effort is involved in setting it up may have changed with SQL Server...

Since the installation now includes enabling that feature - and when checked it places the per-service SID in the appropriate local policy, I am not sure why there is any...

I am not sure why you are questioning using the service SID in that rights assignment.  The installation media from 2016 and up now includes the ability to set that...

I can make a couple of recommendations:

1. Move checks that exit out of function - no need to call the function if the parameters being passed in will just exit. ...

The other option is to convert those CR and LF to text values that you can then convert after importing.  If you use a tab delimited - or pipe delimited...

🙂

But you are still using the linked server to...

As stated before - convert the dates to UNIX timestamps and use those values in your query.  I would not try to figure out the end time unless the time...

Pretty sure I provided an example already.