SQL Server Performance Forum – Threads Archive

Using DTS for restoring deleted data

I am a newbie to DTS and working on cleaning up several tables in a database. I am looking at a process where I can use delete rows from each table, store them as text files, and then, if necessary, reinsert the data if errors in the program occur as a result of the deletion. It appears to me that DTS would be a good tool to use for this procedure. Does this sound like a feasable concept?

---

Yes you can use DTS or OSQL to export the data out to text/csv files. But I suggest rather than exporting to a text file externally, it is better to transfer the data between 2 databases where one can used as source and another as contingency. This way you can easily rely on SQL internal process. 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.

---

I’ll go with satya.
I feel creating another DB in SQL would be more adaptable.
It will be faster and more safer.
But Why do u need this kind of deletion and again restoring.

---

Hi i think can’t you do this work by bcp which will much faster and you can call its command from the front end also. Silicon Master

---

]]>