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.
| Author |
Topic |
|
Angela
Starting Member
11 Posts |
 Posted - 2006-01-05 : 07:53:19
|
| I have a dts package where i am trying to import a text file into a table..the table has an identity so the package is failing because it is trying to insert a null value in the identity column..i want it to auto increment ..how do i get around this? |
|
|
Vivaldi
Constraint Violating Yak Guru
298 Posts |
Posted - 2006-01-05 : 08:04:50
|
| I believe that you make sure no record from the text file is getting mapped to the table. That should fix it.________________________________________________The only cure for thinking is picking rocks, or drinking beer. |
 |
|
|
Angela
Starting Member
11 Posts |
Posted - 2006-01-05 : 08:08:19
|
| there isn't ..that is what i don't understand..nothing is mapped to the identity column but i still get the error message |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-01-05 : 08:10:15
|
| edit the package tranformation and don't mapped to that identity column-----------------[KH]2006 a new beginning |
|
|
|
Angela
Starting Member
11 Posts |
Posted - 2006-01-05 : 08:20:43
|
| nothing is mapped to it |
|
|
|
Vivaldi
Constraint Violating Yak Guru
298 Posts |
Posted - 2006-01-05 : 08:34:04
|
quote:
Originally posted by Angela
nothing is mapped to it
Is the Identity_Insert flag on?________________________________________________The only cure for thinking is picking rocks, or drinking beer. |
|
|
|
Angela
Starting Member
11 Posts |
Posted - 2006-01-05 : 08:39:47
|
| on the column? yes |
|
|
|
shallu1_gupta
Constraint Violating Yak Guru
394 Posts |
Posted - 2006-01-06 : 00:18:00
|
| Hi Angela,1 In Mapping and transformation set source as <ignore>2 uncheck enable Identity Insert check box. |
|
|
|
|
|
|
DTS package HELP