Is the data type on both local and remote VARCHAR or is one of them NVARCHAR

Just ALTER on the table is the minimum permission for TRUNCATE

This is the extension.  Can search for it in VS or download and load in the VSIX file manually.

https://marketplace.visualstudio.com/items?itemName=ProBITools.MicrosoftReportProjectsforVisualStudio

Get a copy of Visual Studio (community is fine) add in the SSRS extension, then create a project and start building your reports in the designer.

Probably would want to look...

I would try a repair option via the installation media to try and repair the install then do an uninstall again, if certain files are not present the uninstallation will...

Also anything from the event viewer on the starts also to help debug

The uninstall will have produced a log output with a lot of information in it.  Can you post that or take a look through it see if anything obvious stands...

Probably even a DTU model or serverless if you want to really save on costs, depends on the performance you need

In the SQL job step, set an output file on the step to log the full error message to a text file.

The agent history is notorious for truncating the error...

This sounds like a case for an Azure SQL Database something which is publicly facing without the need to setup an enterprise style network and allow access in via VPN...

SSIS is fairly rigid in how it works, so you have to be wary of DDL/Schema drift.

You can easily create a SSIS package which will copy ServerA TableA to ServerB...

Nearly right, plans are read Top to Bottom, Right to Left

1 use a query to extract the pieces you need, look at the QUERYOUT option of BCP for this.

2 there is no QUERYIN option, so if you only wanted to...

Permissions are cumulative, so a user who is part of 2 groups will have the combined privileges of both.

Remember DENY trumps a GRANT, so any DENY in one group will...

Employment date is also the wrong format, extra 0 it would seem 20018 guessing should be 2018