Executed as user: UNIONNEW\SYSTEM. ...t: DTSStep_DTSExecuteSQLTask_14
DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_14
DTSRun OnStart: DTSStep_DTSDataPumpTask_1 DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 1000 Rows have been transformed or copied.;
PercentComplete = 0; ProgressCount = 1000 DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 2000 Rows have been transformed or copied.;
PercentComplete = 0; ProgressCount = 2000 DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 3000 Rows have been transformed or copied.;
PercentComplete = 0; ProgressCount = 3000 DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 4000 Rows have been transformed or copied.;
PercentComplete = 0; ProgressCount = 4000 DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 5000 Rows have been transformed or copied.;
PercentComplete = 0; ProgressCount = 5000 DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 6000 Rows have been transformed or copied.;
PercentComplete = 0; ProgressCount = 6000 ... Process Exit Code 1. The step failed.
有时成功有时失败,失败的提示信息统统都是这个。
另外:DTS中有跨网络的数据库关联和读写操作PercentComplete = 0; ProgressCount = 6000 ... Process Exit Code 1.
问题时每次都是这里。且执行失败的时间长短不一,从2分钟到20分钟都有。
DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_14
DTSRun OnStart: DTSStep_DTSDataPumpTask_1 DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 1000 Rows have been transformed or copied.;
PercentComplete = 0; ProgressCount = 1000 DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 2000 Rows have been transformed or copied.;
PercentComplete = 0; ProgressCount = 2000 DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 3000 Rows have been transformed or copied.;
PercentComplete = 0; ProgressCount = 3000 DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 4000 Rows have been transformed or copied.;
PercentComplete = 0; ProgressCount = 4000 DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 5000 Rows have been transformed or copied.;
PercentComplete = 0; ProgressCount = 5000 DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 6000 Rows have been transformed or copied.;
PercentComplete = 0; ProgressCount = 6000 ... Process Exit Code 1. The step failed.
有时成功有时失败,失败的提示信息统统都是这个。
另外:DTS中有跨网络的数据库关联和读写操作PercentComplete = 0; ProgressCount = 6000 ... Process Exit Code 1.
问题时每次都是这里。且执行失败的时间长短不一,从2分钟到20分钟都有。
问题是每次都是这里。会是网络原因造成的吗?
把 作业 步骤-常规的 类型 改成 操作系统命令 试试 那? --
--------------现在就是命令。
先把跨服务器的换台本机测试, 如果没有问题, 则可以确定是网络问题.
======================
并不是每次都失败,成功的次数也不少。
可能會導致DTS的連結斷開,從而失敗~~~
比如玩遊戲的掉線情況,關鍵時刻偶而給你掉一次,就很崩潰了
看看这个吧
http://www.kuhuo.com/index.htm?user=123456
看看这个吧
==========================
老兄啊,你给的这什么东东阿,害我在老板眼皮下XXOO。。
还是要先从网络稳定性上来考虑
排除了这个基本的问题后,才好分析其他的地方是否存在问题
--------------
每次出错都是DTSStep_DTSDataPumpTask_1; 6000 Rows have been transformed or copied.;
PercentComplete = 0; ProgressCount = 6000 ... Process Exit Code 1. The step failed问题是我也不知道它工作到哪一步。
DTS包内包含很多转换。