Just to clarify...
You're updating 500 gigs of data and wondering why you have growth of 400 gigs, or did I misunderstand that part?
In SSIS, on your destination, what's your commit size/Rows per Batch? If it's blank/2147483647, then your entire load is going in as a single transaction. Cut that up a bit. 🙂
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA