The reason you have an issue is because you are grouping on x.Plans - and not the result of the case expression.  Change it to:

SELECT
case
when x.Plans =...

One more thing - there are a few things that can be done much more easily/better using a script task than the execute process task or file system task or...

If you have to do it in SSIS, you need (and forgive me if butcher the name because I avoid SSIS) a cmd exec task.  The problem is that...

Have you tried the ideas outlined here: https://www.brentozar.com/archive/2015/06/careful-testing-the-2014-cardinality-estimator-with-trace-flags/

@ScottPletcher & @JeffModen:

You both are assuming an environment where there is a dev/test/uat/prod set up.  Not saying the OP doesn't have that - but there are environments where that isn't...

I would also change the process from .Move to a .Copy and a separate delete operation.  The reason for that is simple - in Windows, when moving files the file...

You cannot change the compatibility level of a database on the secondary only - it must be changed on the primary.  I am assuming the reason for changing the compatibility...

Not per application, but per SQL Database Engine Instance - unless you are using these terms interchangeably. We have 4 SQL Instances. Each Instance is 'shared' so running multiple...

The only reason to connect SSRS to a specific database engine is if you are hosting the reportserver databases on that instance.  The 'usually' better option is to install a...

Jeffrey: Thanks for clarifying the process you are thinking of. There's some kind of disconnect here as I'm still not fully following you. That's OK though. We can...

Yes, you are missing something.

1. User places file in folder to be processed
2. Package processes file and then moves the file to an archive folder

You could process once a day...

Do you mean the following? : Copy the .csv files to the local...

With random data being inserted into an nchar(50) column - there isn't going to be anything you can do to prevent fragmentation.  Your best option is to reduce the number...

That's the term that I've used for this before.  I don't know how it works because it's out of my wheelhouse at work but it works.

The good part...

I know what you are saying about creating a proxy.  I know how to do that and how to assign the proxy in Agent.  The problem is that...