access to sql conversion problem

Converting access forum to sql server --

I have no problem with the basics but am getting stuck in one spot. When using DTS to import tblAuthor into the SQL database, I keep getting an unspecified error.

The table gets created, but no data gets populated. I've tried every way I can think of with no success.  All other tables and stored procedures import successfully.

I've done a search of forum topics but can't find a related solution post.

Thx,

Ben Peskoe

The biggest issue of using dts for this forum are the many relationships, You need to know what table to improt first. If you import the tblAuthor but do not yet have the tblGroups it will confilct. An order as follows that has always worked for me:
tblBanList, tblConfigurations,tblDateTimeFormat,tblSmut,tblPoll, tblPollChoice,tblGroup,tblAuthor, tblEmailNotify,tblPMMessage, tblBuddyList, tblCategory,tblForum, tblPermissions, tblTopic, tblThread and tblGuestname.

Now this list is sure not static but like I said it worked for me and you will not get any PK errors.

Open up enterprise manager, click + to open the tree structured extensions of your local server until you get to databases and click on the database you created or upsized for Web Wiz forums. If you click on that database you'll see all tables. Rest see image.