DTS的内容是从数据源拷贝到目的数据库,在DTS中可以执行,但添加到JOB中,想让它定期执行,但是出现错误。请问如何解决,既然在DTS中可以执行,说明连接配置应该没有问题,谢谢。Executed as user: DHUANG2-DESK\SYSTEM. DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSExecuteSQLTask_4 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_4 DTSRun OnStart: Copy Data from Results to [CAB].[dbo].[tbl_worker] Step DTSRun OnError: Copy Data from Results to [CAB].[dbo].[tbl_worker] Step, Error = -2147467259 (80004005) Error string: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0 Error Detail Records: Error: -2147467259 (80004005); Provider Error: 17 (11) Error string: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0 DTSRun OnFinish: Copy Data from Results to [CAB].[dbo].[tbl_worker] Step DTSRun: Package execution complete. Process Exit Code 1. The step failed.
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货