????? ????? ??????? ??????? ?? ????? ?????? "????? ??????" ?? SQL Server 2005 ????? Services

?????? ????????? ?????? ?????????
???? ???????: 906547 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

????? ???

????? ????? ???? Microsoft SQL Server 2005 ????? ????? (SSIS) ?????? ??????? SQL Server ????? ???? ????? Studio. ??? ????? ??? ?????? ????? ????? ????? ??????? ???? SSIS ?????? ?? ????? ??????? ?? ??? ???????. ??? ???? ??????? ??? ???? ?????? SSIS ????? ???? ????? ?????? "? ????? ????? ????? ??????? ??????? ??? ??? MessageSource ???????. ???? ??????? ????? ??????? ??????? ??????? ????? ????? ?????? ??????????. ???? ??????? ????? ??????? MessageSource ??????? ????????? ?? ????? ?????? ?????????? ??? ??????? ????? ????? "??? ??????".

?????? ??? ??????? ????? ????? ??????? ??????? ?? ????? ?????? "????? ??????".

??????? ????

???? ?????? ????? ????? ????? ?????? "???????" ?? ???? "????? ??????".
"Package>>> " + @[System::PackageName] +" was executed at>>> " + (DT_WSTR, 40) @[System::StartTime] + " by user>>> " + @[System::UserName] + " on Machine>>> " + @[System::MachineName]
??? ??????? ??? ??????? ????? ????? ??? ????? ????? ????? ?????? ?????????? ???? ????. ?????? ??????? ????????? ???????:
  • ??????? ????
    ?? ??? ??????? ????? ????? ????? ?????? ?????????? "???? >>>" ??????? ????.
  • ??????? ??????
    ????? ????? ?????? ?????????? ??????? ?????? ???????:
    • PackageName
      ??? ??????.
    • StartTime
      ????? ???? ?? ????? ??????.
    • ??? ????????
      ??? ???????? ??????.
    • MachineName
      ??? ????????? ????? ??????.
??? ????? ????? ???? ?? ????????? ?? ????? ??? ????? ?????? ?? ??? ????????. ??? ???? ??????? ???? ?? ????? ???? ???? ???????? ??? ?????? ??????? ??? ?????? "????? ??????". (??? ??????? ????? "??? ??????" ????? ??????.) ???? ??? ??????? ???? ????? ?????? ?? ??? ???????? ???? ???? @ myrowcount. ???? ??? ??????? ??????? ???? ?? ???? ????????.

?????? ????? ????? ???? ???????? ??? ??? ??? ??? ?????? ???? ?? ???? ????? ????? ???? ????? ?????? ???????? ???? ????????. ?????? ????? ???? ??????? ???????:
  1. ?? SQL Server ????? ???? ????? Studio ? ???? ??? ?????? ?????? ??? ?????? ???? ???????? ??? ?? ???? ??? ????? ????? ??????.
  2. ???? ????? ??????? ??? ????? ?????? ???? ??? ????????.
  3. ?? ???? ?????? ???? ????? ?????? ???? ??? ????? ? ????? ?? ????? ???????.
  4. ?? ?????? ????? ???? ??????? ??????:
    @ myrowcount < 2
  5. ?? ???? ?????? ???? ????? ?????? ???? ??? "?????".
??? ?????? ??? ?? ?????? ?? ???? ???????? ? ??? ????? ????? ???? ????????.

???????? ??? ???? ???? ??????? "????? ??????" ?????? ???? ?? ????? ???. ??? ???? ??????? ?? ???? ?? ????? ????? ???? ???????? ????????? ????? ?? ?????? ???? SSIS. ?????? ????? ?? ?????? ????? ????? OnError ?????? ?? ?? ?????? ???? ???? "????? ??????" ??? ????? ???????. ????? ??? ????????? ????? ????? ???? ????? ????? ???? ??? ????? ?????? ??? ??? ??????? ?? ??? ??? ????? ????? ?? ??????? ?????? ??? ?????. ??? ???? ??????? ?? ?????? ????? ?????? ??? ???.
"Error in the task: " +  @[System::SourceName] + "with the ID: " +  @[System::SourceID] + " has failed at: " + (DT_WSTR, 20) @[System::ContainerStartTime] + "."
?????? ??? ??????? ????? ??????? ?????? ???????:
  • StartTime
    ??? ????? ??????.
  • ContainerStartTime
    ??? ??? ???????.
  • EventHandlerStartTime
    ??? ??? ????? ????? ???????.

?????

????? ?? ?????????? ???? ???????? ??????? ?? SQL Server 2005 ????????:
  • "???????? ????? ????????? ?? ???"
  • "?????: ????? ????? ?????"
  • '???????? ????????? ????? ?????'
  • "???? ????????"
  • "????? ???? ?????? ??? ???????" ? "??????"
  • "??????? ??????? ????? ?????"

???????

???? ???????: 906547 - ????? ??? ??????: 11/???/1427 - ??????: 2.1
????? ???
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Standard Edition
????? ??????: 
kbmt kbsql2005ssis kbhowto KB906547 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????906547

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

 

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