Thanks, for some reason, it never occurred to me that window functions could be used for anything other than ranking, which is how I normally use it. Opens up a...

Hmm it's a shame it can't indefinitely run. I think in that case I will time out the package after a day. I'm also toying with the idea of whether...

Yeah, spent like 2.5 days, and was running out of options before today; was worried we'd purchased a SQL server enterprise license and would be crippled by being unable to...

I was using SSDT 2015 and building the solution, producing an ispac file, dropping it on the server, and running (double clicking) the ispac file, to deploy the project to...

Second breakthrough - I can deploy the package with no issues through the SSDT UI, it is only the ispac file that is not deploying properly! Very odd, I did...

I just deleted and recreated the SSISDB... no luck, the deployed package still has the same problem!

Thanks, there are still avenues to explore...

The reinstall of SSIS did not help.

I tried to make the script task in VB, no luck.

I tried the package deployment rather...

I got the server updated, but still no luck.

It is now: Microsoft SQL Server 2016 (RTM-CU2) (KB3182270) - 13.0.2164.0 (X64) Build 9600

Looking at the previous versioning, this was...

I am using SQL Server enterprise.

I am running the packages locally pointing to the production DB's, does patch levels still apply, as the instances are the same one? Not...

the first value is the rolled over from what the highest tick value is, as it is representing a week, and is rolling over. There is no set default value....

That does look like I could rewrite things better with that, I'll give that a try. is there any way I can wrap it around though, so that day 7...

I understand what you're saying, but I am not sure how to incoporate that, into finding in which interval that my data lies? The actual case is more to do...

Still need to do some more reading to fully understand the nuances of the code, but by looking at the numbers the indexes were producing, adding the following to the...

Yes, all of those would work.

Yep, that's correct.