SSIS Debug Error for Script tasks on x64 Server 2008 Workstation VS 2005
I am so tired of this problem for Script tasks. I can't find any answers to get me past this. The only thing I can do is to find a 32 bit machine to work on, which I prefer to work on my normal development workstation. Using VS 2005.
The error I get is:
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://code.msdn.microsoft.com/KB928208/Release/ProjectReleases.aspx?ReleaseId=768 - the fix found at this link does not apply for Server 2008. I should have all patches up to date and would presume I don't need this special hotfix, but perhaps it is broken again.
Any help is appreciated.
All Replies
- Are you running service pack 2 or later for SQL Server 2005 on your development machine?
John Welch | www.mariner-usa.com | www.agilebi.com | ssisUnit.codeplex.com I am running SP3.
What versions of the .NET framework are installed on you machine?
I've used x64 Server 2008 with SQL Server 2005 without any issues, so I'm suspecting that either a patch is missing or was applied out of order.
John Welch | www.mariner-usa.com | www.agilebi.com | ssisUnit.codeplex.com- There is a part of that KB article applies to VSA scripting which is what SSIS 2005 is using. It is not related to SQL Server 2008 but if you are using SSIS 2005 then you do need it.
Looks like VSA is not properly installed on that machine after installing SP3. You can try to install http://code.msdn.microsoft.com/KB928208/Release/ProjectReleases.aspx?ReleaseId=768.
If that does not work try and find Microsoft_VsaVb.dll dll and run "regasm.exe Microsoft_VsaVb.dll" to hopefully register that interop DLL to be used in .net code but I'm not sure that's the only thing that is missing on that machine.
Hope it helps.
This posting is provided "AS IS" with no warranties, and confers no rights- Unmarked As Answer byAndy Wilbourn Friday, September 25, 2009 7:03 PM
- Marked As Answer bySilviu GueaMSFT, ModeratorFriday, September 25, 2009 5:11 PM
- The link to the fix you put is the same one I mentioned will NOT install on Server 2008 Operating system.
I did try to regasm, but does not seem to have helped. I presume I only see the 2.0 framework one? On Server 2008 the NDP part of this fix is not needed because it is already there, you are right. The other part of the fix is in the VSA runtime used by SQL Server Integration Services 2005 which should be included with the SP3. My only guess is that somehow that part was not properly installed.
Can you try to install the x86/amd64 patches found at this location?
http://www.microsoft.com/downloads/details.aspx?familyid=2BA43893-EF6B-4019-9E7D-D8CC6C7B905D&displaylang=en
Hope it helps.
This posting is provided "AS IS" with no warranties, and confers no rights
