?? ??? ????? ???? SSIS ??? ??????? ?? ???? ???? ???? ???? SQL

?????? ????????? ?????? ?????????
???? ???????: 918760 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

???????

??? ??????? ???? Microsoft SQL Server 2005 ????? ????? (SSIS) ?? ???? ???? ???? ???? SQL? ?? ??? ????? ???? SSIS. ??? ???? ??? ?? ??? ?????? ???? SSIS? ?????? ????? ???? ???? ???? SQL.

????

??? ??? ???????? ?????? ???? ????? ???????. ????? ??????? ?????? ?????? ??? ?????? ???? ??? ??????. ??????? ???? ?? ???? ?????? ??? ???:
  • ???? ???????? ???? ?????? ?????? ?????? ??? SQL Server ???? ????? ?????? ?????? ???????.
  • ???? ???????? ??? ???? ???????? ???????? ?????? ??????? ?? ?????? ??? ????? ???? ???? SSIS.
?? ?? ???? ?????? ?? ???????????? ???????:
  • ????? ??? ???????? ?????? ?? ????? ???????? ?????? ?? ??????. ???? ?? ???? ??? ????????? ??? ?????? ?????? ?? ???? ????? ????? ?????? ?????? ??????? ?? ????? ??????? ProtectionLevel ?????? ?? ???? ???????? ?????? ?? ????? ??????? ?? ??????.
  • ??? ????? SQL Server ?????? ?????? ???????? ???? ??? ??? ???????? ?????? ???????? ????????.
  • ??? ?????? ??? ????? ??? ???????? ?????? ??? ???? ???????? ???????? ??????? ??? ????? ??????? ???? ??? ??? ????? ???????. ??? ???? ??????? ???? ?? ???? ??? ????????? ?? ????? ????? ???? ???? ?? ?????? ????? ???? ????? ????. ???? ?? ???? ??? ????????? ???? ?? ?? ???? ????? ??? ????? ??????? ?????? ??? ???? ???? ??? SSIS.
  • ?????? ????? ???? SSIS ???????? ??? ??????? ?????? ??????? HKEY_CURRENT_USER. ?????? ??????? HKEY_CURRENT_USER ???? ?????????.
  • ????? ????? ?? ???? ????? ?? ???? ???????? ?????? ???????? ???????.
??????? 1: ??????? ???? ???? ???? SQL Server

??????? 2: ????? ??????? ProtectionLevel ?????? SSIS ??? ?????????????

??????? ???????: ????? ??????? ProtectionLevel ?????? SSIS ??? ??????????????????????????

??????? 4: ????? ????? ???? SSIS ???????

??????? ???????: ????? ???? ??????

?????

??? ?????? ??? ???????.

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

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

  1. ????? ?????? ??????? ??? ???? ?? ?????? SQLServer2005SQLAgentUser. ??? ???? ??????? ????? ????? ?????? ????.
  2. ????? ???? SSIS ?? ?? ?????? ???? ExecuteSQL. ?????? ???? ????? ????? OLE DB ???? msdb ?????? ???????? ??????? ???????: '?????? Windows' -????????????: "???????" ???????? " -SQLStatement: "sp_who"
  3. ?? ?????? ?????? ?????? ?? ??? ???? ?????.
  4. ???? ?? ??? ????? ??????? ProtectionLevel ??? ??????????????????????????.
  5. ????? ???? ???? ???? SQL ????? ????. ?? ????? ? ? ???? ??? ???? ???? ???? SQL ?????? ???? ????.
???? ???? ?? ??????? ?????? ???? ???? SQL ??????? ?????? ??? ???:

??????? ???????: ?????? \ ??? ????????. ??? ????? ??????. ??? ??????.

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

?? ??????? ????????? ?????? SSIS ??????? ProtectionLevel ??????????????????????????. ????? ??? ??? ??????? ???? SSIS ??? ????? ?????? ???? ????? ??? ??????? ???? ?? ??? ????? "???????," ??? ????? ?????? ?????? ?????????? ?????? ???????. ????? ??? ????? ????? ??????? ??? ?? ???????? ?????? ????? ??????? ????? ??????? ?????? ???? ?? ?????. ??? ???? ??? ??? ???????? ?????? ?????? ??????? ????? ?????? ??????. ??? ????? ?????? ???? ???? ???? ???? ???? SQL? ?????? ????????? ?? ???? ???? ???? ???? SQL. ??? ?????? ????????? ??? ?????? ?????? ??? ?? ?????? ??????. ????? ???? ????? ???? ???? ???? ???? SQL ?????? ?? ????? ???? ????? ???? ??? ?????? ???? ??? ?? ???? ????? ?????. ??? ???? ??????? ?? ???? ????? ?????? ????? OLE DB ?? ????? FTP. ??? ?????? ???? ??? ?? ???? ?? ????? ?????? ???????? ???? ??? ?? ???? ???? ???????.

