RE: Newbie need help with DTS, null value error.

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Temjin (Temjin_at_discussions.microsoft.com)
Date: 09/26/04 

Date: Sun, 26 Sep 2004 02:05:03 -0700

Hello,

Doh, I never thought about backing up and restoring it. It works locally.
Now I just have to wait for my hosting provider to use my backup file and
restore my database.

I don't really like this method though as it requires intervention from the
hosting provider everytime I want to update anything to my remote database. I
wanted to use DTS as it is simpler, but it doesn't work (at least the
settings).

Is there any other way, like an easy web adminstration that can do this for
me?

Thanks

Regards,

Temjin

"Allan Mitchell" wrote:

> In your destination database the column CustomerID in dbo.Customers expects a
> value and you are not supplying one.
>
> In the DTS package/wizard instead of executing it there and then why not
> save it to sql server and open it up and have a look?
>
>
> Also why not use BACKUP and RESTORE?
>
>
>
>
> "Temjin" wrote:
>
> > Hey all,
> >
> > I'm currently using a shopping cart software called .netCart, which is in
> > ASP.NET and VB. I have been trying to import my local "fully working"
> > database to my remote server, but then the exported remote database is not
> > working with the software. Unfortunately, I have no prior experiences in MS
> > SQL database at all, nor do I know anything about the scripts they used with
> > the software I purchased.
> >
> > Error message when attempting to run part of the software (website) with the
> > exported database -
> >
> > "Cannot insert the value NULL into column 'CustomerID', table
> > 'tablename.dbo.Customers'; column does not allow nulls. INSERT fails. The
> > statement has been terminated. [Customer Table]"
> >
> > I simply used the DTS wizard to export the database. All settings are left
> > "default" because I don't know what I should do about them....
> >
> > 1) At Specify Table Copy or Quert, "Copy table(s) and view(s) from the
> > source database is selected.
> > 2) Selected all tables. At the "Column Mappings and Transformations" window
> > for all tables, "Create detination table" is SELECTED and "Enable identify
> > insert" is UNCHECKED.
> > 3) At one of the error table (i.e. Customers), the CustomerID int is NOT NULL.
> >
> > Sorry, I do not know what's wrong with it, and I don't know how to explain
> > it better technically. The software company do not support this as well.
> >
> > I believe the problem is with the settings in the DTS wizard when I try to
> > export the database. Something is not set right, but I don't know how to do
> > it.
> >
> > Can anyone please try to solve this problem for me? Thank you very much.
> >
> > Temjin

Relevant Pages

  • RE: How do I restore from mdf and ldf files?
    ... Tasks -> Backup Database ... Tasks -> Restore Database ... Windows 2003 Server with Latest Service Pack ... Pre-requisites for Sharepoint Backup and Restore: ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Restoring SQL Server Backups
    ... ORIGINAL BACKUP & RESTORE (MSDE Database) ... occurrenceof cachestore flush for the 'Object Plans' cachestore (part ...
    (microsoft.public.sqlserver.server)
  • Re: Restoring SQL Server Backups
    ... ORIGINAL BACKUP & RESTORE (MSDE Database) ... occurrenceof cachestore flush for the 'Object Plans' cachestore (part ...
    (microsoft.public.sqlserver.server)
  • Re: POINT IN TIME RESTORE
    ... This is what you should have done in order to do the restore as you wish: ... > 3- erase data ... > 5- restore database with norecovery ... The BACKUP DATABAE can of course be at an earlier point in time, ...
    (microsoft.public.sqlserver.server)
  • Re: Backend Exchange migrate to New Hardware (Server)
    ... Exchange mailbox stores and Exchange public folder stores. ... When you use Backup to restore Exchange databases, ... Storage Engine to restore Exchange database files and their ...
    (microsoft.public.exchange.setup)