I'm importing from Text (file) into a table that consists of 83 varchar
fields, then an Identity field. The source file has no ID field, just CSV
data ( max 83 fields ). In the Import Wizard as soon as I specify the field
delimiter ( comma ) the display shows that all unspecified ( in the input )
fields are filled with NULL. I believe the default NULL is biting me when it
gets to the Identity field which can't have a NULL.
Is there a way to prevent the NULL from being inserted -- at least in the ID
field?
I don't care about any of the actual data fields since I parse the data later.
Thanks -- jack

Have a look here and see if it helps.

I very very very (did I mention very) rarely use the wizard so am unsure
where and if these options (in the link) are available there. If not
then instead of executing the wizard package, save it edit it and look.

Problems With IDENTITY() and the DataPump task.
(http://www.sqldts.com/default.aspx?293)

Allan

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

Allan,
I used the DTS Designer and your Tutorial at www.spldts.com and it all came
clear. I now can import my CSV file into a table with an Identity field
perfectly.
I'd recommend the tutorials to everyone who is just getting started with
DTS. For
cases where its a straight 1:1 map with nothing special you could get by
with the DTS Wizard, but for everything else the DTS Designer is the way to
go.
Thanks for the great help -- jack

"Allan Mitchell" wrote: