If I understand you correctly, you have one version of an 18GB table, but in some fashion need 36 versions of it?   As that's a pretty sizable increase in disk...

Just an FYI, but that code introduces an unnecessary implicit conversion by using a string to represent negative 1.   Here's the code fully indented and just removing the single quotes...

Have you considered making use of DATEDIFF(day, DUE, CONVERT(date, GETDATE())) ?

Okay, I'm totally confused.   Since when has the term "variance" come to mean something other than the difference for a set of exactly two values?   If we were talking about...

Here's the FieldActivations table create so that folks can more easily create something testable....
CREATE TABLE #FIELD_ACTIVATIONS (
    FieldName tinyint NOT NULL,
    CategoryID tinyint NOT NULL,
    IsActive bit NOT NULL,

And how, exactly, was your package configured for the File connection manager?   Also, does your data perhaps contain CR/LF in the middle of that blob data ?

EDIT:  Or...