What else is happening in the DTSX?  Can you post a screen grab of the control flow and data flow?

Something is injecting the additional value somewhere in the process

Script and test and destroy, rinse and repeat a number of times until all things have been ironed out.

This will give you then a proven strategy on how to do...

Can we assume that you have a QA/Test environment which is intended to be a close-to exact copy of Prod? If so, does the problem happen there too?

If not,...

No a DB can only be part of 1 AG.

But you can switch servers to be Sync or ASync.

Usually this is done for DR purposes, 3 node AG, 2 in...

This is by design.

SQL is designed to be the only thing on the server.  It will consume what you tell it to consume.  So you said to consume 24GB which...

• This reply was modified 5 years, 9 months ago by Ant-Green.

What part is troubling you?

You would just setup a connection manager as normal.

There will be caveats like ensuring a network link is in place between Azure and On-Prem, firewalls open...

If you move SSIS away from the main SQL server you have to have a license for it.

In fact moving any component, SSRS/SSAS/SSIS/DQS/MDM/Distributed Replay etc etc to some other server...

As with anything licensing, your best off speaking to Microsoft and/or your license reseller, they know your specific terms, do not take what is said on a public forum as...

Are both in the same subnet or are they in different subnets?  Do you have register all IP's enabled? Any DNS caching gone a miss either where your local caches...

100% sure that the user has connected to the right server hosting the right database?

In SSMS you should be able to see all databases on the server, even if you...

You can also as alternatives, use extended events and capture the logon session event.

You can also switch the SQL default login method from being failed logins, to successful and failed...

This was a bug with installs of 2000 - 2008 not seen it in 2012 or above, but the fix back then was to perform the below

Open Regedit

Find the key...

There is a 32bit version of the plugin

https://www.microsoft.com/en-us/download/details.aspx?id=52677

There was a time MS advised installing 32bit office over 64bit, but think those times are over.  Depends what your IT teams will...

As I think about it, quorum might be an issue, but as it's async anyway and has a potential for data loss, then a forced manual failover should the FCI...

Yeah essentially.

The two nodes in the FCI will act like normal, providing local HA. (1 instance).  Then the Azure VM would provide DR (1 instance)

Never done it myself, only ever...