If we are talking about Azure cloud, it has many capacity limitations based on your tier - https://azure.microsoft.com/en-us/pricing/details/sql-database/

The good candidate would be a table in OLTP database with huge number of inserts per second. Have you checked this article - https://docs.microsoft.com/en-us/sql/relational-databases/in-memory-oltp/overview-and-usage-scenarios ?

Red Gate SQL Source Control works almost with all source control systems - https://www.red-gate.com/products/sql-development/sql-source-control/

Is the SSIS service account has rights on that path? Check the security log on the server, that will give you more information.

There are many ways to do so...
On of them is using an undocumented procedure:

EXEC sp_MSforeachdb @command

Hi,

The listener require one IP address. In case of two cluster nodes you may consider a file share witness as well. https://blogs.technet.microsoft.com/askpfeplat/2012/06/27/clustering-what-exactly-is-a-file-share-witness-and-when-should-i-use-one/

Check that the 'Executed as user: Domain\User' has access to the share "\\SharedFolder\DTS_NAME.dtsx".