Home Forums Data Warehousing Data Transformation Services (DTS) Compact an Access Database from DTS RE: Compact an Access Database from DTS

  • May 16, 2013 at 12:43 pm

    #1615963

    In Process Tab of Execute Process Task Editor:

    Executable:

    C:\Program Files\Microsoft Office\Office12\MSACCESS.EXE

    Arguments:

    /compact/repair "S:\Filename.mdb"