Data Trasformation Services

Hello All,

Can anyone tell me.. is that I can't create DTS if i'm using 4 field for Primary Key?

Can you explain a little more? Seems like you are using DTS to move data from one place to anotehr? You have a table with 4 columns in the primary key? what is that DTS is not letting you do?|||

Thanks Euan,

:D Sorry babe!!!

Yups.. I want to move data from tableA to tableB.. but in the same database.. I have a table with 4 columns primary keys.. I've got this :-

Violation of PRIMARY KEY constraint 'tableB'. Cannot insert duplicate key in object 'tableB'. The statement has been terminated.

|||You have invalid data in tablea, are you sure the keys are the same in the 2 tables? The error is basically saying that you have a row that violates the primary key constaint of table b.|||Yes, I'm sure the keys are the same in the 2 tables.. but if tableB doesn't have keys.. DTS running successfully.. but later my data will be duplicate..|||Are you running the load more than once, with the keys off perhaps? Can you count the rows in the 2 tables to make sure the counts are the same.