SSIS 2005 Running in 64Bit of Window Server 2008

Got the following error:

Error: Script could not be recompiled or run: Retrieving the COM class factory for component with CLSID {A138CF39-2CAE-42C2-ADB3-022658D79F2F} failed due to the following error: 80040154.. For more information, see the Microsoft Knowledge Base article, KB931846 (http://go.microsoft.com/fwlink/?LinkId=81885).

Solution:

go into project properties -- debugging -- debug options -- and set Run64bitRuntime to false.