Also, if the cell is empty, the SSIS would import a NULL value. Why not also use the ISNULL operator to check if it's empty?
ISNULL(OnTime) : NULL(DT_DBTIMESTAMP) ? {False...

Will the spreadsheet(s) always be in the same format? Personally I would suggest that you upload the file(s) to a specific place, and store the name of the file in...

So, again, this is why 18/10/17 is failing, there...

What's your full SQL statement, with your CREATE statement? I imagine that your CREATE statement is wrong, not your CTE statement. It should look something like this:
CREATE...

Spam is bad for your health, 🙁

The problem with sending the value @exchangeRate = 0 is because you have the following equation in your SQL:
CAST((IDG.RELOCATION_EXP*@prev_exchangeRate)AS float)/ CAST(@exchangeRate AS float)
The part in bold...

http://www.bbc.co.uk/news/health-39899646

Although they say that no patient data appears to have been compromised, makes me even more glad I probably haven't had to use the NHS in almost...

Have you...

This converts fine on my machine:
SELECT TRY_CAST('18/10/2016 00:00' AS date)

Does that I can assume that you would see "18/10/2016" as the 10th day of the...

Firstly, let's find out what dates your SQL server doesn't like.

Could you give us some samples for the results that are returned for this query?
SELECT...

I was actually planning to use a Script Component and an ADO variable as the datasource, however, when I get to the second iteration I get no results from the...