"I wonder how other companies handle this situation..."
in our company, we have typically three environments: dev, staging and production. The staging and production are identical except maybe the amount of data.
my workaround is converting the source data to varchar(4000) or even varchar(8000) in a temp/intermediate table and use this as the source in your DTS.