Grant, thanks for your advice. I will take some time to rewrite this one (I've been putting it off for long enough).

Thanks to everyone who took time to...

Anonymized query plan attached.

sgmunson (1/3/2017)

---

Jim-S (1/3/2017)

---

Phil Parkin (12/22/2016)

---

Jim-S (12/22/2016)

---

Unfortunately it is causing us some issues, we are using Microsofts ALM (kanban model) to deploy our stuff to test and live servers. We attach...

Phil Parkin (12/22/2016)

---

Jim-S (12/22/2016)

---

Unfortunately it is causing us some issues, we are using Microsofts ALM (kanban model) to deploy our stuff to test and live servers. We attach our dtsx...

Hi sgmunson

I should probably have mentioned this before, but I don't have a local instance installed on my laptop, I always connect to the server.

I'm guessing we can rule out...

Unfortunately it is causing us some issues, we are using Microsofts ALM (kanban model) to deploy our stuff to test and live servers. We attach our dtsx files/ code to...

Thom A (12/22/2016)

---

I'm a little confused about your statement of adding/removing a column on your laptop/server. How are you removing a column on the package on the server if it's...

It was a permissions issue with the service account that was being used to run the SQL Job. Because Salesforce is web based, the service account needed more permissions to...

I am back with another question relating to this server side trace and more unwanted rows that I am struggling to filter.

Let me give you an example of my problem......

Sue_H (8/25/2016)

---

I think you want to look at the application name column that executes those, not just the text data. Filtering out based on what you see in the entire...