Hello Group | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Hello Group

Iam 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.
Luis Martin
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.