This will depend on what changes were made...

This doesn't make sense - you already have a cluster built...across at least 2 servers (nodes)?  And - you have setup an AG between 2 of those instances?

What you need...

You are still using a DOS batch file - you should switch to a Powershell script (.ps1).

For example - to loop over a directory contents: Get-ChildItem -Path E:\Test

To loop over...

Where are you seeing this - a little more context would be helpful.

Just curious - but why are you using a domain service account to run a system level task?  You can set that task to run as SYSTEM since it does...

I think you are confusing what an 'instance' is...I believe you meant to say you have 4 servers.

If your goal is to have an FCI instance across 2 nodes -...

Or a script component to parse each...

We have to transfer the data to other system in real time.

The other table resides in oracle database.

So first I am testing with sql table  if it works then...

This is actually really easy in SSIS. Select the connection manager in the connection managers pane and hit F4 to open the properties pane. Find Expressions, and open that...

You could also change from a CROSS APPLY to an OUTER APPLY.  If nothing is returned from the function then use ISNULL/COALESCE to set the value as needed.

Ideally - you...

Thanks Grant.

And where are these transactions held? Within the transaction log presumably? If so, do the transaction log backups that have been done not have an effect ?

Assuming the...

In Object Explorer - open the Schema section under Security for that database.  In that section you will see a list of schemas - now in Object Explorer Details look...

Missed the fact that this was an...

Missed the fact that this was an SSRS forum. ...

What is the reason for using SSMS to connect to SSRS?  There really isn't a reason to do so - and you can only connect using the same version of...