Changing database for same connection is not working

When I change the database where my SQL connection is pointing to, this is not reflected in the dataflow correctly and the flow does not run.

Seems to be a problem with the insert identity statement

Advanced ETL Processor Version: 6.3.6.16
Windows 10
Database version: MSSQl v12 (Azure db)

Can you post here insert script as text so we can see it, please

SET NOCOUNT ON;
SET IDENTITY_INSERT [FMS].[dbo].[AspNetUsers] ON
insert into [FMS].[dbo].[AspNetUsers] ("Id","Email","EmailConfirmed","PasswordHash","SecurityStamp","PhoneNumber","PhoneNumberConfirmed","TwoFactorEnabled","LockoutEnabled","AccessFailedCount","UserName" ) values (?,?,?,?,?,?,?,?,?,?,? )
SET IDENTITY_INSERT [FMS].[dbo].[AspNetUsers] OFF
SET NOCOUNT OFF

I have already uploaded a screenshot of the dialog to show the correct table names on the left with the incorrect insert statement

I am very confused here why you are using Insert statement to load the data?

I think in your case this the slowest way of loading the data

Our software will not modify insert statement for you if you change the database, you have to modify it yourself.

I am not using insert statement (Use user defined SQL is not ticked), this was just to show you what was being generated.

I just tried to run the dataflow as it was with the changed connection properties and just keeps failing