How to clear all contents in a table before exporting data to that table using SSIS package?
Asked by dafeizhu in MS SQL DTS, Microsoft Access Database, SQL Server 2005
Tags: clear, table, sql, data, contents
Hi all,
I want to export data from a SQL database table to a Access database table. However, I want the Destination table to be cleared everytime before the exporting takes place. Can anyone advise me on this? Thks alot.Start Free Trial
Keywords: How to clear all contents in a table bef…
View this solution now by starting your
7-day free trial.
Setting up your free trial is quick, easy, and secure. We will return you to this solution,
unlocked, when you're done.
About this solution
Zones: MS SQL DTS, Microsoft Access Database, SQL Server 2005