??? ?? ???? ???????? ????? ????? ????? ?????? ???????? ???? ??? ?????????? ??? ?? ???????. ????? ????? ??????? ProtectionLevel ?????????????????????????? ?????? ????. ?? ???? ??????? ??? ??????? ???? ???? ??????? ????? ?? ???????. ????? ????? ????? ????? ???? ?????? ?????? ??? ??????. ????? ???? ??????? ?????? ???????? ???? ??????? Dtutil.exe SSIS ?????? ??????? ????? ???????? ???.cmd ??????? ?????? ????? ???? ???? SQL. ??? ???? ??????? ???? ??????? ???????. ??? ????? ??????? ?????? ???????? Dtutil.exe ?? ??????? ??????? ??????? ????? ????? ??? ??????? ???? ??? ?? ??? ?????.
  1. ????? ?????? ???? ???? ????? ???????? ???? ????.
  2. ??????? ?????? ???????? Dtutil.exe ?? ???? ???? ??????? (cmd Exec) ???? ???? ???? ???? SQL ?????? ??????? ProtectionLevel ??? ??????????????????????????. ????? ??? ??????? ????? ?????? ???????? ???? ??????? ??? ?? ????? ????? ??????. ??????? ???????? ???? ??? ???????? ?????? ?????? ?? ?????? ???? SQL Server ???? ????? ??????? ? ?????.

    ?????? ??? ??????? ????? ??? ???????? ???? ?????????, ?? ???? ?????? ????? ??? ????? ??? ??????? ???.

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

????? ?? ???????? ??? ?????? ????? ?? ??????? ?????? ???? ???? SQL? ????? ??????? SSIS ????? ?????? ?? ?? ???? ??????? ????? ??? ??? ???? SSIS. ????? ???? ????? ?????? ???????? ????? ?????? exec ????? ?? ????? ?????? SSIS.

??? ????? SSIS

????? SSIS ????? ?????? ?????? ????? ??? ?????? ???????? ??? ????? ?????? ????. ???? ???????? ?????? ??? ????? ?????????. ??? ????? ?????? ?????? ?????????. ??? ????? ?????? ?????? ?????????? ??? ??? ??????? ????? ?????? ??? ???. ?? ??? ??????? ??? ???? ???? ????? ??????:

OnError? ??? ??????? DOMAINNAME\USERNAME? FTP Task,{C73DE41C-D0A6-450A-BB94-DF6D913797A1},{2F0AF5AF-2FFD-4928-88EE-1B58EB431D74},4/28/2006 1:51:59 PM? 4/28/2006 1:51:59 ??-1073573489? 0 x? ???? ??????? ????? FTP ???????? "????? ????? ???????? ??? ???????".

OnError? ??? ??????? DOMAINNAME\USERNAME? Task,{C6C7286D-57D4-4490-B12D-AC9867AE5762},{F5761A49-F2F9-4575-9E2B-B3D381D6E1F3},4/28/2006 SQL ????? 4:07:00 ?, 4/28/2006 4:07:00 ??-1073573396? 0 x? ??? ?? ?????? ??? ????? "user01.msdb". ???? ?? ??? ????? ??????? ???? ???? ?? ?? ?? ???? ???? ???????? ??????? ??? ??? ???????.

??? ????? ?????? exec ?????? ?????????

???????? ????? ????? exec ?????? ??????? ????? ????? ???? ???? ????? ???? ??????? ???? ??????? SSIS ??????? ????? ?????? ??????? ??? ??????? Dtexec.exe SSIS. ???????? ??? ???? ????? ??????? ???? ?????? ?????? ?? ??? ???????. ????? ???? ??????? ????? "????? ??????" ?? ????????? ?????? ?????? ????? ??????? ??????? ??? ??? ?? ??? ??????? ?????? ???? ???? SQL.

?? ??? ???? ?? ??? ???????:

dtexec.exe /FILE 
"C:\_work\SSISPackages\ProtectionLevelTest\ProtectionLevelTest\AgentTesting.dtsx" /MAXCONCURRENT " -1 
" /CHECKPOINTING OFF  /REPORTING V  /CONSOLELOG NCOSGXMT


