Error Source: Microsoft Data Transformation Services (DTS) Data Pump
Error Description:Insert error, column 1 ('ID', DBTYPE_NUMERIC), status 10:
Integrity violation; attempt to insert NULL data or data which violates
constraints.
Error Help File:sqldts80.hlp
Error Help Context ID:30702


Error Source: Microsoft OLE DB Provider for ODBC Drivers
Error Description:Multiple-step OLE DB operation generated errors. Check
each OLE DB status value, if available. No work was done.
Error Help File:
Error Help Context ID:0


I am getting this error if i insert data through dts.In my Destination table
ID column is primary key and identity.i had tyied every solution eventhough
it is giving that error.If i changed it as allow nulls(remove primary key on
yhis column)it is inserting successfully without showing any error..What is
the problem???any one help me plzzz....how to solve this...???

url:http://www.ureader.com/gp/1146-1.aspx

Are you trying to insert a value for the ID column? If so, you will need to
set identity insert to true... Otherwise - try doing the insert without the
ID column as the server will auto-generate the numbers for you.
--
~lb


"palemraju" wrote:

Are you trying to insert a value for the ID column? If so, you will need to
set identity insert to true... Otherwise - try doing the insert without the
ID column as the server will auto-generate the numbers for you.
--
~lb


"palemraju" wrote:

Are you trying to insert a value for the ID column? If so, you will need to
set identity insert to true... Otherwise - try doing the insert without the
ID column as the server will auto-generate the numbers for you.
--
~lb


"palemraju" wrote:

Are you trying to insert a value for the ID column? If so, you will need to
set identity insert to true... Otherwise - try doing the insert without the
ID column as the server will auto-generate the numbers for you.
--
~lb


"palemraju" wrote:

Are you trying to insert a value for the ID column? If so, you will need to
set identity insert to true... Otherwise - try doing the insert without the
ID column as the server will auto-generate the numbers for you.
--
~lb


"palemraju" wrote:

Are you trying to insert a value for the ID column? If so, you will need to
set identity insert to true... Otherwise - try doing the insert without the
ID column as the server will auto-generate the numbers for you.
--
~lb


"palemraju" wrote:

Are you trying to insert a value for the ID column? If so, you will need to
set identity insert to true... Otherwise - try doing the insert without the
ID column as the server will auto-generate the numbers for you.
--
~lb


"palemraju" wrote:

Are you trying to insert a value for the ID column? If so, you will need to
set identity insert to true... Otherwise - try doing the insert without the
ID column as the server will auto-generate the numbers for you.
--
~lb


"palemraju" wrote: