Well, I can get you part of the way, I think.

1. Create a new user variable in the package to hold your Commutations dataset. This variable should have a data...

You can do this with older versions of SQL Server too ( I have to use SQL Server 2008, doesn't support WITH RESULT SETS), but you have to do a...

Is your new server clustered or part of an "availability group"? I think those are the right terms, I'm not an expert on that.

If this is the case, and assuming...

How is that different than not using an ORM?...

By "EF" do you mean "Entity Framework" as in Microsoft? You do...

(sorry, supposed to be a quote/reply)

• This reply was modified 6 years, 5 months ago by dmbaker.

By "EF" do you mean "Entity Framework" as in Microsoft? You do realize that...

Is your project in Visual Studio targeting the expected version of SQL Server? Right-click the project, choose "Properties" and check the "Target Platform". If it's not right then change it...

I think you're being unnecessarily...

ZZartin -

Getting a second page of data is not rerunning a query.  It's getting more data from a single query.  That is what is under discussion in this...

Jeff -

There are other options out there.  Databases that use multi-version read consistency do exactly what you are asking - present an accurate picture of the state of...

It's all a matter of how likely a possibility.

Recipe for disaster? A better recipe would be trying to retrieve all 10 million records to your client in a "static"...

Oh, what a recipe for disaster!  Since you are requerying the data every time, you have NO WAY to know if the offset is still valid.  You are going...

I use SSIS quite a bit where I work and in general it's a pretty useful tool. What I've found though, is that it tends to work best when you...

Yeah, duh? I...