SQL Server Performance Forum – Threads Archive
Hello GroupIam a new member to this group. I need some clarifications about SQL Server DTS. Iam pretty new to DTS. All I have to do is to load data from a flat file to a databse. My question is when I import data from a flat file to particular table in a database, will the wizard do a insert or update . Because I got an error that says there is a violation of primarykey constraint…cannot insert duplicate key in to object. when this error occurs..is there any data being imported or the whole thing just roll backs..? would be great help if some one responds. Thanks
Kindly don’t duplicate post.
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.
Hey sry .
Follow as advised and this thread is locked. Satya SKJ
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.