Wednesday, March 7, 2012

Script Component Error in BI Development Studio on Vista Install

I'm having an issue with a development machine that has the RTM version of Vista installed on it. I get the same issue with every script component, regardless of what package it resides in.

The red "X" error that I get in the BI dev studio is:

Error 1 Validation error. My Data Flow Task: My Script Component [6313]: System.BadImageFormatException: An attempt was made to load a program with an incorrect format. (Exception from HRESULT: 0x8007000B) at Microsoft.VisualBasic.Vsa.VsaEngine.Compile() at Microsoft.SqlServer.VSAHosting.Runtime.LoadSource(String project) at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.CreateUserComponent() MY SSIS Package.dtsx 0 0

When I try to execute the package, I get the following error:

TITLE: Package Validation Error

Package Validation Error


ADDITIONAL INFORMATION:

Error at "All" Data Flow Task [YearMonth Math for Prior Year [3149]]: System.BadImageFormatException: An attempt was made to load a program with an incorrect format. (Exception from HRESULT: 0x8007000B)
at Microsoft.VisualBasic.Vsa.VsaEngine.Compile()
at Microsoft.SqlServer.VSAHosting.Runtime.LoadSource(String project)
at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.CreateUserComponent()
Error at "All" Data Flow Task [YearMonth Math for Prior Year [3149]]: System.BadImageFormatException: An attempt was made to load a program with an incorrect format. (Exception from HRESULT: 0x8007000B)
at Microsoft.VisualBasic.Vsa.VsaEngine.Compile()
at Microsoft.SqlServer.VSAHosting.Runtime.LoadSource(String project)
at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.CreateUserComponent()
Error at "All" Data Flow Task [DTS.Pipeline]: "component "YearMonth Math for Prior Year" (3149)" failed validation and returned validation status "VS_ISBROKEN".

Error at "All" Data Flow Task [DTS.Pipeline]: One or more component failed validation.

Error at "All" Data Flow Task: There were errors during task validation.

(Microsoft.DataTransformationServices.VsIntegration)


BUTTONS:

OK

Other developers can open and execute this package fine. The only machine that can't is the Vista machine. Has anyone else had this issue with running BIDS on Vista?

This is a known issue, which (together with other Vista compatibility issues) will be fixed by SQL 2005 SP2 early next year. For now, please don't use Vista machines for SSIS development.
P.S. There is a preview (November CTP) release of SP2, it fixes many Vista compatibility problems, but it does not fix this issue yet.|||Thanks for the response!|||

I have the same problem except that I am not using Vista. I have Microsoft Professional on the box.

I did not have this problem last week.

When I tried to register Microsoft.SqlServer.TxScript.dll I am getting an error saying

"DLLRegistry Server Entry point could not be found". Any ideas?|||

Please see this KB:

http://support.microsoft.com/kb/931846

As for registering TxScript - my best advice is to avoid trying to register random DLLs (unless instructed by Microsoft KB article) - this often does more harm than good.

No comments:

Post a Comment