You can create a "execute sql" item that has to happen before you upload. You typically do this by editing the "wokflow" of the DTS process. You just right click the transformation process, which is typically a solid gray line and then click "workflow properties" and then you add in order what actions you to happen prior to that data pump push.
I am a big fan of dropping and adding a table instead of truncate. Truncate keeps the data time of the table creation, whereas drop will always show when the last time your data was updated. This alleviates the need to have a data to track data updates and you can query the master table for the data table creation. Teddy On 3/9/07, Zimmerman, Debi <[EMAIL PROTECTED]> wrote: > > I need to override one of the defaults in the DTS Transformation > Package. I need to "delete all rows in the destination table before > copying the source data". I cannot figure how to change this default. > If anyone can help me with this I would appreciate it. > > Thank you in advance. > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2770 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
