I am pretty sure that if the SSIS service is not running, you can't do most SSIS related tasks such as deploying to an SSIS catalog.

I am a little...

I don't know EF well enough to comment on that, unfortunately.

Using more appropriate data types:

DECLARE @hFrom TINYINT = 9
,       @mFrom TINYINT = 0
,       @hTo ...

Don't let your use of EF force you never to use temp tables, because sometimes temp tables are the best tool for the job!

For these procs, is there a final...

Rather than assuming what the optimiser is doing, please check the execution plans to be sure.

What indexes and keys do you have on HubHistoryData?

Locking?

You might find performance improvements if you use this method instead.

I have not tried this before, but have you experimented with Shared Datasets?

If you were to create one which included the calculated 'time difference' column, you could then create another...

OK. The Previous() function should get you the value of a data item from the previous row, which you can then use to calculate the time difference. I'm not...

Unless you are going to justify this...

Do you have to do this in SSRS, or can you do it within the source query?

Put *.* in the filespec of the Foreach loop and it will pick up whatever file is in the folder, regardless of name.

Thanks Phil. As suggested by you i could see buffer setting has already changed 50% more from default, fast load option is already enabled, table lock to destination table...

I can't see how data in the Subaccounts table is linked to AccountCategories.

How us SUB1 linked to Description1, SUB2 to Description2, etc?

Database security is one of those things which in my experience is difficult to handle within SSDT.

It can be handled in environment-aware post-deployment scripts, or completely outside SSDT. Outside SSDT...