[dba-SQLServer] Data Transformation Question

Darryl,

Unless you want the deletions to take longer and be recorded in the log,
you would do a TRUNCATE TABLE MyTable in an Execute SQL task. Then, you
would link it to the other one with an On Success join line (the green one
changed to blue).

Robert

At 12:00 PM 7/4/2008, you wrote:
>Date: Fri, 4 Jul 2008 10:09:23 +1000
>From: Darryl Collins <Darryl.Collins at coles.com.au>
>Subject: [dba-SQLServer] Data Transformation Question.
>To: "'Discussion concerning MS SQL Server'"
>         <dba-sqlserver at databaseadvisors.com>
>Message-ID:
> 
><57E6E6CA42105A48B977303A2CDC2720076BF12CC1 at WPEXCH22.retail.ad.cmltd.net.au>
>
>Content-Type: text/plain; charset="us-ascii"
>
>
>Hi Guys and Gals,
>
>I have create some local packages using the Data Transformation 
>wizard so I can pull data in from an Access Database into SQL 
>Server.  This process works great and I have ask for it to be run 
>once a day ra ra ra.
>
>Problem is when it runs it just keeps appending data to the table, 
>rather than replacing the existing data.
>
>How can I get the package to remove all the existing data in the 
>table first, and then import the updated data from the external database.
>
>AirCodeish.
>
>DELETE * FROM tbl_MyTable
>Then Run the local package.
>
>This cannot be hard to do, but I just cannot see how it make it work.
>
>Regard
>Darryl