Home Forums Data Warehousing Data Transformation Services (DTS) Compact an Access Database from DTS RE: Compact an Access Database from DTS
Habib Zmerli
Mr or Mrs. 500
Points: 559
More actions
July 21, 2005 at 7:41 am
#576070
Use the "Execute Process Task" with the following command :
"c:\Program Files\Microsoft Office\Office11\msaccess.exe /compact /repair"
PS. Parameters can be localted in the parameters field.
HABIB.
Habib Zmerli (MVP)