????????? ????? ?? ????????? ????? ??? SQL Server 2005 ??????? ???? ????? ????????? ???? ??? ?????? ?? ???? ??

???? ?????? ???? ??????
???? ID: 931846 - ?? ???????? ?? ?????? ??? ?? ?? ???? ???? ???? ??.
??? ?? ??????? ???? | ??? ?? ??????? ????

?? ????? ??

?????

??? Microsoft SQL Server 2005, ???? ?? ????????? ????? ?? ????????? ????? ??? SQL Server 2005 ??????? ?????? (SSIS) ?????? ?? ????????? ???? ??? ??????? ???? ??? ??, ????????? ???? ??? ? ??? ??? ?? ?? ?? ????????? ?? ??????? ???? ?? ?????? ????? ?? ?????? ????? ???????? ???????? ??? ?? ??? ?? ??? ??? ???????? ?? ?? ???? ??:
  • Windows Vista
  • ???? Windows ???????? ?????? ?? Microsoft .NET Framework 2.0 ?? ?? ???????? ??????? 2.0.50727.832 ????? ?? ??? ??? ??? ??
???? interoperate ?? ????? ?? ???????, ?? ??? "???? ???????" ??? ??????

?????? ?? ???, ?? ?????? ?? ???? ?? ??? ????? ????????? ???? ???:
  • ?? Windows Vista-?????? ???????? ?? SSIS ?????????? ????? ??????? ????? ???????? ??? ??, ?? ?? .NET Framework ???????? ??????? 2.0.50727.832 ????? ?? ??? ??? ??? ?? ?? Windows ???????? ?????? ??? ??? ???????? ?? SSIS ?????????? ????? ??????? ????
  • ?? SQL Server ??????? ?????????? ????????? Studio ????? ?? ???? SSIS ????? ?? ??????? ???? ?? ??? ?? ????? ?????
  • SSIS ????? ??? ?? ????? ?? ???? ????????? ????? ?? ??? ????????? ??? ?? ??????? ???? ?? ?????? ???
  • ?? ???????? ?? ???? ???? ???????? ?? ?? ?? ???? ??????????? ?? ?????? ?? ????? ???? ?? ?????? ?????
?? ?????? ??? ????????? ???????? ?????? ?? ?????? ???? ??? ????????? ?????? ???? ??? ?? ??????? ?? ???? ?? ?? ?????? ????? ????? ?? ???? ??? ??? ??, SSIS ???? ????????? ??? ????? ????????? ???? ??? ?????? ?? ???? ???? ???????, ???? ?? ??????????? ?? Windows Vista ??? ???? ?? ?? ?? ??? ???? ??? .NET Framework 2.0 ?? ?? ???????? ??????? 2.0.50727.832 ????? ?? ??? ??? ???? ???????? ?? ?? ?? ????? ?? ??????? ???? ?? ????? ?? ??? ?? ?????

