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.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment