title: Import SQL to SQL DB: How can I populate columns that exist in destination, not source?
body: <p>I'm using SSIS to import data from one DB to another existing DB. Some columns in the destination tables do not exist in the source tables. Seems the Import &amp; Export Wizard only allows me to select unmapped columns from the source and match them with these new columns in the destination. I'd like to be able to just provide one piece of data to import into all rows of these new columns.
  Would like to use the GUI if possible because I'm not skilled at writing scripts. Thanks!</p>