Its always hard to help with third party tools - the maker should be your first point of contact to see if performance can be improved with settings or workarounds...

If you run the package through a sql server agent job, within a step defined as Integration Services Package there is a tick box on the advanced properties to elect...

if  I understand correctly what you need I think the following covers it

select *
from items
where (len(@items) > 0
   and item_no IN (

declare @tbl table
  ( input varchar(20)
  )
insert into @tbl
select '1/0/1900' union all
select '1/1/1900' union all
select '1/2/1900' union all
select '1/7/1900' union...

RTFM is handy sometimes.
https://docs.microsoft.com/en-us/powershell/module/cimcmdlets/get-ciminstance?view=powershell-6

Get-CimInstance [-ComputerName <String[]>] ....

just build a string array with the names of the computers you need to query and pass it to...

Tabular and columnstore by default use compression - and you can't really change it the same way you do the normal data - columnstore you can define one of COLUMNSTORE or...

Because Microsoft so decided

Assuming that your excel source does not have as base date 1904 the following will be a good basis for what you need

including a bit of explanation https://stackoverflow.com/questions/19721416/formula-to-convert-date-to-number

are you sure that is the real bad one? this proc calls 2 others
  EXECUTE Getemailaddress @customerId, @toEmail output
and EXEC dbo.CreateDDForMissingCheckoutOrCheckin that the very end

As the first...

Although possible it is not what I would call dynamic in that everytime a new table is required or the table metadata changes you would need to regenerate the SSIS...

Hi,

Data Vault is as any other datawarehouse model - in fact quite similar to Kimball in that grossly speaking DV Hubs+Sat == Dimensions and Links+Sat == Facts.

If you setting up a DEVelopement server then no licensing is required - although to be on the safe side it may be advisable to have all the users register...

Are you doing Tabular or Dimensional processing? if tabular standard edition is limited to 16GB which may not be enough for your volumes. And assume 2-3 times the standard size...