I am testing loading users from a salesforce.com Report Export, and keep gettin the following error:

Error: USER_NAME. Cannot insert the value NULL into column 'PORTAL_ONLY', table 'SplendidCRM.dbo.USERS'; column does not allow nulls. INSERT fails. The statement has been terminated.

I thought that it might have been an address field that contained an invalid (new line) character, so I removed that from the export.  Then I was concernted that the format of the old user names (the same as the e-mail address) could have been a problem, so I modified that.  As far as I can tell from the export, the USER_NAME is not Null. 

Any suggestions?

Thank you,

Brian