but we don't always know the name of the instance (Always only 1 SQL Server running on a single server). If this was easy, we'd just run: ...

SQL Server Management Studio (SSMS ... an option presents itself to generate a script of the said job. However it is only possible to script one object at a time – so for five jobs, repeat ...

Here are the basic steps to automate an FTP download in Windows followed by a CSV insert into MS SQL Server ... another server via FTP. In Windows you can accomplish this using a script to ...