I am just starting with DTS. I am trying to import a text file into a table.
In this text file the field that maps to the primary key in the SQL table has
non-unique data (every row has this value set to 0).

So far I have only been using the wizard to try to get this done, but I
can't see any means to have the tool just create unique values for me.

Any advice? Thanks.

You can use a Global Variable that gets incremented each time in the
pipeline for each row
You can, and this is the way I would go, load into a scratch table which
generated the unique values and then insert that into the real table

You will need to know the logic to create the key though. Is it an
incrementing integer?


Allan

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