?? ?? ?????? ?? ???? ??, ?? ????? ??????? ?? ????? ?? ???? ??:
  • ??? ?????? SSIS ????? ????????? ???? ?? ?????? ???? ??? ?????? ??? ????????? ?????, ???????? ???? ?? ???? ??, ?? ???? ????? ?????? ????? ??????? ???? ??:
    ????????? ????? ?? ??? ???? ??? ????
  • ?? ?? ???? ?????? SSIS ????? ?? ?????? ??? ????????? ??? ?? ????????? ???? ?? ?????? ????, ???????? "NullReferenceException" ?????? ????? ?? ??? ???? ?? ???? ???
  • ?? ?? ?? ?? ????????? ????? ?? ???? ?????? ????????? ??????????? (VSA) ???????????? ?????? ?? ??? Microsoft Visual Studio ??? ???? ?? ??? ??????? ????, ?? ???? ????? ?????? ????? ??????? ?? ???? ??:
    ?????/??? ????????? precompile ???? ?? ??? ???????? ???? ??? ??, ????? ??????? ??? ???? ????
  • ??? ????????? ????? ??? ?? ???? ????????? ??? ???, ?? ???? breakpoint ??? ??? ???? ?? ?? ????????? ????? ?? ??? ????????? ????, ???? ????? ?????? ????? ??????? ?? ???? ??:
    ????????? ????? ?? ??? ???? ??? ????
    ???????: 0x8001902
    'System.Runtime.InteropServices.COMException' ?????? ?? ??? ????? Microsoft.VisualBasic.Vsa.dll ??? ? ?? ??, ????? ?????????? ??? ??? ????? ???? ???? ??? ??
    ???????? ???????: CLSID {A138CF39-2CAE-42 C 2-ADB3-022658D79F2F} ?? ??? ??? ?? ??? COM ???? factory ??????? ?? ??? ?? ????? ?????? ?? ???? ???? ???: 80040154?
    ???:?? ?????? ?? ?? ???? ?? ??? ????? Microsoft ???????? ???? ??? ???? ?? .NET Framework 2.0 ?? ??? ??????? ?? 2.0.50727.832 ????? ?? ???? ?? ??? ???????? ??????? ?????
    928208FIX: ????? ????????? ?? ?????? Visual Basic ??? ????????? ?????? ?? ????? ?? ??? ?? ?????? ?? ?????? ???? ??? ?????? ?? ???? ??? ?? ??? Visual Studio ?? ????? ????
???:?? ???? SQL Server 2005 ?????? ??? 1 (SP1) ??????? ?? ?? ???? ?? ????? ????? ???? ????

????

Microsoft .NET Framework 2.0 2.0.50727.832 ?? ??? ?? builds ?? ??? ??????? ???? ?????? (CLR) ?????????? ?????? (Mscorwks.dll) ??? ???? ???????? ?? ???? ?? ?????? ???? ??? ???????? introduces Microsoft Visual Basic ?????? ???? (Vsavb7rt.dll) ?? VSA ?? SSIS ?? ????? ???? ?? ??? ??????-?????? ?????? ??? ?????? ?????? compilation ???????? ?? ????? ??? ?? ????? ?? ??? ?? assemblies ?? ????? ??? ?? ?????? ?? ???? ?????? ????? ?? ??? ?????? ??????????? ?? ????????? ???? ?? ??? ???? ???

VSA ?? ???????-???? ???????? ??? ?? ???????? ?? ??? ???? ?????? ?? ???, ??????? VSA ??????-??? ?? ????? ???? ??? ??????? ??????? ???? (CIL) ????? ???? ??? ?????? ?? ???? ????

????????

To resolve this problem, use one of the following methods based on your need.

???:The following methods describe hotfixes that you can apply on the computer that is running SSIS. Notice that each of these hotfixes provides the same functionality. The only difference is that each hotfix is packaged according a particular version of SQL Server 2005.

?????? 1:

???:We recommend that you use this method to resolve this problem.

Install SQL Server 2005 Service Pack 2 (SP2).SQL Server 2005 ?????? ??? 2 ?? ??????? ???? ?? ??? ???? ???? ?? ???? ??? ???? ??????? ?? ??? Microsoft ???????? ??? ???? ????? ?? ??? ????? ???? ?????? ?? ????? ????:
913089SQL ????? 2005 ?? ??? ?????? ?????? ??? ?? ??????? ???? ?? ??? ???? ????

???? 2

???:Use this method if the following conditions are true:
  • You do not want to install SQL Server 2005 SP2.
  • You installed SQL Server 2005 SP1.
  • You have not applied any hotfix that is based on SQL Server 2005 SP1.
  • The current build of SQL Server 2005 is 2047.
Apply the hotfix that is described in the following Microsoft Knowledge Base article:
932555FIX: A script task or a script component may not run correctly when you run an SSIS package in SQL Server 2005 build 2047

???? 3

???:Use this method if the following conditions are true:
  • You do not want to install SQL Server 2005 SP2.
  • You installed SQL Server 2005 SP1.
  • You applied a hotfix that is based on SQL Server 2005 SP1.
  • The current build of SQL Server 2005 is later than 2047.
Apply the hotfix that is described in the following Microsoft Knowledge Base article:
931593FIX: A script task or a script component may not run correctly when you run an SSIS package in SQL Server 2005 build 2153 and later builds

