I am going to import 2 columns (out of ten) from a CSV to
a database in SQL Server 2000.

I would like how can I choose these 2 columns ? In DTS
Import / Export Wizard, I click the Transform button.
Should I change the source columns to "Ignore" for those I
don't want to import OR change the destination ones ?

Besides, for the table I am importing data, there is a
column that is non-nullable that may cause problem when I
import the columns. Is there any suggestion how to fix
it ?

Thanks

"Peter" <anonymous (AT) discussions (DOT) microsoft.com> wrote

See the previous answer of Darren Green
"Only map transformations for the columns you are interested in, and ignore
the others, or if using auto-generated trasnforms, go back and delete the
additional ones."

You can define a Default value for the column, or add an ActiveX Script
Transformation in your DTS that sets a default value for the column

"Peter" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Read the previous Post of Darren Green
"Only map transformations for the columns you are interested in, and ignore
the others, or if using auto-generated trasnforms, go back and delete the
additional ones."

You can define a Default value for the column, or add an ActiveX Script
Transformation in your DTS that sets a default value for the column

Thank you for your advice.

Do you mean that I only have to select "Ignore" for those
columns in thte Source BUT not in the Destination ?

The table is full and I have to update 2 columns (1 is the
key to identify the column and another column). The non-
nullable column is not a column I have to import and it
contains production data.

Thanking you in anticipation

"Peter" <anonymous (AT) discussions (DOT) microsoft.com> wrote

I mean you have to delete the mapping between the two columns in the
"Transformation" tab of the Transform Data Task

See BOL About DTS Data Driven Query...you may define insert and update
query.
Or you may use a temporary table to retrieve your Excel data and then use an
"Execute SQL" task to do an update query.