July 7, 2003 at 2:02 pm
If a DTS pkg is build to copy data from one table of one database to another table in a 2nd database and when the data is replaced does the destination table gets truncated or deleted by the source data? any help will be appreciated
July 8, 2003 at 3:43 pm
It will give you the option to choose from 1) Delete rows from the Destination table or 2) Append rows to the Destination table. Click on the small button in the Transform section and you will see these options in the Column mappings. Btw I have seen so many of your basic question here, you seriously need to go through the BOL
Shas3
July 8, 2003 at 4:58 pm
If you use the wizard and choose the "Delete rows" option it'll use DELETE. To use TRUNCATE, you'd have to add an Execute SQL Task to the package in DTS Designer.
Greg
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply