I had to create a dts package which has to first delete data from a table in teradata server and then update that table with data in sql server. I am able to store the data from sql server to teradata. but I need to know is there a way to create a task like sql task where I can delete table data and then do on success to load teradata server. Any sample code or some good example link will be very helpfull. Thanks in advance.