DTS to add a field on imported data

I am in the process of importing data that is in a text format to the
sql server, I want to add couple of fields and insert general data in
the fields added, this data is going to be similar to all the records
imported. Your help in this regard will be greatly appreciated.Hi

If you have created a DTS package to do this import you could add and
Execute SQL step to do an update statement. Alternatively, if the value is
to be the same for each record, then a default constraint on the column will
populate the initial values.

John

"John R" <admin@.wirelesscybercafe.com> wrote in message
news:a486f7fa.0409170810.3bdc4def@.posting.google.c om...
> I am in the process of importing data that is in a text format to the
> sql server, I want to add couple of fields and insert general data in
> the fields added, this data is going to be similar to all the records
> imported. Your help in this regard will be greatly appreciated.