This is a script component source, presumably? (Rather than a transformation.) Is the code part of the CreateNewOutputRows() sub?

Does the version of SSDT you are using allow you to debug...

If the code is not too lengthy, perhaps you could post it here? (Sanitised as necessary.)

You've given us lengthy pieces of code and a description of what you are trying to do, which is good.

But you have not described the problem in enough detail. What...

This is good advice, as far as it goes, but I suggest there's more that could have been covered here, including

a) Sample loop code, including a discussion about whether to...

However, the main reason I suggested DATETIME2(0) was that the milliseconds which are always stored with DATETIME (and shown when doing a select) could have been the reason for...

I cannot see the image which you have embedded, can you try again?

Regarding this

The SSRS subscription is disabling itself if the report/query runs during a school holiday period between the...

Or better yet, store them as datetime2(0),...

We need a bit more clarity on this, I think.

Why are you storing start and finish dates as varchar() rather than DATETIME?

What are the parameters, and why are they 'incorrect'?...

What sort of advice are you looking for? How to print on large pieces of paper? Where to buy a printer? How to create an ER diagram? Best paper to...

I assume you're using OUTER APPLY because the val.* results can sometimes be NULL. But if there is always a match in val, switching to CROSS APPLY is likely to...

The error message does not appear to be a complete sentence.

Was there some other text at the end after "or this asymmetric key"?

UPDATE t1
SET t1.col1 = ISNULL(t1.col1,UpdateValue)

I see no responses from Kevin.

Ken's query is a code fragment, as I assume is obvious...

Before I ask this question, I want to let you know that I followed the advice @Phil Parkins advice and first asked this question on an Oracle forum, however I...

There are some very clever people in this forum who will certainly come up with great ideas to help you. But here is my first attempt at speeding things up.

First,...