DTS Error: "Run-time error '1004', xla not found

Error 1004 means an Excel12 Palisade add-in is loaded. Remove it from Excel Add-ins or delete the toolbar, then launch Palisade from Start menu.