????? ?????/console ?????? ?????? ??? ???:

Error: 2006-04-27 18:13:34.76
   Code: 0xC0202009
   Source: AgentTesting Connection manager "(local).msdb"
   Description: An OLE DB error has occurred. Error code: 0x80040E4D.
An OLE DB record is available.  Source: "Microsoft SQL Native Client"  Hresult: 0x80040E4D  Description: "Login failed for user 'DOMAINNAME\username'.".
End Error


Error: 2006-04-28 13:51:59.19
   Code: 0xC0016016
   Source:  
   Description: Failed to decrypt protected XML node "DTS:Property" with error 0x80070002 "The system cannot find the file specified.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available.
End Error


Log:
     Name: OnError
     Computer: COMPUTERNAME
     Operator: DOMAINNAME\username
     Source Name: Execute SQL Task
     Source GUID: {C6C7286D-57D4-4490-B12D-AC9867AE5762}
     Execution GUID: {7AFE3D9E-5F73-42F0-86FE-5EFE264119C8}
     Message: Failed to acquire connection "(local).msdb". Connection may not be configured correctly or you may not have the right permissions on this connection.
     Start Time: 2006-04-27 18:13:34
     End Time: 2006-04-27 18:13:34
End Log

?????

????? ?? ????????? ??? ????? ??????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ? Microsoft":
904800???? ????? ??? "??? ??? ????? ?????" ??? ?????? ????? ???? ????? ????? ????? ? SQL Server 2005 ?? SQL Server 2005
????? ?? ????????? ??? ????? ??????? ?????? ???????? Dtutil.exe ?? ?????? ?????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ? Microsoft":
906562????? ??????? ?????? ???????? dtutil (Dtutil.exe) ?????? ????? ??????? ????? ??? ????? ????? ???? SQL (SSIS) ?? SQL Server 2005
????? ?? ????????? ??? ????? ????? ????? ??????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ? Microsoft":
908018????? ????? ???? ???? ?? Studio ????? ???? ??????? ???? SQL


????? ?? ????????? ??? ?????? ???? SSIS ???????? ProtectionLevel ? ???? ??????? "???? ???????? ?????? ?????" ?? ??? SQL Server 2005.

???? ????? ?????????? ?? ?????? ?? ??????? ???? ???? ???? ?????????? ????? ?? ??? ??????. ?????? ??? ???? ?? ????????? ??? ????? ???? SQL Server ? SSIS? ???? ???????? ??????? ?? ??? SQL Server 2005:
  • ????? ?????? ?? SQL Server ???? ???????
  • ????? ????? ???? ???? SQL

???????

???? ???????: 918760 - ????? ??? ??????: 04/?????/1434 - ??????: 2.0
????? ???
  • Microsoft SQL Server 2008 Service Pack 1
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Standard
  • Microsoft SQL Server 2005 Service Pack 3
  • Microsoft SQL Server 2005 Service Pack 2
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Enterprise Edition for Itanium Based Systems
  • Microsoft SQL Server 2005 Enterprise X64 Edition
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Standard X64 Edition
  • Microsoft SQL Server 2005 Standard Edition for Itanium Based Systems
????? ??????: 
kbsqlsetup kbprb kbsql2005ssis kbsql2005setup kbexpertiseinter kbexpertiseadvanced kbtshoot kbmt KB918760 KbMtar
????? ????
???: ??? ????? ??? ??????? ???????? ????? ?????????? ??????? ?????? ??? ??????? ?? ??? ??????? ?? ??????? ??? ??? ?? ???? ????????? ???? ??????? ???????(CTF) ?? ?? ???? ????? ????. ???? ?? ???? ?????????? ??? ???????? ???????? ???? ??? ?? ???????? ??????? ?? ??? ??????? ???????? ?? ??? ??????? ??????? ??? ?????? ?? ?????? ??? ???? ???????? ???????? ?? ????? ??????? ????? ????? ??????. ??? ?? ???????? ???????? ?? ????? ??? ????? ?? ???????? ?? ???? ????? ?? ?????. ?????? ??? ???? ?????????? ???? ?????? ?? ??? ????? ?? ??? ??? ?? ??????? ?? ??? ????? ?? ???? ????? ????? ?? ????? ??????? ???? ?? ???????? ?? ??? ???????.
???? ??? ????? ??????? ?????? ??????????918760

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

 

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