Advertisement

11.15.2007 at 11:36PM PST, ID: 22965015
[x]
Attachment Details

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
[+][-]11.15.2007 at 11:50PM PST, ID: 20296734

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
Tags: clear, table, sql, data, contents
Sign Up Now!
Solution Provided By: cezarF
Participating Experts: 1
Solution Grade: A
 
 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628