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.

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

"NewDBAGuy" wrote:

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.

"NewDBAGuy" wrote:

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

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

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

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

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

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

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