Using the DelimitedSplit8K function:
WITH Paths AS (
  SELECT *
  FROM (VALUES
        ('\ENQ123\Testing Data\Testing More Data\Test'),
        ('\ENQ345\Testing...

WITH Times AS (
  SELECT *
  FROM (VALUES
        ('2017-03-27 09:24:00.000'),
        ('2017-03-27 09:48:00.000'),
        ('2017-03-27 09:49:00.000'),
        ('2017-03-27...

Got to be honest, totally (logically) guessed this one, but wasn't surprised it was the right answer.

Possibly depends on what your end game plan is. I assume that the external clients will need to authenticate. How are you planning for them to authenticate (Windows Credentials, Username...

Stop the PC going into power saving mode. This'll be in Control Panel->Hardware & Sound->Power Options and select High performance.

On a related note, is this someone's normal desktop...

What is your question exactly?

t they were a coupl e

Although not T-SQL have a look Brandie's Detective Stories - Tracking Down the Database's Dependents Part 2, which has a section on SSIS.

Always ensure you test your code before posting it. For your dates, you are inserting the expression [day] / [month] / [year] (where / means divide). As you're dividing all...

Ok, firstly, I'm going to admit, I've done this more for other readers feedback rather than the OP's (sorry). Table design isn't something I really get to do at work,...