???? 4

???:Use this method if the following conditions are true:
  • You do not want to install SQL Server 2005 SP2.
  • You are running the release version of SQL Server 2005.
  • You have not applied a hotfix that is based on the release version of SQL Server 2005.
  • The current build of SQL Server 2005 is 1399.
Apply the hotfix that is described in the following Microsoft Knowledge Base article:
932556FIX: A script task or a script component may not run correctly when you run an SSIS package in SQL Server 2005 build 1500 and later builds

Method 5

???:Use this method if the following conditions are true:
  • You do not want to install SQL Server 2005 SP2.
  • You are running the release version of SQL Server 2005.
  • You have applied a hotfix that is based on SQL Server 2005.
  • The current build of SQL Server 2005 is later than 1399.
Apply the hotfix that is described in the following Microsoft Knowledge Base article:
932557FIX: A script task or a script component may not run correctly when you run an SSIS package in SQL Server 2005 build 1399
After you use any of these methods, you may continue to experience any of the problems that are described in the following Microsoft Knowledge Base article:
928208FIX: ????? ????????? ?? ?????? Visual Basic ??? ????????? ?????? ?? ????? ?? ??? ?? ?????? ?? ?????? ???? ??? ?????? ?? ???? ??? ?? ??? Visual Studio ?? ????? ????
?? ?????? ???, ?? 928208 Microsoft ???????? ???? ??? ???? ?? .NET Framework 2.0 ?? ??? ??????? ?? 2.0.50727.832 ????? ?? ???? ?? ??? ???????? ?? ???? ?????

??????

Microsoft ?? ?????? ?? ?? ?? ?? ?? Microsoft ???????? ??? ?? ?????? ?? ?? "???? ???? ???? ???" ?????? ???????? ???..

???? ???????

.NET Framework 2.0 ?????????? ?? ??????? ???? ?? ??? ??? ?????? ?? ??????? ???????? ?????? ?? ????????? ???????????? ?? ???? ??? ?? ???? ?????? ???????? ?? ???? ??????? ?????? ???? ??????? ????? ?? ???? ??? ??????? ?? ??? ?? ?????? ?? ????? ????? ???

1 ?? ?????

????? ??????????? ???? ???? ???? ??? ?????????? ?? ???????? ??? ???? ????? ?? ??? ???? ????:
  • ???????? ?? Windows Vista ?? ????? ???? ???? Windows ???????? ?????? ??? ??? ???
  • ???????? ?? ?? .NET Framework 2.0 ?????????? 2.0.50727.832 ????? ?? ??? ??? ??????? ???? ??? ??
??? ??, SSIS ????? ??? ????????? ??? ???

????? 2

???? ?? SSIS ????? ??? ??? ????????? ????? ?? ??? ????????? ??? ???? ?? ?? ??? ?? ????????? ???

????? 3

??? ????????? ????? ?? ??? ????????? ??? ??? ??? ?? SSIS ????? ????????? ???? ?? ??? ??? ??? ?? ??? ???? ?????? ???? ?? ??? precompile ???? ?? ??? ???? ??? ???? ???

???:?? ???????? ?? 64-??? ???????????? ????? ??? 64-??? ????????????, ?? ??? JIT ???? ?? ??? ?? ?????? ???? ?? ??? ??? ??????? ????? ???

????? 4

???????? ??? ??, .NET Framework 2.0 ?????????? ?? ??? Windows Vista ??? ??? ???????? ?? ???????? ?????? ??????? ???? ?? ?? ???? ??? ????? ??? ?? ?? ?? ???????? ?? ??????? ?? ?? ?????? ?? ?? ?? ???? ????

????? 5

64-??? ????????????, ?? ???? ????????? ????? ?? ??? ????????? ??? ??? ??? ?? SSIS ????? ????????? ?? ???? ?? ????? ?? ?? ???? ??? ????? ??? ?? ?? ?? ???????? ?? ??????? ?? ?? ?????? ?? ?? ?? ???? ???? .NET Framework 2.0 ?????????? ?? ??????? ?? ?? ???? ???????? ?? ??? ??????????? ?? ???????? ??? ?? recompile ???? ?? ??? ??????? ?????? ??? ?? ????????? ??? ?? CIL ??? ?? ?? ????? ???? ??? ?? ????? VSA ?? ?? ?? ??????? ?????? consumed guarantees ??? ?????, ?? ??????? ?????? ?????

