There seem to be four separate entities in that file (Company, Demographics, Claims, Procedures).

Is your aim to import the file into four separate tables? If not, what is your aim?

SQL Agent runs on the server on which it is hosted, no...

Sounds like it might be some sort of contention issue. You could try reducing the max degree of parallelism and see whether that helps.

Did you take a look at the...

Then you must have SELECT statements in your proc.

INSERT ... SELECT

does not output the selected data to the SSMS window.

You mean, the data? Where, exactly, are you 'seeing' this?

Are these packages running in series or parallel? Are they all hitting the same DB?

The error message you posted is not overly helpful.

Usually (as the message itself suggests), a more specific and helpful error can be found before that one. Please take a look...

In the Flat File Destination Editor, is the 'Overwrite data in the file' option checked?

Well done!

Not a lot of upvotes against that post!

Please post back with any findings.

Presumably you want to do this in a SQL query? Or is this an Excel question?

Can you add a sheet to the spreadsheet showing how you would like the results...

Thank you Phil, I think that will work when I do deploy to the SSISDB.

At the moment, dataverse is constantly being update with a new/deleted/updated columns which is why...

You are correct, my apologies!

You can avoid all parallelism by using the Sequence command in your JSON and setting maxParallelism to 1.

https://learn.microsoft.com/en-us/analysis-services/tmsl/sequence-command-tmsl?view=asallproducts-allversions

Default, Full, Clear and Recalc are the options I'm seeing on the 2017 Standard Edition I have immediate access to.