I'm not aware of such setting. https://docs.microsoft.com/en-us/sql/integration-services/data-flow/flat-file-custom-properties?view=sql-server-ver15

I guess it is usually handled at the input side / codesnippet to make sure you don't go over 96mb of data

It could be timing out. Contact your McAfee ePO vendor.

An sich it shouldn't be a cause for the empty dashboards.

Normally the collation order is column >  database > server. Maybe it's connecting to the wrong database?

So the step to 2017 was required?

Log can grow larger than data ( it also needs to log index activity) for making rollback possible.

Delete in small batches to minimize duration and locking. (it may be locked...

You might try kinit https://stackoverflow.com/questions/62774343/cmd-command-runas-equivalent-in-macos

Hello Sam,

I would start with User specific chosen queries ( as you get paid for those )

As tuning can be a lengthy process , you can stop when it's good...

As far as I know the certificates are required if you want to encrypt the client-server communication so that passwords and data aren't sent in plaintext across the wire

Thanks for the answers.

With VS 2019 you can target SSIS to 2012,2014,2016,2017,2019.

Can't tell you about SSRS as we use reportbuilder instead of VS

Also not sure how SSRS passes the parameters as you have a custom datatype dbo.bData

Does it pass the parameters as text or date ?

Congratulations Jeff with the 1 million points

Depends on the configuration of the app.

In ssms you have options to not to encrypt or to trust the servers certificate (even if it is invalid)

Different connection settings? (ansi nulls, ...)

Have a look how's it done in dbatools https://dbatools.io/xevents/