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. Thankskamesh
Kindly don’t duplicate post.
Luis Martin
Moderator
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
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
]]>