Thanks for responding Hussain27syed.

Here's my situation:

I have an EXCEL spreadsheet with many columns. I am IMPORTing just a few of them into a Database Table. I have ONE remaining COLUMN in the Database TABLE that I must also update with a Constant (hard-coded) value of "X".

Again, that ONE addition Database Table Column that will NOT be populated with data from the EXCEL spreadsheet. That ONE Column in the Database Table will be populated with a hard-coded (constant) value of "X" or "Y" based on the EXCEL spreadsheet being imported. For this particular job I know the value of the Database Table Column will be updated with the value of "X" every time.

Can I create a SSIS package that has a Variable with a value of "X" and when I do my MAPPINGs from EXCEL to the Database Table, also map" that Global VARIABLE to that ONE remaining Column?

I hope that's clear?