November 10, 2009 at 7:19 am
I have been getting dogged out all week with 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).
http://go.microsoft.com/fwlink/?LinkId=81885
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
----------------- --------------------------------------------------------------------------------9.00.4035.00 SP3 Enterprise Edition (64-bit)
(1 row(s) affected)
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
November 10, 2009 at 8:51 pm
Is the "PreCompile" property of the script task set to TRUE in BIDS ? When running on a 64 bit installation, SSIS script tasks must be pre-compiled.
December 29, 2009 at 5:56 pm
The problem at least for me stemmed from Visual Studio.
I was also having an issue debugging a script task. when a break point was set I also recieved an error , but the script ran fine with no break points set. I was receiving the 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).
I am running with Visual Studio 64 bit and visual studio for applications wich ssis uses is not compatible with 64 bit.
the solution is simple either uninstall visual studio 64 bit and install the 32 bit version or better yet , stay with the 64 bit version and set the ssis project to run 32 bit : just go into properties -- debugging -- debug options -- and set Run64bitRuntime to false. This way your other projects can still run 64 bit
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply