Post reply

[DTS] How to delete all rows in destination before import into ms-access

  • June 24, 2010 at 2:38 am

    #224231

    Hi everyone,

    Hi gurus i have one question to asking all of you

    I try to export data from sql server to ms-access by DTS package but the problem is i want to clear all row in destination first before re-export then now i can set normal transformation but i must to execute some task first before run transform tasks so how to set it automatically

    thanks

  • June 30, 2010 at 8:10 am

    #1187092

    On DTS Export wizard, once you have selected the source SQL Server tables click on "Transform" then select "Delete rows on destination". This has to be done for each table.

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply