Hi,
you can simply add the new column manually in the connection manager (in the "advanced" section right below "columns") and define its data type and size.
You can then place the newly added column at the right position if necessary. This will preserve your changes.
Regards,
Michael