how to run sql/stored proc before and after dts package 1

[Kingkumar]

Hi,
I have a dts pacakge to transfer data from excel file to sql server.
Now what i want to do is to truncate the table before the dts package is executed and then run a stored proc/ sqlstatements once the dts package has run successfully.
It might be simple but i dont know much about dts as new to it so any help would be highly appreciated.
Thanks.
--King

 

[Meleagant]

In your dts package, create an "Execute SQL Server Task". Put your truncate table statement in that then click OK. Back at your main design, click on the SQL Server Task you just created, hold <ctrl> and click on your Provider (the box looking thing). Go up to workflow and chose On Success or On Completion. That's it.

Gonna get a good running start and throw myself at the wall as hard as I can man --WZ--

 

[Kingkumar]

Thanks that was helpful
--king