what sort of status information is it returning? if you don't mind my asking what is the dts package doing?
if you want to continue with your current solution you can replace the temp table with table variables then you don't have to worry about dropping them.