have a look at https://github.com/aleonard763/SSISFrameworkCommunityEdition
It kind of contains most of the details you need to implement your desired functionality - even a master package to control all others.

There are others - but one that always comes to mind is http://www.dba-oracle.com/

it is possible. but you haven't given enough details to give you a working solution.

assuming you have a list of pairs as per your input you would do...

there is a limitation imposed - even when doing a create db (and possibly a restore)

Program files and data files cannot be installed in the following situations:

March 8, 2019 at 1:23 pm

#2023980

My memory may be incorrect, but if not mistaken for double hop you do need to have a AD account - GMSA or MSA would be the best as no...

One possibility - depends on how frequent updates/inserts/delets are done on those 2 tables.
Also assumes you have enough space available to hold an extra copy of the tables.

if you are already coding in C# then look at using the available .net to process csv files - after that its easier to deal with the transformation of dates...

your best option is not to use passwords at all.
change all your accounts to be MSA/GMSA accounts - GMSA more versatile as they can be used in more than...

That is a common "error" for must users of Power BI.
Although it asks you initially to sign on, you can close that window as you do not need to...

I think there may be more to this than just a simple insert.
Would it be possible to post here a actual explain plan of that insert (and if this...

yes - but why would you do it if there are better and easier ways to do it?
you can study the openxml model, and create the same...

adding to this . you do not even need to have a PK/FK and you can still join them.

Although FK with indexes will help in some cases from...

you may not be able to see them on ssms - but you can still execute them on the remote server.

you are obviously out of your league. I do advise you to ask for help from another DBA - or at least ask on the forums here before attempting to...