The package could not be loaded。 1.NewPack.dtsx 这个包的保存位置,如果是网络共享目录,则修改为本地目录. 2.包所在路径是否允许SYSTEM帐户访问, 总体来说,是当前的JOB无法访问或者找到对应的NewPack.dtsx包. 检查你的包的路径和SYSTEM的访问权限.PS:如果需要访问网络资源或者在域中进行数据的导入导出话, 尽量使用域帐号来启动JOB.
Date 2/17/2009 12:52:58 PM Log Job History (sql2sql)Step ID 0 Server test17 Job Name sql2sql Step Name (Job outcome) Duration 00:00:01 Sql Severity 0 Sql Message ID 0 Operator Emailed Operator Net sent Operator Paged Retries Attempted 0Message The job failed. The Job was invoked by User sa. The last step to run was step 1 (1). -------------------------------------------- Date 2/17/2009 12:52:58 PM Log Job History (sql2sql)Step ID 1 Server test17 Job Name sql2sql Step Name 1 Duration 00:00:01 Sql Severity 0 Sql Message ID 0 Operator Emailed Operator Net sent Operator Paged Retries Attempted 0Message Executed as user: test17\SYSTEM. The package execution failed. The step failed.全部错误代码,test17是我的服务名称,system是启动服务使用的用户名。
job 的所有者已经是 sa了。
1.NewPack.dtsx 这个包的保存位置,如果是网络共享目录,则修改为本地目录.
2.包所在路径是否允许SYSTEM帐户访问,
总体来说,是当前的JOB无法访问或者找到对应的NewPack.dtsx包.
检查你的包的路径和SYSTEM的访问权限.PS:如果需要访问网络资源或者在域中进行数据的导入导出话,
尽量使用域帐号来启动JOB.
Log Job History (sql2sql)Step ID 0
Server test17
Job Name sql2sql
Step Name (Job outcome)
Duration 00:00:01
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0Message
The job failed. The Job was invoked by User sa. The last step to run was step 1 (1).
--------------------------------------------
Date 2/17/2009 12:52:58 PM
Log Job History (sql2sql)Step ID 1
Server test17
Job Name sql2sql
Step Name 1
Duration 00:00:01
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0Message
Executed as user: test17\SYSTEM. The package execution failed. The step failed.全部错误代码,test17是我的服务名称,system是启动服务使用的用户名。
但是oracle --> sql 的job ora2sql.dtsx 文件执行还是有问题。ora2sql.dtsx单独执行是可以的,放在job里面就不行,有什么需要注意的吗?
但是oracle --> sql 的job ora2sql.dtsx 文件执行还是有问题。 ora2sql.dtsx单独执行是可以的,放在job里面就不行, 为什么呢?