is it possible that DTS skipped Indentity attribut

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

is it possible that DTS skipped Indentity attribut

Author

Topic

rtutus
Aged Yak Warrior

522 Posts

Posted - 2006-09-11 : 15:07:01

I imported a table using DTS.
I run SQL statements in my original server database. It works well.
But when I run the same instructions within a stored procedure in my new workstation where I improrted the table I get this error:
Server: Msg 515, Level 16, State 2, Procedure InsertFichierPrix, Line 11
Cannot insert the value NULL into column 'Id', table 'myDBLive.dbo.FichierPrix'; column does not allow nulls. INSERT fails.
The statement has been terminated.

Here is the SQL statements that I run on the original Database:

insert into fichierprix(nomfichier, version, descriptionfr, typeclient,....) values(@NomFichier,'Actuelle', @NomFourFr, 'MembreAcheteur', ....)

And here is my SP that I run on the new imported database:

CREATE PROCEDURE InsertFichierPrix @NomFichier varchar(50), @NomFr varchar(50),@NomAn varchar(50)
AS

declare @NomFourFr varchar(50)
declare @NomFourAn varchar(50)

SET @NomFourFr='liste fournisseur ' + @NomFr
set @NomFourAn='liste fournisseur ' + @NomAn

insert into fichierprix(nomfichier, version, descriptionfr, typeclient,...) values(@NomFichier,'Actuelle', @NomFourFr, 'MembreAcheteur'...)

GO

And here is the execution of my Stored proc on the destination database:

execute insertfichierprix @NomFichier='myfilename2', @NomFr='fournifr1',@NomAn='Fourniang1'

Thank you for helping me.

snSQL
Master Smack Fu Yak Hacker

1837 Posts

Posted - 2006-09-11 : 15:33:27

If you used the Export Data option to create the DTS package then you need to make sure you select to copy objects and then select the table you want to copy. If you select to copy tables and views, it just copies the basic table structure (without indexes and keys and identity column definitions and so on).

rtutus
Aged Yak Warrior

522 Posts

Posted - 2006-09-13 : 06:35:52

Thank you

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources