[dba-SQLServer] Data Transformation Question.

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

This email and any attachments may contain privileged and confidential information and are intended for the named addressee only. If you have received this e-mail in error, please notify the sender and delete this e-mail immediately. Any confidentiality, privilege or copyright is not waived or lost because this e-mail has been sent to you in error. It is your responsibility to check this e-mail and any attachments for viruses.  No warranty is made that this material is free from computer virus or any other defect or error.  Any loss/damage incurred by using this material is not the sender's responsibility.  The sender's entire liability will be limited to resupplying the material.