Friday, February 24, 2012

How to delete all rows/truncate the target table

How to delete all rows from target table or truncate the target, before loading the fresh data into it?Use an Execute SQL Task before the data flow task and truncate the table using Truncate statement. There is no option in OLE DB or Sql Server Destination to truncate the table before loading new rows.

No comments:

Post a Comment