Then your data is completely unordered. You can't guarantee it, and you don't have a way of replicating it. As I said, data in SQL tables is unordered, and the...

SQL Server 2016 requires SSDT 2016 to be able to deploy SSIS, SSRS, SSAS projects. Unless I'm mistaken, SSDT 2016 is only supported in VS 2015 onwards. I would imagine...

Tables are not ordered to start with. How are you defining your current "order". Alphabetically?

HappyGeek raises a good point here. If you want meaningful answers, you need to provide meaningful sample data. According to your data, 2649 visits all happened at exactly 21:35:37 on...

As a thought, probably a long shot, but I wonder if a column in your database has a different collation to the actual database. Does this yield any results?

What are you trying to use the variable to do exactly? In SSIS you reference a variable by using the following expression:
@[User::YourVariableName]

Just as a side note, you can't use SET to set the value of multiple variables. You either need to use SET, and do one at a time, or use...

Issuing a command of NOCHECK does change the is_not_trusted value for me, however, you could also make double sure my inserting an untrusted record:
USE DevTestDB;
GO

Just to chime in a little, is SSRS hosted on the same server as the SQL Server engine? If so, how much of the resources is SQL using? Is it...

Database's don't recognise languages; to them a "female" and "femelle" are just two strings (one 6 characters, one 7). If you need to change the language...

Those are your versions, I asked for Licence type. Do you have Express, Standard, or Enterprise?

If you have Enterprise, you should be able to achieve something with