INF: ????? ????? ???? DTS ?????? ???? ??????

?????? ????????? ?????? ?????????
???? ???????: 269074 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

??????

????? ???? ?? ??????? ???? ????? ?? ???? ????? ????? ?????? (DTS) ???? DTS ???? ????? ?? ??????? ?? ????? ??????? SQL Server ???? ???? DTS ??? ????? ??? ????? ????? ?????. ????? ?? ???? ??? ????? ?????? ?? ???? ???? ??? ????? ?????? ????? ????? ??? ????? ?????? ???? ??????.

???? ??? ??????? ?????? ?????? ???????? ?? ??? DTS ??? ???????.

??????? ????

????? ??? ????????? ????????? ?? ??? ???????:
?? ??? ??????????? ??? ??????
???????
???? ????????? ??????? (dts)????? ????? ????????
?????? SQL???? ???? ???? ????? ??? Microsoft SQL Server ?????? ????? ?????? ?????? ??????.
?????? ??????????? ?????? SQL.
?????? SQL???? ?????? SQL.
?????? Microsoft Windows NT????? ???? ?????? ???? ???? ?????? Microsoft Windows ????? SQL Server ?? ?????? ?? ?? ??? ?????? ????? ?????? ?? ??? ??? ????? ???? ???????? ??? ???? ??????? ???? ????? ??????? Microsoft Windows NT ?? ???? ??????? Microsoft Windows 2000 Microsoft Windows 95 ?? Microsoft Windows 98.
?????? ???????????? ?????? Microsoft Windows NT.
?????? Windows NT ?? ???? ??????? Microsoft Windows 2000???? ?????? Microsoft Windows NT.
????? ???? Microsoft Windows NT ?? ????? ???? ????? ???? Windows ?? ??????? ???? ????? ?????? ?? Microsoft Windows NT ?? ???? ??????? Microsoft Windows 2000 ???? ????? ??????.
???? SQL???? ???? ???? SQL
sem????? ??????? SQL Server

??? ??? ????? ???? DTS ?

?? ???? ??????? ???? ??? ????? ???? ????? ??? ????? DTS ????? ?? ?????? ??? ????? ???? ?? SQL Enterprise Manager ????? ????? ??? ????? ?????? DTS ?????. ??? ????? ?????? ?? ???? DTS ?? ????? ??????? ?? SQL (SEM) ?????? ??? ??????? ??? ????????? ??? ??????. ??? ??? ?? ?????? (??? ?????? ?? ?? ???? ?????? ?????? ??????) ? ??? ????? ?????? ??? ??????. ?? ???? ?????? ?? ???? ??? ?? ????? ???? SQL Server ?? "????? ??????? ??? ????? ?????? ??? ???? ?????. ???? ?????? ????? ?????? ?? ???? Windows NT ???? ???????? ?????? ?????? ??? ??? ?????????. ??? ????? ?????? ????? ?????? ??? ?????? ????? ?????? ??? ??????.

???? ????? ???? ???? ?? ??????? ???? DTS ???? ?????? ??? ???? ????? ?????? ??? ??? ???? DTS ?? "????? ???????. ??? ????? ???? DTS ??? ????? ????? ?????? ?????. ??? ???? ???? ?????? ?? ???? ????? ?????? ?????? ??? ??????. ??? ?? ?????? ????? ???????? ?????? ??? SQL Server ? ???? ?????? ?? ?? ???? ??? ??? ??????? ??? ????? ??? ??????. ??? ?? ??????? ?????? ??? ???? ???, ???? ?????? ??? ?? ???? ???? ???? ?????? ???????.

???? ?????? ???? ???? ?????? ???? DTS ?

??? ????? ????? ?????? ????? ???? ???? ??? ?????? ?????? ???? "???? SQL. ??? ??? ?????? ????? ?? ???? ?????? ? ????. ???? ?? ???? ?????? ????? ???? SQL Server ?? ???? Windows NT.

?????? ??????:
  • ???? ????? ??????? ??? ?????? ?? "????? ??????? ??? ?? ???? ?? ???? ??????? ?????? ???????? ??????.

    - ?? -

  • ????? ????? ?????? ?????? msdb.dbo.sp_help_job.
SQL Server 7.0

??? ????? ???? ?????? ???? ??? ????? ?????? ?????? ???? ??????. ???? ?????? ????? ?? ??? ????? ???? ??? ????? ??? ????? ?????? ?????? ? ?? ?????? ???? ??? ???? ???? SQLAgentCmdExec ????? ?? ???? ??????? ??? ??????.

