It looks like the kind of error you might get if you use DTSEXEC.exe to execute the package in a SQL Agent Job.   If that's the case, I'd guess that...

Take a look at the query.  Note that the joins do >= LOW and < HIGH.   There should not be any way for a value like 90 to appear in...

Without any details for the tables involved, it's hard to tell, but given that your views select from a Linked Server, that could well be the problem, as any table...

It looks like the data is in a format where each event is recorded, and not the duration, so before he can get an average, he first has to figure...

FYI, that link just goes back to this topic.  Your article link is here:  https://sqlrambling.net/2017/07/28/ssis-importing-csv-files-that-have-different-number-of-columns/

I went to your blog from your signature and the article had...

As always, it depends.   I have yet to work with FILESTREAM, but the important thing to know about that is that your access to the data via SQL Server will...