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...

Answer is "it depends"... on server spec, server load, usage of each functionality.

Only you can know what are the requirements for each individual item - based on that...

The answer to the question asked is NO - Sql Server Management Studio is just a tool - not a database and has no way to be connected to or...

In my company we use it extensively and it is the default when creating any new database.

2 Core databases
- CRM - 3TB in size -...

what version of

SSDT
Visual Studio
Excel

and bitness.
Not all combinations are allowed

script still on site - was just referenced as Featured Script on the daily email

its not being a sharepoint that matters - its is the fact it is a odata request and web request - it applies regardless of the site you are trying...

have a look at https://support.microsoft.com/en-au/help/4043104/operation-has-timed-out-connecting-to-odata-using-ssis-in-project-onli

Not native - but have a look at third party products - one of which is http://nitrosphere.com/nitroaccelerator/
Never used but have heard of it.
Other options are setting up VPN/Tunnels...