DTS ActiveX transfer error

[NewDBAGuy]

I was wondering if anyone knew how to resolve a certain problem I have. When
I set up a DTS package, and do straight column-copy transformations, I have
no problem doing so. However, when I need to do an ActiveX script
transformation, I keep getting an error afterwards. When I look at the error
log file, I see:
Error at Destination for Row number 1. Errors encountered so far in this
task: 1.

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

The table I am importing into has an identity column as the primary key,
which does not allow Nulls. All other fields allow Null values. I have
unchecked in the tranformation Options section where it says 'enable identity
insert.' Even if I comment out every line of the ActiveX script
transformation, I get the same error. If I delete this transformation and
just leave the copy column type in, it works fine. Sometimes I have to create
entirely separate transformations for each column being copied just to get
past this annoyance.

Any help is appreciated. It seems every time I modify a perfectly-good DTS
package I am back in the same spot.

System specs:
Win2k3
Sql 2000 Std Sp3a with MS0-031 and kb826161 patches installed.

[Bob Feldsien]

Yes, this is a real pain!
Here's what seems to work for me.
1) In the transform designer, just do direct copy on any columns that will
transfer directly. If the identity insert is unchecked, that should generate
your primary key.
2) Then click the New button and do whatever you need to do as an ActiveX
script.

I just found this out a few minutes ago, so if other issues pop up, I hope
this is at least a good starting point.

Bob

Post by NewDBAGuy
I was wondering if anyone knew how to resolve a certain problem I have. When
I set up a DTS package, and do straight column-copy transformations, I have
no problem doing so. However, when I need to do an ActiveX script
transformation, I keep getting an error afterwards. When I look at the error
Error at Destination for Row number 1. Errors encountered so far in this
task: 1.
Error Source: Microsoft Data Transformation Services (DTS) Data Pump
Error Description:Insert error, column 1 ('DDAFeedID', DBTYPE_I4), status
10: Integrity violation; attempt to insert NULL data or data which violates
constraints.
Error Help File:sqldts80.hlp
Error Help Context ID:30702
The table I am importing into has an identity column as the primary key,
which does not allow Nulls. All other fields allow Null values. I have
unchecked in the tranformation Options section where it says 'enable identity
insert.' Even if I comment out every line of the ActiveX script
transformation, I get the same error. If I delete this transformation and
just leave the copy column type in, it works fine. Sometimes I have to create
entirely separate transformations for each column being copied just to get
past this annoyance.
Any help is appreciated. It seems every time I modify a perfectly-good DTS
package I am back in the same spot.
Win2k3
Sql 2000 Std Sp3a with MS0-031 and kb826161 patches installed.

[NewDBAGuy]

I'll keep that in mind. Later I saw what was causing my problem. When I
created the ActiveX transformation, I thought I had to unselect the source
and destination columns before I went into the transformation's Properties
button. That was a mistake. If I selected the appropriate source/destination
columns, the script worked fine. (The problem was between the keyboard and
the chair:-)

Since that time I've been much more successful with DTS packages. Especially
since they are so literal: if there are source files, or if the SQL
connection connects to <local>, then when you run the package via Ent Mgr, it
assumes your PC is the server, or has the source file locally, etc.

Post by NewDBAGuy
I was wondering if anyone knew how to resolve a certain problem I have. When
I set up a DTS package, and do straight column-copy transformations, I have
no problem doing so. However, when I need to do an ActiveX script
transformation, I keep getting an error afterwards. When I look at the error
Error at Destination for Row number 1. Errors encountered so far in this
task: 1.
Error Source: Microsoft Data Transformation Services (DTS) Data Pump
Error Description:Insert error, column 1 ('DDAFeedID', DBTYPE_I4), status
10: Integrity violation; attempt to insert NULL data or data which violates
constraints.
Error Help File:sqldts80.hlp
Error Help Context ID:30702
The table I am importing into has an identity column as the primary key,
which does not allow Nulls. All other fields allow Null values. I have
unchecked in the tranformation Options section where it says 'enable identity
insert.' Even if I comment out every line of the ActiveX script
transformation, I get the same error. If I delete this transformation and
just leave the copy column type in, it works fine. Sometimes I have to create
entirely separate transformations for each column being copied just to get
past this annoyance.
Any help is appreciated. It seems every time I modify a perfectly-good DTS
package I am back in the same spot.
Win2k3
Sql 2000 Std Sp3a with MS0-031 and kb826161 patches installed.

[palemraju]

Any One help for this... I am also getting the same problem.I am not
understanding this.If i insert record making the ID column as allownulls(not
primary key,Identity) its doing without any errors.If I make it as Primary
key,then it is printing same error.Why???? Any One help Plzzz.... urgent..

url:http://www.ureader.com/msg/1146110.aspx

[amy]

hi, don't know if it's too late. I was having the same problem and came
across your post.
what I did is in transformations ->edit->destination column, unselect the
identity column, then in "options" tab, unselect "enable identity insertion",
that worked

url:http://www.ureader.com/msg/1146110.aspx