Delete statement in DTS Package | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Delete statement in DTS Package

I have created a simple dts package which imports data from microsoft excel to sql server database. While copying the data from excel to table I need to delete the content in the table. I am not able to write delete statment in the transformation task. Can anyone help in this regard Vishwanath
When you import using DTS you will find one tab (Transformations) in this place you set delete all rows in destination table.
Luis Martin
Moderator
SQL-Server-Performance.com Although nature commences with reason and ends in experience it is necessary for us to do the opposite, that is to commence with experience and from this to proceed to investigate the reason.
Leonardo Da Vinci Nunca esperes el reconocimiento de tus hijos, eso ocurrirá luego de tu muerte
All postings are provided “AS IS” with no warranties for accuracy.
Refer to books online about what Luis is referring, KBAhttp://support.microsoft.com/default.aspx?scid=kb;en-us;Q319951 for your information. Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Luis, this is an option to delete transformations, not rows. Vishu, you can use executeSQL task to delete rows in destination table and make transformation task run on success of deletion.
quote:Originally posted by mmarovic Luis, this is an option to delete transformations, not rows. Vishu, you can use executeSQL task to delete rows in destination table and make transformation task run on success of deletion.

You are rigth. My misstake.
Luis Martin
Moderator
SQL-Server-Performance.com Although nature commences with reason and ends in experience it is necessary for us to do the opposite, that is to commence with experience and from this to proceed to investigate the reason.
Leonardo Da Vinci Nunca esperes el reconocimiento de tus hijos, eso ocurrirá luego de tu muerte
All postings are provided “AS IS” with no warranties for accuracy.
]]>