SQL import to tblAuthor issue

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   I seem to be having all kinds of issues using SQL 2000 DTS and
importing my current user table into the forum table.  I have had
to create many additional columns in my table to match the Author Table
in the forum.

I have answered all of it's issues so far and created columns with the
appropriate information and formatting, etc.  However, currently
it is telling me that "User_code" column must be unique identifiers.

When my users sign up for my online service we have a portal site that
has two levels, per company and per user in each company, so our tables
are several and all reference each other.

Each user is assigned an identifier randomly generated via
VBScript.  I tried to use these unique identifiers as the column
to import into the "User_code" column, but the SQL DTS still tells me
that the "User_code" column allows only unique identifiers.

 I
have tried everything I could, worn the search feature in these forums
out searching for information, and still I cannot figure out how to
import my current users into the forum.

I did find where I could disable the encryption which was nice if I was
manually entering these, but I do not have the time to enter each one
of my members now or in the future, so I have to figure out how to
import them from another various sets of SQL tables and set up a way
for the system to import each time I get new users.

I am by no means a SQL wiz, so please be easy.

Any ideas on how I can make this work? How do I bypass the need for a
unique "User_code" or auto-generate one so this will import?