Thanks Steve, here's the post

https://www.sqlservercentral.com/forums/topic/is-there-a-way-to-do-a-mass-update-in-ssis/page/2/#post-3120855

have a great day.

Please don't use SSC as a way to promote your products.

This is a 10 year old thread, nobody appreciates stuff like this. Go somewhere else and do this, but not...

Based on “dbcreator: Members of the dbcreator fixed server role can create, alter, drop, and restore any database.” does that make the proxy account the owner of the database then?...

Yes it is.

Just found the problem

I disabled the Telemetry(CEIP) service for the default instance and its been 15 minutes with no login failure.

Now the question is do i change the...

I'm not sure what you're asking but the login error is happening only on the default instance. The server has 2 additional instances and i'm not seeing this error on...

and another with line breaks:

So what exactly was fixed?...

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

If you have memory capped at about 3/4 of the total available and PLE is ok (over 300) then i say the issue is some other process outside of SQL.

Thanks i just wanted to verify it wasn't just me scratching my head. 
And yeah i know what Brent would say, i didn't even need to open that link, but...

I guess going back to your original question of how to get the related W recs with this setup i would set a variable in the E recs data flow...

OK, yeah i need to read things more closely. So you are already concatenating the columns then writing output to the SAME flat file using different flat file destinations. 
So...

Another way in the send mail task property "force execution result" = Failure.
But what you have will work too.

So what i'm understanding is that you need to output different rec formats within the same flat file. 
Anytime i need to output fixed width i usually stage the data in...

What about just running these in series or separate into separate Data flow tasks or even separate packages and launch them using Exec Package tasks. 
I know at some point...