Post reply

Job is showing executing status even though the log file is completed

  • August 30, 2007 at 11:48 am

    #70660

    I created job in EM couple days ago. It was running ok until yesterday. When run, job is showing execution status forever, but log file is completed with the last line:

    DTSRun: Package execution complete.

    Job owner is sa.

    Thanks for any idea?

    Elma

  • August 30, 2007 at 12:04 pm

    #730537

    It may not actually be done with everything. Try stopping the job and see what messages the history has in it then. Or you may have the job on success set to restart the step or other looping work in the whole deal.

  • August 30, 2007 at 12:25 pm

    #730547

    Tried that already…when I stop the job message in history is: The job was stopped prior to completion…

    I have a job success set to “quit the job reporting success”.

    Run out of any idea, please help…

  • August 31, 2007 at 10:38 am

    #730836

    Elma,

    Do any of the steps in the package log have a Run Status of 0?  If so, that step never finished.  I see this occasionally with a package that uses ODBC to copy data from another database platform to SQL Server.  Sometimes, the ODBC connection is lost but the package continues to run, waiting for the data copy to finish. 

    When it happens, I have to cancel the job and restart it.

    Greg

    Greg

  • August 31, 2007 at 11:28 am

    #730844

    Greg,

    Thanks for this idea, but I can not see Run Status in log file. If you can tell me where is that, here is my log file:

    DTSRun:  Loading...

    DTSRun:  Executing...

    DTSRun OnStart:  DTSStep_DTSActiveScriptTask_38

    DTSRun OnFinish:  DTSStep_DTSActiveScriptTask_38

    DTSRun OnStart:  DTSStep_DTSDynamicPropertiesTask_22

    DTSRun OnFinish:  DTSStep_DTSDynamicPropertiesTask_22

    DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_62

    DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_62

    DTSRun OnStart:  DTSStep_DTSActiveScriptTask_26

    DTSRun OnFinish:  DTSStep_DTSActiveScriptTask_26

    DTSRun OnStart:  DTSStep_DTSActiveScriptTask_27

    DTSRun OnFinish:  DTSStep_DTSActiveScriptTask_27

    DTSRun OnStart:  DTSStep_DTSDynamicPropertiesTask_14

    DTSRun OnFinish:  DTSStep_DTSDynamicPropertiesTask_14

    DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_5

    DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_5

    DTSRun OnStart:  DTSStep_DTSActiveScriptTask_3

    DTSRun OnFinish:  DTSStep_DTSActiveScriptTask_3

    DTSRun OnStart:  DTSStep_DTSDynamicPropertiesTask_3

    DTSRun OnFinish:  DTSStep_DTSDynamicPropertiesTask_3

    DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_6

    DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_6

    DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_7

    DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_7

    DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_12

    DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_12

    DTSRun OnStart:  DTSStep_DTSActiveScriptTask_5

    DTSRun OnFinish:  DTSStep_DTSActiveScriptTask_5

    DTSRun OnStart:  DTSStep_DTSActiveScriptTask_4

    DTSRun OnFinish:  DTSStep_DTSActiveScriptTask_4

    DTSRun OnStart:  DTSStep_DTSDynamicPropertiesTask_4

    DTSRun OnFinish:  DTSStep_DTSDynamicPropertiesTask_4

    DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_2

    DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_2

    DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_26

    DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_26

    DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_24

    DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_24

    DTSRun OnStart:  DTSStep_DTSDataPumpTask_6

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_6; 1000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 1000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_6; 2000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 2000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_6; 3000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 3000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_6; 4000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 4000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_6; 5000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 5000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_6; 6000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 6000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_6; 7000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 7000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_6; 8000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 8000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_6; 9000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 9000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_6; 10000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 10000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_6; 11000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 11000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_6; 12000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 12000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_6; 13000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 13000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_6; 14000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 14000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_6; 15000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 15000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_6; 16000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 16000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_6; 17000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 17000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_6; 18000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 18000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_6; 19000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 19000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_6; 20000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 20000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_6; 21000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 21000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_6; 22000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 22000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_6; 23000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 23000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_6; 24000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 24000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_6; 25000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 25000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_6; 26000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 26000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_6; 27000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 27000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_6; 28000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 28000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_6; 29000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 29000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_6; 30000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 30000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_6; 31000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 31000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_6; 32000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 32000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_6; 33000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 33000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_6; 34000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 34000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_6; 35000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 35000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_6; 36000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 36000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_6; 37000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 37000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_6; 38000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 38000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_6; 39000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 39000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_6; 40000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 40000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_6; 41000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 41000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_6; 42000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 42000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_6; 43000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 43000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_6; 44000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 44000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_6; 45000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 45000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_6; 46000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 46000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_6; 47000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 47000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_6; 48000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 48000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_6; 49000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 49000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_6; 50000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 50000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_6; 51000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 51000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_6; 52000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 52000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_6; 52538 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 52538

    DTSRun OnFinish:  DTSStep_DTSDataPumpTask_6

    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

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_1; 7000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 7000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_1; 8000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 8000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_1; 9000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 9000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_1; 10000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 10000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_1; 11000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 11000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_1; 12000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 12000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_1; 13000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 13000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_1; 14000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 14000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_1; 15000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 15000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_1; 16000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 16000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_1; 17000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 17000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_1; 18000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 18000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_1; 19000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 19000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_1; 20000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 20000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_1; 21000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 21000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_1; 22000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 22000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_1; 23000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 23000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_1; 24000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 24000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_1; 25000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 25000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_1; 26000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 26000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_1; 27000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 27000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_1; 28000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 28000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_1; 29000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 29000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_1; 30000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 30000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_1; 31000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 31000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_1; 32000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 32000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_1; 33000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 33000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_1; 34000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 34000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_1; 35000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 35000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_1; 36000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 36000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_1; 37000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 37000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_1; 38000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 38000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_1; 39000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 39000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_1; 40000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 40000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_1; 41000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 41000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_1; 42000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 42000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_1; 43000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 43000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_1; 44000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 44000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_1; 45000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 45000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_1; 46000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 46000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_1; 47000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 47000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_1; 48000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 48000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_1; 49000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 49000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_1; 50000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 50000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_1; 50572 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 50572

    DTSRun OnFinish:  DTSStep_DTSDataPumpTask_1

    DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_25

    DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_25

    DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_3

    DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_3

    DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_64

    DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_64

    DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_63

    DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_63

    DTSRun OnStart:  DTSStep_DTSDataPumpTask_7

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_7; 1000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 1000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_7; 2000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 2000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_7; 3000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 3000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_7; 4000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 4000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_7; 5000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 5000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_7; 6000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 6000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_7; 7000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 7000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_7; 8000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 8000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_7; 9000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 9000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_7; 10000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 10000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_7; 11000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 11000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_7; 12000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 12000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_7; 13000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 13000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_7; 14000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 14000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_7; 15000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 15000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_7; 16000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 16000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_7; 17000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 17000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_7; 18000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 18000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_7; 19000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 19000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_7; 20000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 20000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_7; 21000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 21000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_7; 22000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 22000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_7; 23000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 23000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_7; 24000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 24000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_7; 25000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 25000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_7; 26000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 26000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_7; 27000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 27000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_7; 28000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 28000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_7; 29000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 29000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_7; 30000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 30000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_7; 31000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 31000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_7; 32000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 32000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_7; 33000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 33000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_7; 34000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 34000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_7; 35000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 35000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_7; 36000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 36000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_7; 37000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 37000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_7; 38000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 38000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_7; 39000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 39000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_7; 40000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 40000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_7; 41000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 41000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_7; 42000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 42000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_7; 43000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 43000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_7; 44000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 44000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_7; 45000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 45000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_7; 46000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 46000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_7; 47000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 47000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_7; 48000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 48000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_7; 49000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 49000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_7; 50000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 50000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_7; 51000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 51000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_7; 52000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 52000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_7; 52538 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 52538

    DTSRun OnFinish:  DTSStep_DTSDataPumpTask_7

    DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_17

    DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_17

    DTSRun OnStart:  DTSStep_DTSActiveScriptTask_6

    DTSRun OnFinish:  DTSStep_DTSActiveScriptTask_6

    DTSRun OnStart:  DTSStep_DTSActiveScriptTask_8

    DTSRun OnFinish:  DTSStep_DTSActiveScriptTask_8

    DTSRun OnStart:  DTSStep_DTSDynamicPropertiesTask_6

    DTSRun OnFinish:  DTSStep_DTSDynamicPropertiesTask_6

    DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_18

    DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_18

    DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_19

    DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_19

    DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_15

    DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_15

    DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_27

    DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_27

    DTSRun OnStart:  DTSStep_DTSActiveScriptTask_1

    DTSRun OnFinish:  DTSStep_DTSActiveScriptTask_1

    DTSRun OnStart:  DTSStep_DTSDynamicPropertiesTask_1

    DTSRun OnFinish:  DTSStep_DTSDynamicPropertiesTask_1

    DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_30

    DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_30

    DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_31

    DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_31

    DTSRun OnStart:  DTSStep_DTSDataPumpTask_2

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_2; 1000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 1000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_2; 2000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 2000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_2; 3000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 3000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_2; 4000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 4000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_2; 5000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 5000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_2; 6000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 6000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_2; 7000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 7000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_2; 8000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 8000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_2; 9000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 9000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_2; 10000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 10000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_2; 11000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 11000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_2; 12000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 12000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_2; 13000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 13000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_2; 14000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 14000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_2; 15000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 15000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_2; 16000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 16000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_2; 17000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 17000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_2; 18000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 18000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_2; 19000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 19000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_2; 20000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 20000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_2; 21000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 21000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_2; 22000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 22000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_2; 23000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 23000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_2; 24000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 24000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_2; 25000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 25000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_2; 26000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 26000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_2; 27000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 27000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_2; 28000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 28000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_2; 29000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 29000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_2; 30000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 30000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_2; 31000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 31000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_2; 32000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 32000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_2; 33000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 33000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_2; 34000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 34000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_2; 35000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 35000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_2; 36000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 36000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_2; 37000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 37000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_2; 38000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 38000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_2; 39000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 39000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_2; 40000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 40000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_2; 41000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 41000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_2; 42000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 42000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_2; 43000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 43000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_2; 44000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 44000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_2; 45000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 45000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_2; 46000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 46000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_2; 47000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 47000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_2; 48000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 48000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_2; 49000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 49000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_2; 50000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 50000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_2; 50570 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 50570

    DTSRun OnFinish:  DTSStep_DTSDataPumpTask_2

    DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_34

    DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_34

    DTSRun OnStart:  DTSStep_DTSActiveScriptTask_2

    DTSRun OnFinish:  DTSStep_DTSActiveScriptTask_2

    DTSRun OnStart:  DTSStep_DTSActiveScriptTask_7

    DTSRun OnFinish:  DTSStep_DTSActiveScriptTask_7

    DTSRun OnStart:  DTSStep_DTSDynamicPropertiesTask_5

    DTSRun OnFinish:  DTSStep_DTSDynamicPropertiesTask_5

    DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_20

    DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_20

    DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_1

    DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_1

    DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_23

    DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_23

    DTSRun OnStart:  DTSStep_DTSActiveScriptTask_9

    DTSRun OnFinish:  DTSStep_DTSActiveScriptTask_9

    DTSRun OnStart:  DTSStep_DTSActiveScriptTask_10

    DTSRun OnFinish:  DTSStep_DTSActiveScriptTask_10

    DTSRun OnStart:  DTSStep_DTSDynamicPropertiesTask_7

    DTSRun OnFinish:  DTSStep_DTSDynamicPropertiesTask_7

    DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_10

    DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_10

    DTSRun OnStart:  DTSStep_DTSDataPumpTask_3

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_3; 1000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 1000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_3; 2000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 2000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_3; 3000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 3000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_3; 4000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 4000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_3; 5000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 5000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_3; 6000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 6000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_3; 7000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 7000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_3; 8000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 8000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_3; 9000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 9000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_3; 10000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 10000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_3; 11000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 11000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_3; 12000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 12000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_3; 13000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 13000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_3; 14000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 14000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_3; 15000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 15000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_3; 16000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 16000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_3; 17000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 17000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_3; 18000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 18000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_3; 19000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 19000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_3; 20000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 20000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_3; 21000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 21000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_3; 21074 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 21074

    DTSRun OnFinish:  DTSStep_DTSDataPumpTask_3

    DTSRun OnStart:  DTSStep_DTSDataPumpTask_8

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_8; 0 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 0

    DTSRun OnFinish:  DTSStep_DTSDataPumpTask_8

    DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_8

    DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_8

    DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_9

    DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_9

    DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_14

    DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_14

    DTSRun OnStart:  DTSStep_DTSActiveScriptTask_11

    DTSRun OnFinish:  DTSStep_DTSActiveScriptTask_11

    DTSRun OnStart:  DTSStep_DTSActiveScriptTask_15

    DTSRun OnFinish:  DTSStep_DTSActiveScriptTask_15

    DTSRun OnStart:  DTSStep_DTSDynamicPropertiesTask_9

    DTSRun OnFinish:  DTSStep_DTSDynamicPropertiesTask_9

    DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_16

    DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_16

    DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_22

    DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_22

    DTSRun OnStart:  DTSStep_DTSActiveScriptTask_16

    DTSRun OnFinish:  DTSStep_DTSActiveScriptTask_16

    DTSRun OnStart:  DTSStep_DTSActiveScriptTask_13

    DTSRun OnFinish:  DTSStep_DTSActiveScriptTask_13

    DTSRun OnStart:  DTSStep_DTSDynamicPropertiesTask_8

    DTSRun OnFinish:  DTSStep_DTSDynamicPropertiesTask_8

    DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_28

    DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_28

    DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_29

    DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_29

    DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_32

    DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_32

    DTSRun OnStart:  DTSStep_DTSActiveScriptTask_17

    DTSRun OnFinish:  DTSStep_DTSActiveScriptTask_17

    DTSRun OnStart:  DTSStep_DTSActiveScriptTask_18

    DTSRun OnFinish:  DTSStep_DTSActiveScriptTask_18

    DTSRun OnStart:  DTSStep_DTSDynamicPropertiesTask_2

    DTSRun OnFinish:  DTSStep_DTSDynamicPropertiesTask_2

    DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_11

    DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_11

    DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_13

    DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_13

    DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_4

    DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_4

    DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_21

    DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_21

    DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_33

    DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_33

    DTSRun OnStart:  DTSStep_DTSActiveScriptTask_19

    DTSRun OnFinish:  DTSStep_DTSActiveScriptTask_19

    DTSRun OnStart:  DTSStep_DTSActiveScriptTask_20

    DTSRun OnFinish:  DTSStep_DTSActiveScriptTask_20

    DTSRun OnStart:  DTSStep_DTSDynamicPropertiesTask_10

    DTSRun OnFinish:  DTSStep_DTSDynamicPropertiesTask_10

    DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_35

    DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_35

    DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_36

    DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_36

    DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_37

    DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_37

    DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_38

    DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_38

    DTSRun OnStart:  DTSStep_DTSActiveScriptTask_21

    DTSRun OnFinish:  DTSStep_DTSActiveScriptTask_21

    DTSRun OnStart:  DTSStep_DTSActiveScriptTask_22

    DTSRun OnFinish:  DTSStep_DTSActiveScriptTask_22

    DTSRun OnStart:  DTSStep_DTSDynamicPropertiesTask_11

    DTSRun OnFinish:  DTSStep_DTSDynamicPropertiesTask_11

    DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_40

    DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_40

    DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_39

    DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_39

    DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_41

    DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_41

    DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_43

    DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_43

    DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_44

    DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_44

    DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_45

    DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_45

    DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_42

    DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_42

    DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_46

    DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_46

    DTSRun OnStart:  DTSStep_DTSActiveScriptTask_23

    DTSRun OnFinish:  DTSStep_DTSActiveScriptTask_23

    DTSRun OnStart:  DTSStep_DTSActiveScriptTask_24

    DTSRun OnFinish:  DTSStep_DTSActiveScriptTask_24

    DTSRun OnStart:  DTSStep_DTSDynamicPropertiesTask_12

    DTSRun OnFinish:  DTSStep_DTSDynamicPropertiesTask_12

    DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_47

    DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_47

    DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_48

    DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_48

    DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_49

    DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_49

    DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_54

    DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_54

    DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_50

    DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_50

    DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_51

    DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_51

    DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_52

    DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_52

    DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_53

    DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_53

    DTSRun OnStart:  DTSStep_DTSActiveScriptTask_25

    DTSRun OnFinish:  DTSStep_DTSActiveScriptTask_25

    DTSRun OnStart:  DTSStep_DTSDynamicPropertiesTask_13

    DTSRun OnFinish:  DTSStep_DTSDynamicPropertiesTask_13

    DTSRun OnStart:  DTSStep_DTSDataPumpTask_4

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 1000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 1000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 2000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 2000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 3000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 3000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 4000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 4000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 5000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 5000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 6000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 6000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 7000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 7000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 8000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 8000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 9000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 9000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 10000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 10000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 11000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 11000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 12000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 12000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 13000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 13000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 14000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 14000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 15000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 15000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 16000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 16000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 17000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 17000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 18000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 18000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 19000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 19000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 20000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 20000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 21000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 21000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 22000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 22000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 23000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 23000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 24000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 24000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 25000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 25000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 26000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 26000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 27000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 27000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 28000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 28000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 29000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 29000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 30000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 30000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 31000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 31000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 32000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 32000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 33000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 33000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 34000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 34000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 35000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 35000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 36000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 36000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 37000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 37000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 38000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 38000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 39000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 39000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 40000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 40000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 41000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 41000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 42000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 42000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 43000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 43000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 44000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 44000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 45000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 45000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 46000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 46000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 47000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 47000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 48000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 48000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 49000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 49000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 50000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 50000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 51000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 51000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 52000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 52000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 53000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 53000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 54000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 54000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 55000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 55000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 56000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 56000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 57000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 57000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 58000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 58000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 59000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 59000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 60000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 60000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 61000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 61000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 62000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 62000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 63000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 63000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 64000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 64000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 65000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 65000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 66000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 66000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 67000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 67000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 68000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 68000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 69000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 69000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 70000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 70000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 71000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 71000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 72000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 72000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 73000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 73000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 74000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 74000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 75000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 75000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 76000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 76000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 77000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 77000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 78000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 78000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 79000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 79000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 80000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 80000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 81000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 81000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 82000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 82000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 83000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 83000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 84000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 84000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 85000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 85000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 86000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 86000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 87000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 87000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 88000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 88000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 89000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 89000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 90000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 90000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 91000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 91000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 92000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 92000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 93000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 93000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 94000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 94000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 95000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 95000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 96000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 96000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 97000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 97000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 98000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 98000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 99000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 99000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 100000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 100000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 101000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 101000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 102000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 102000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 103000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 103000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 104000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 104000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 105000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 105000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 106000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 106000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 107000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 107000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 108000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 108000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 109000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 109000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 110000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 110000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 111000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 111000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 112000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 112000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 113000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 113000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 114000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 114000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 115000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 115000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 116000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 116000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 117000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 117000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 118000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 118000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 119000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 119000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 120000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 120000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 121000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 121000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 122000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 122000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 123000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 123000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 124000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 124000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 125000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 125000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 126000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 126000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 127000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 127000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 128000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 128000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 129000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 129000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 130000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 130000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 131000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 131000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 132000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 132000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 133000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 133000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 134000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 134000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 135000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 135000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 136000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 136000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 137000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 137000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 138000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 138000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 139000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 139000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 140000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 140000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 141000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 141000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 142000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 142000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 143000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 143000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 144000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 144000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 145000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 145000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 146000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 146000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 147000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 147000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 148000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 148000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 149000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 149000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 150000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 150000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 151000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 151000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 152000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 152000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 153000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 153000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 154000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 154000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 155000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 155000

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_4; 155892 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 155892

    DTSRun OnFinish:  DTSStep_DTSDataPumpTask_4

    DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_55

    DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_55

    DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_56

    DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_56

    DTSRun OnStart:  DTSStep_DTSActiveScriptTask_29

    DTSRun OnFinish:  DTSStep_DTSActiveScriptTask_29

    DTSRun OnStart:  DTSStep_DTSActiveScriptTask_28

    DTSRun OnFinish:  DTSStep_DTSActiveScriptTask_28

    DTSRun OnStart:  DTSStep_DTSDynamicPropertiesTask_15

    DTSRun OnFinish:  DTSStep_DTSDynamicPropertiesTask_15

    DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_57

    DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_57

    DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_58

    DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_58

    DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_59

    DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_59

    DTSRun OnStart:  DTSStep_DTSActiveScriptTask_31

    DTSRun OnFinish:  DTSStep_DTSActiveScriptTask_31

    DTSRun OnStart:  DTSStep_DTSActiveScriptTask_30

    DTSRun OnFinish:  DTSStep_DTSActiveScriptTask_30

    DTSRun OnStart:  DTSStep_DTSDynamicPropertiesTask_16

    DTSRun OnFinish:  DTSStep_DTSDynamicPropertiesTask_16

    DTSRun OnStart:  DTSStep_DTSDataPumpTask_5

    DTSRun OnProgress:  DTSStep_DTSDataPumpTask_5; 1 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 1

    DTSRun OnFinish:  DTSStep_DTSDataPumpTask_5

    DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_60

    DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_60

    DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_61

    DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_61

    DTSRun OnStart:  DTSStep_DTSActiveScriptTask_14

    DTSRun OnFinish:  DTSStep_DTSActiveScriptTask_14

    DTSRun OnStart:  DTSStep_DTSActiveScriptTask_40

    DTSRun OnFinish:  DTSStep_DTSActiveScriptTask_40

    DTSRun OnStart:  DTSStep_DTSDynamicPropertiesTask_20

    DTSRun OnFinish:  DTSStep_DTSDynamicPropertiesTask_20

    DTSRun:  Package execution complete.

     

    thanks again,

    Elma

  • August 31, 2007 at 4:02 pm

    #730886

    You don't have any tasks that are displaying a message box or automate MS Office functions, do you?

  • September 4, 2007 at 10:02 am

    #731265

    No, I don't.

  • September 4, 2007 at 1:13 pm

    #731307

    Elma,

    What you posted is the information that's displayed in the job history.  You have to have enabled logging in the package to see the package log. 

    To enable logging, open the package in DTS Designer, select package properties, select the logging tab, and check the option to log package execution to SQL Server.  Provide the name of the instance where the package resides, click OK, and save the package. 

    The next time it runs, right-click on the package in Enterprise Manager and select Package Logs...

    Greg

    Greg

  • September 4, 2007 at 3:12 pm

    #731334

    Greg,

    I did all that you told me to do and started my job.

    Unbelievably, job finished with success!!!!! 

    Thanks a lot for your help, I really appreciate it,

    Elma

Viewing 9 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply