HomeForum
Welcome, Guest
ETL-Forum
Forum
Advanced ETL Processor

How to delete table content before loading data
(1 viewing) (1) Guest
Reply Topic
New Topic
  • Page:
  • 1

TOPIC: How to delete table content before loading data

How to delete table content before loading data 1 year, 2 months ago #1882

  • Fry
  • OFFLINE
  • Fresh Boarder
  • Posts: 4
  • Karma: 0
Hi All,

A have question - how can I delete the content from a table before executing Insert action? I need to generate new content all the time and cannot figure out the settings for this.

Please, advise.

Thanks,
Steven
Reply Quote

Re: How to delete table content before loading data 1 year, 2 months ago #1883

  • admin
  • OFFLINE
  • Moderator
  • Posts: 2181
  • Karma: 12
Hi,

There are no "separate settings" for this.

You will have to write your own SQL to do it

Peter
Reply Quote

Re: How to delete table content before loading data 1 year, 2 months ago #1884

  • Fry
  • OFFLINE
  • Fresh Boarder
  • Posts: 4
  • Karma: 0
Can you be more more specific please

Fry
Reply Quote

Re: How to delete table content before loading data 1 year, 2 months ago #1885

  • admin
  • OFFLINE
  • Moderator
  • Posts: 2181
  • Karma: 12
Sure

Right click on Data writer and select "SQL Editor"

Peter
Attachments:
Reply Quote
Reply Topic
New Topic
  • Page:
  • 1
ETL-Forum
Forum
Advanced ETL Processor
Powered by Kunena
Time to create page: 0.17 seconds

Testimonials

"DBSL software is important part of core business processes and has enabled us to scale up our capacity."

Tim Matter
CRM Team manager,

User Login

You only need to log in or register to use our support forum



Our customers

BP

BBC

HSBC

Databases we work with

Submit to Delicious Submit to Digg Submit to Facebook Submit to Google Bookmarks Submit to Stumbleupon Submit to Technorati Submit to Twitter Submit to LinkedIn
Go to top