????? ??????? ?????? ???????? dtutil (Dtutil.exe) ?????? ????? ??????? ???? ??? ????? ????? ???? SQL (SSIS) ?? SQL Server 2005

???? ???????: 906562 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???????? ????? ????? ??????? ?????? ?????? ???????
????? ???? | ?? ????

????? ???

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

??? ???? ??????? ?? ???? ????? ???? ???? ????? ???? ???????? ???? ???? ????? ????? ?????? ????? ?????? ??? ??????. ????? ????? ???? ???? ?????? ???????? SQL Server ????? ???? ????? Studio ?? ???????? ?????? ???????? dtutil (Dtutil.exe) ????? ?????. ??? ???? ??? ??? ???? ??????? ?????? ?? ??? ???? ????? ???????? ?????? ???????? dtutil ?????? ????? ??????? ???? ??? SSIS. ???? ??? ????? ??????? ??????? ?? ???? ???? ??? ?? ??? .bat ?? ?? ??? .cmd ?? ?? ?????? ?????. ??? ?? ????? ????? ?? ??? ?????? ? ????? ??????? ??????? ????? ?????? ????? ?????? ????? ?? ??? ??????.
???? ??? ?????? | ????? ???????

??????? ????

???? ??? ????????? ??????:
  • ??? ????? ??? SSIS ??? ????? ??????? ?????????.
  • ????? ??? ????? ????? ???????? ???? ???? ??? ????? ?????? ??????? ????? ?????? ???? ??????.
?? ??? ?????????? ????? ??????? ????? ?????? ???????? ?????? ???????? dtutil ????? ????? ??????? ?? ??? ?????. 
for %%f IN (*.dtsx) DO dtutil.exe /File %%f /encrypt file;%%f;3;<promissory password>
?????????
  • ??? ???? ??? ????? ????? ???? ??? ????? ??????? ????????? ??? ????? ??????? ????????? ??? SSIS ???? EncryptAllWithUserKey. ???? ??????? ??????? ????????? ????? ???????? ????? ???? ????? ??? ??? ????? ????????.
  • ????? ????? /q ????? ??????? ??????.
  • ??? ??? ?????? ??? ????? ?? ???? ??????? ??????? ??? ???? ?????? ??????? (%). ??? ??? ?????? ??? ????? ???? ??? ???? ????? ??? MS-DOS ??????? ???? ????? ?????? ??????? (%).
  • ?? ??? ?????? <promissory password> ?????? ?????? ???? ??????.
  • ????? ??? ????? ?????? ???? ????? ??????. dtutil.exe 
    dtutil.exe /File %%f /encrypt file;%%f;3;<promissory password>
    ?? ????? ????? ??????? ?????? ?? ?????. ?? ??? ??????? ??? ????? ????? ??????? ??? 3 ??? ???? ??????. ?????? ??? ??????? ????? ??????? ?? ?????? ?????? ???????? ??? ????????.
?? ??? ??????????? ??? ??????
????????
0???? ????????? ??????.
1??? ????? ????????? ?????? ???????? ?????? ?????? ???????? ??????.
2??? ????? ????????? ?????? ???????? ???? ?????? ????????.
3?? ????? ?????? ???????? ???? ?????? ????????.
4?? ????? ?????? ???????? ?????? ?????? ???????? ??????.
5?????? ?????? ????? ??????? SQL Server.
????? ?? ?????????? ???? ????? ?????? ?? ???? ???????:
dtutil / ? ?????
??? ???? ????? ?????? ??????? ??? ????? ? ?? ???? ????? ???? ?????? ??? ???? ???? ???? ????? ?????? ?? ????? ????? ??????? ????? ??????. ???? ?????? ?????? ??????? ????? ?????? ??????? ?????? ???????? dtutil ?????? ???? ?????? ?? ??? ??? ?????. 
for %%f IN (*.dtsx) DO dtutil.exe /File %%f /Decrypt <promissory password> /encrypt file;%%f;3;<new password>
???? ??? ?????? | ????? ???????

?????

????? ?? ????????? ??? ????? ??????? ?????? ???????? dtutil ?????? ????? ??????? ??? SSIS ???? ???????? ??????? ?? SQL Server 2005 ????????:
  • ????? ????? ??????? ?????
  • ???????? ?????? ?????? "????? ?????"
  • ????? ??????? ??????
  • ?????? ???????? dtutil
???? ??? ?????? | ????? ???????

???????

???? ???????: 906562 - ????? ??? ??????: 11/???/1427 - ??????: 2.2
????? ???
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Standard Edition
????? ??????: 
kbmt kbsql2005ssis kbhowto KB906562 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????906562
(http://support.microsoft.com/kb/906562/en-us/ )
???? ??? ?????? | ????? ???????

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

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