?????? ??? SQLAgentCmdExec ??? ????? ?? ????? ?????? ???? ??????? ????? SQL ?????? SQLAgentCmdExec ??? ?? ???? ???????? ???????? ?? Windows NT/? ??? ??? ?????? ??? ????? ?????? ??? SQL Server ???????? ???????? ???????? ????? ????????. ??? ???? SQLAgentCmdExec ???? ??? ?? ???? ???? ???? ????????? SQL Server ??????. ????? ???? ??? ???? ????? ????? ???????? ??? ??? ??? ????? ????? ???????? ?? ??? ????? ???? ??? ????? ??? ????? ??????.

SQL Server 2000

??? ????? ???? ?????? ???? ??? ????? ?????? ?????? ???? ??????. ?? ???? ?????? ????? ?? ??? ????? ???? ??? ????? ??? ????? ?????? ?????? ? ?? ?????? ???? ??? ???? ????? ???? ??? ???? ???? ???? SQL ?? ?? ???? ??????? ??? ??????.

?? SQL ???? ???? ??? ????? ?? ????? ?????? ???? ??????? ????? SQL ?????? ???? ???? SQL ??? ?? ???? ???????? ???????? ?? Windows NT/? ??? ??? ?????? ??? ????? ?????? ??? SQL Server ???????? ???????? ???????? ????? ????????. ???? ?????? ???? DTS ??? ????? ???? ???? ???? SQL ?? ???? ?????? ??????? ??? ?????? ?????? ???? ???? SQL Server. ??? ???? ???????
c:\Documents ? Settings\ <account>\Local Settings\Temp
??? ????? ?????? ??? ???? (????? ???? SQL Server ?? ????? ???? ?????? Windows NT) ???? ????? ??? ????? ?????? "? ??? ????? ???? ???? SQL ??? ???? ?????? ???????? ???? ???? ???? SQL.

?????? ????? ?????? ??? ???? ???? Windows NT ?????? ????? ?????? ?? SQL Server ?? SQL Server ??????? (?? ????) ??? ???? ??? ????? ???? SQL Server ???????? ???? ?? ??? ?????? ?? ???? ?? ???? ?????. ??? ???? ??????? ??? ???? ???? ???? SQL ????? ??? ???? ?? ?????? ???????? ??????? ?? ??? ?? ???? ?????? ???????? ???? ????? ???? SQL Server ??? ?? ?????? ???????? ??????? ?? ???? ????? ??? ?? ??? ?????? ???????? ???????. ??? ????? SQL Server ???????? ???? ???? ???? ?????? ??????.

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

????: ??? ????? ??? ?????? ?????? ??? ???? DTS ????? ????? ?????? ????? ?? ?????? ????? ?

???????: ???? ?????? ???? SQL ????? ??? ????? ????? SQL Server ?? ????? ???????. ??? ?? ????? ???? SQL ???????? ?????? Windows NT ? ???? ?????? ???????? ?? ?????? ???????? ???? ???? ???? SQL. ??? ?? ????? SQL Server ?? SEM ?????? ?????? SQL (??? ???? ??????? ?????? SA) ? ???? ?????? ?? ??? ????? ???? SQL Server ???.

?????? ????? ??????:
  1. ???? ????? ??????? ??? ?????? ?? "????? ???????.
  2. ???? ??? ????? ??????? ??? ?? ???? ??? ???? ??????? ?????? ???????? ??????.
????? ????? ??????? ????? ?????? ?????? msdb.dbo.sp_update_job ?????? ????? ??????.

??? ??? ????? ???? DTS ?

?? ???? ????? ???? ?????? ???????? ?????? ???????? ???? ??????? DTSRun.exe ???? ?????? ???? ?? ???? Windows ????????? ?????? ?????? ??? ?????????. ??? ??? ?????? ?????? ???????? DTSrun.exe ???? xp_cmdshell ????? ????? ???? ??? ????? ?????? ?? ???? ?????? ???????? ???? ???? SQL Server ???? ?? ???? ???????? ??????? xp_cmdshell ????? ??? ????? ??????. ??? ?? ??? ???????? ????? xp_cmdshell ???? ?? ??? ????? ?????? ???? DTSRun.exe ?? ???? ???? SQLAgentCmdExec.

??? ?? ??? ????? SQL Server ???????? ???? ?????? ?????? "? ???? DTS ?? ??? ???? ?????? ???? ??????? ???? ????? ??????? SQL Server.

??? ??? ??? ????? ???? SQL Server ??? ???? Windows NT ? ?????? ?? ??? ?????? ????????? ???? ???? Windows NT. ??? ??? ??? ???? Windows NT ???? ???? ???? (????? ??? ???? ????) ? ?? ????? ?????? ??? ???? ???? ??? ?????????. ???? ???? Windows NT ??? ???? ????? ?? ????? ?????? ?? ?????? ??? ??????? ??? ?????? ?? ????? ??????? ?????? ??? ??? ??????.

??? ??? ?????? Windows NT "???? ???? ???????" ?

