Re: Newbie need help with DTS, null value error.
From: Allan Mitchell (allan_at_no-spam.sqldts.com)
Date: 09/26/04
- Next message: Ajay Garg: "How can I change the connection information of a large number of DTS packages?"
- Previous message: Temjin: "RE: Newbie need help with DTS, null value error."
- In reply to: Temjin: "RE: Newbie need help with DTS, null value error."
- Messages sorted by: [ date ] [ thread ]
Date: Sun, 26 Sep 2004 10:19:21 +0100
Have you tried enabling IDENTITY INSERT?
-- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. www.Konesans.com "Temjin" <Temjin@discussions.microsoft.com> wrote in message news:E75001B5-7ADC-4D05-8716-3158BD29633D@microsoft.com... > 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
- Next message: Ajay Garg: "How can I change the connection information of a large number of DTS packages?"
- Previous message: Temjin: "RE: Newbie need help with DTS, null value error."
- In reply to: Temjin: "RE: Newbie need help with DTS, null value error."
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
