What do you mean "the field"? Do you mean [HEDGE CLASS CODE]? That column will remain a dt_wstr, as you can't "change" the data type of a column...

Welcome to SSC.

When posting, you should provide data in a consumable format, rather that screenshots, which are more than often not useful for other users. I've done this...

This appears to be a duplicate of https://www.sqlservercentral.com/Forums/FindPost1898512.aspx

I'm assuming that this related to GDPR; which is coming into effect in 2018.

In all honesty, I don't really know at this time. We have a Data Protection...

Have a look at Gail's article here, specifically looking at the part about "The Catch-all Query": https://www.red-gate.com/simple-talk/sql/t-sql-programming/how-to-confuse-the-sql-server-query-optimizer/

She gives a few solutions there.

I got this exact same...

From the OP's post, Jasona, I'm actually not so sure that they have indeed deployed, my understanding is that they are actually running the package within VS; I could be...

Looks like a Groups and Islands problem.

Using an Example the "lovely" Luis (I think it was Luis, if not, I apologise!) gave me awhile ago, this...