incrementing pk dts problem

[michelleHEC]

I am creating a DTS that takes data from one table(tblA) and inserts it into another(tblB) but tblB has an incrementing PK and I am getting an error "cannot insert a null value" or something of that sort.
Any ideas? Thanks
Michelle

 

[SQLDenis]

Can you show the SQL statement

“I sense many useless updates in you... Useless updates lead to fragmentation... Fragmentation leads to downtime...Downtime leads to suffering..Fragmentation is the path to the darkside.. DBCC INDEXDEFRAG and DBCC DBREINDEX are the force...May the force be with you" --

http://sqlservercode.blogspot.com/

 

[jbenson001]

By incrementing PK, do you mean an Identity column?

 

[michelleHEC]

I am using the wizard to create the DTS. do I need to delete the row that is the identity column in column mappings and transformations?

 

[SQLDenis]

yes, you do

“I sense many useless updates in you... Useless updates lead to fragmentation... Fragmentation leads to downtime...Downtime leads to suffering..Fragmentation is the path to the darkside.. DBCC INDEXDEFRAG and DBCC DBREINDEX are the force...May the force be with you" --

http://sqlservercode.blogspot.com/

 

[michelleHEC]

wait, I am still not sure that makes sense. I may not be explaining myself correctly. I would want to append rows I just want to igore the identity column but that is not working.