?? ??? ??????? ????? ???? DTS ??? ???? ???? ????? ????? ?????? ???????? ?????? Windows NT. ???? ???? ???????? ???? ??????? ?? ??? ???? ?????? ???? ??? ???????. ?? ???? ????? ?????? ?? ???? ??????? ???????? DTSRun.exe ??? ??????? ?????? ?????? ???? Windows NT ?????? ????? ??????. ??? ?? ????? ?????? ????? ???? ???? SQL ?? ????? ????? ?????? ???????? ???????? ?????? ???? ???????? ?????? ???? SQL (??????? ?? ???? ?????? ??? ??? ????? ??????).

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

???? ??? ??? ?????? ??????? ??????? ???? ?? ??????? ??? ????? ??? DTS ?? ?????? ???????? ?? ???? SQL:

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

????? ?????? ??? ?????? ?????? ???????? ?????? ??? ???? ????? ?????, ?? ???? ????? ?????? ??? ????? ????? ?????? ???? SQL ? ??? ????? ?? ???? ??????. ???? SQL ???? Windows NT ? ?? ???? ???? ????? Windows NT ???? ?????? ??????? ???????. ??????? ????? ?? ??????? ??????? ???????? ???? ?? ?????? ????? ???? ?????? ?????? ?????? ??? ???? ??? Windows NT. ?? ???? ??????? ?? ????? ????? ??????????. ??????? ???? UNC ????? ?? ??? ???? ????? ?????. ?????? ??? ??????? ?????? ??? ????? ?? ???? ??????? ???? ????? ?????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
180362INFO: ????? ??????? ??????? ?????? ???????

???? ????

?????? ?????? (?? ??? ???? ???????) ????? ??? ?????? ?????? ?? ?????? (??? C:\). ??? ?? ????? ??? ???? ??? ???? ??? ????? ????? ? ?????? ???? ??? ????? ?????? ?????????. ???? ?????? ??? ???? ??????? ???? ???? ???? ????? ?? ??????. ?? ?? ??? ????? ??? ??????? ???????? ??? ??????, ???? ????? ??????.

?????? COM ?? ??????? ?????? ?? ActiveX

??? ??? ???? ?????? COM (??? ???? ??????? ????????? ??? ?????? ?????? Microsoft ActiveX (ADO) ?? ?????? ???????? ?????? (RDO) ?? ???? ??? ???????? (DSO) ????????) ?? ?????? ??? ActiveX, ??? ?? ???? ???????? ???? ??? ????????? ???? ??? ???? ????? ?????? DTS. ??? ??? ?????? ?????? ?? ???? DTS ?? SEM ?? DTSRun.exe ??? ?? ???? ???????? ?????? ??? ????????? ???? ???? ??????. ??? ??? ????? ?????? ?????? ??? ???? SQL, ??? ????? ???????? ???? ??? ????????? ???? ?????? ???? SQL.

???? ??????

???? ?? ????? ??? DTS ????? ?????? ???? ?????? ???? ????????. ???? ??? ????? ?????? ??? ????? ???? ????? ????? ??????. ?? ??? ?? ?? ??? ???? ??? ???? ?????? ???? ??? ????? ??????.

?????? SQLAgentCmdExec

?? ???? ????? ?????? ??? ???? ???? SQLAgentCmdExec ???? SQLAgentCmdExec ??? ???? ???? ????? ?????? ??? SQL Server ?? ???? ?????? ?? ????? ????? ???????:
DTSRun: ?????... DTSRun: ?????... DTSRun OnError DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart:: DTSStep_DTSExecuteSQLTask_1 ??? =-2147217843 ????? (80040E4D) ??? ???: ??? ????? ?????? ???????? 'NT_name\SQLAgentCmdExec'. ??? ??? ????? ??????: "????" Microsoft OLE DB ???? ??????? ???? SQL: ???? ?????????: "????? ?????? ?????" 0: ???:-2147217843 (80040E4D); "??? ????": 18456 ????? ??? (4818): ??? ????? ?????? ???????? 'NT_name\SQLAgentCmdExec'. ??? ??? ????? ??????: "????" Microsoft OLE DB ???? ??????? ???? SQL: ???? ?????????: OnFinish DTSRun 0: DTSRun DTSStep_DTSExecuteSQLTask_1: ???? ????? ???????. ??????? ????? ??? 1. ??? ??????.
??? ??? ????? ?????? ??????? ???? SQLAgentCmdExec ?????? ???? ????? ?? SQL Server.

???????

???? ???????: 269074 - ????? ??? ??????: 14/????/1428 - ??????: 3.6
????? ???
  • Microsoft SQL Server 7.0 Standard Edition
  • Microsoft SQL Server 2000 Standard Edition
????? ??????: 
kbmt kbproductlink kbinfo KB269074 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????269074

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

 

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