????? 6

??? ?????????? ?? ?? Windows Vista ?? ????? ???? ???? Windows ???????? ?????? ??? ??? ???, SSIS ?????? ???? ?? ?????? ???? ????????? ???? ?? ?? ???? ????????? recompile. ?? ???? ?? ??? ?? .NET Framework 2.0 ?????????? ?? ??????? ???? ???? ??????? ?????? ??? SSIS ????? ?????? ???????? ????????? ?? ???? ????? ?? ???? ?? ???? ???? ??????????? ??? ??? recompilation ?? overhead ?? ????? ?? ???? ??? ?? ??? ?? 1 ??????? ?? ?? ??? SSIS ???????? ?? SQL Server 2005 SP2 ??????? ??, ?? ????? ???????? CIL ??? ?? ????????? ???? ?? ??? ?????? ?????? ?? ??? ??????? ?????? ?? ??? ???? ??? ??? ???????? ???? ???????, ????? ??? ????? ?? ????? ?? ??? ?? ?? ??????? ????? ?? ?????? ?? ???? ??? ????? ?????? ??????? ??? ?? ??? ???

??????? ????? 1

Precompiled ????????? ??? ???? ??? ????? ????????? ?? ?????? ??? ?? ???? ?? ??? ?? ??? ???? ?? ?????? ?? ??? ??? ???? ??????? ?? ???, Microsoft ???????? ????, KB931846 ????? (http://go.microsoft.com/fwlink/?LinkId=81885)

??????? ????? 2

Precompiled ????????? ??? ???? ??? ????? Recompile ???? ?? ?????? ?? ??? ??? ???? ??????? ?? ???, Microsoft ???????? ????, KB931846 ????? (http://go.microsoft.com/fwlink/?LinkId=81885)

??????? ????? 3

Precompiled ????????? ??? ???? ??? ????? ????????? ?? ?????? ??? ?? ???? ?? ??? ?? ??? ???? ?? ?????? ?? ??? ??? ???? ??????? ?? ???, Microsoft ???????? ????, KB931846 ????? (http://go.microsoft.com/fwlink/?LinkId=81885)

?????? ????? 1

????????? ??? ???? ???? ?? ???? recompiled ?? ?????: {0}., ???? ??????? ?? ??? Microsoft ???????? ????, KB931846 ????? (http://go.microsoft.com/fwlink/?LinkId=81885)

?????? ????? 2

Precompiled ????????? ??? ???? ??? ????? ????????? ??? ??? ??? ???????? ?? ??? ??? ??????? ????????? recompiling ???? ??? ????? ???? ??? ????????? recompile, ?? ??? Microsoft ???????? ????, KB931846 ????? (http://go.microsoft.com/fwlink/?LinkId=81885)

?????? ????? 3

Precompiled ????????? ??? ???? ??? ????? ????????? ????? ??? ??? ???????? ?? ??? ?? ??????? ????????? recompiling ???? ??? ????? ???? ??? ????????? recompile, ?? ??? Microsoft ???????? ????, KB931846 ????? (http://go.microsoft.com/fwlink/?LinkId=81885)

???????? SSIS ?? VSA ?? ??? ?? ????????? ??????

SSIS ???????? ????????? ?? ???? ????? ?? ????? ???? ???? ?? ?? ????? ???????? ?? ???????? ????? ?? ????? ???? ?? ??? SSIS ????? ??? ???????????? ????????? ??? ?????????? ????? ?? ?? ?? ????? ??? ????? ???? ???? ??, VSA ??? ??????-??? ?? ?? ?????? ??? ????????? ?? ????? ???? ??, ?? VSA IDE ??????? ?? ???? ??, ?? ?????? ????? 2005 ?? Visual Basic ??? ????????? ?? ???? ??? ?? IDE ??? ??, ?? Visual Basic ??? CIL ??? ???????? ???? ?? ??? ???????? ??? ?? precompiled ???

???:CIL ???? Microsoft ??????? ???? (MSIL) ?? ??? ??? ???? ???? ???

Visual Basic ????? ??? ?? CIL ??? ?? ??? ???? ????? ????? ????? ?????? ??? ????? ???? ???? ????? ?? ?????????, ??????? ?? ????? ?? deployed ???????? ???, ?? ?????? ??? ?? ?? ???? ?? CIL ??? ?? VSA ???? ?? ???? ?? ?? ????????? ?????

???:?? ???????? ???????? ??? ??????????, ???? ???? ???? ???? ?? ????????? ?? ??????? ???

?? ??-????????? ?? ???? ?? CIL ??? precompile ???? ?? ??? ???? ?? ?? ???? ???? ?? ?????? ???, Visual Basic ????? ??? ???? ????? ??? ????? ??? ?? ?? CIL ??? ??? ????? ???? ??? ??? ????? ??? ?? VSA ?????? ??? ?? compiles CIL ??? ??? ????? ???? ??? ?? ?? ??? ?? ????? ???? ????????? ????, ?? VSA ?? ensuing CIL ??? ???? ???? ?? ???? ?? ????? ????? ???????, VSA ?? ??? compilation ????? ?? ??? ??? ???? ???? ??? ??????? 64-??? ???????? ??? ?????, ???????? compilation ??? ?? 64-??? ???? ??? ???? ???? ????????? ???? ?? ?? ????? precompile 64-??? ???? ?? ??? ?????? ????????? ?? ??? ?? ?????? ?? ?? ???? ?? ??? ??????? ????? ???

Microsoft SQL Server ???????? ?? ??? ?????? ?????? ?? ???? ??? ???? ??????? ?? ??? Microsoft ???????? ??? ???? ????? ?? ??? ????? ???? ?????? ?? ????? ????:
822499Microsoft SQL Server ?????????? ?????? ???????? ?? ??? ??? ?????? ??????
?? ??? corrects ?????????? ???? ?? ??? ?????????? ?? ???? ???? ??? ??, ?? Microsoft ?? ????? ???? ???? ?????? ?? ???? ??? ???? ??????? ?? ??? Microsoft ???????? ??? ???? ????? ?? ??? ????? ???? ?????? ?? ????? ????:
824684Microsoft ?????????? ???????? ?? ????? ???? ?? ??? ????? ?? ???? ???? ???? ???????? ?? ?????

???

???? ID: 931846 - ????? ???????: 06 ?????? 2010 - ??????: 2.0
???? ???? ???? ??:
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Enterprise X64 Edition
  • Microsoft SQL Server 2005 Enterprise Edition for Itanium-based Systems
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Standard X64 Edition
  • Microsoft SQL Server 2005 Standard Edition for Itanium-based Systems
??????: 
kbprb kbtshoot kberrmsg kbbug kbmt KB931846 KbMthi
???? ?????? ????????
??????????: ?? ???? ?? ???? ??????? ?? ????? ?? Microsoft ????-?????? ?????????? ?????? ?????? ???? ??? ??. Microsoft ???? ??? ????-???????? ?? ????-???????? ????? ?????? ?? ???? ???????? ???? ?? ???? ????? ????? ??? ?? ??? ?????? ?? ???? ???? ???? ??? ????? ??. ???????, ????-???????? ???? ????? ???? ???? ???? ???. ?????, ????????, ?????-???? ?? ??????? ?? ???????? ?? ???? ???, ???? ?? ??? ?????? ???? ???? ??? ????? ??? ?? ???? ??. Microsoft ??????? ??? ???? ?? ?????? ?? ??????????, ????????? ?? ??? ?????? ?? ???? ????? ?? ???? ???????? ?? ??? ???? ????? ?? ??? ????????? ???? ??. Microsoft ????-?????? ?????????? ?? ????? ?????? ?? ?? ??? ??.
?????????? ?? ??????? ????????? ??????? ??:931846

??????????? ???

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com