[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

DTS Package won't complete

Posted on 2006-05-19
16
Medium Priority
?
357 Views
Last Modified: 2013-11-30
I have a package that connects to a MainFrame using CA-Datacom ODBC.

When ran using SQL EM, the job runs fine and exits.

When ran as a job however, the package stay's locked on the job - but it does finish the entire set.
My job writes a date/time - then performs the ODBC transformation - then writes a date/time - then exits.

When ran as a job, this entire process completes - but the job doesn't exit and move on...  Several hours later will still say "Executing Step 1"

Anyone see something like this?

0
Comment
Question by:cory_booth
  • 9
  • 7
16 Comments
 
LVL 8

Expert Comment

by:H
ID: 16719068
Try right clicking on the job name and click refresh job...
0
 

Author Comment

by:cory_booth
ID: 16719075
Hah!

good one...  

Nope the job is truly hung and stuck in executing mode.

I can cancel the job...  but since it never finishes I don't get a job history report.
0
 
LVL 8

Expert Comment

by:H
ID: 16719102
Can you send me some more general details on the step that is hanging?
0
Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

 

Author Comment

by:cory_booth
ID: 16719156
OK

Heres the entire specs:

I have alot of DTS jobs.  But only four connect to a Mainframe using CA-Datacom ODBC drivers.

When logged in using SQL EM, I can run all my jobs by simply executing the package and they all run perfectly.

Each job starts by first writing a datetime stamp and then finishes by writing another datetime stamp.

A review the progress on the jobs online....

When I attempt to run my MainFrame DTS packages as a JOB (Start Job)
Then begin to execute...  They write the start datetime, they truncate my tables and import the new data from the MainFrame, they finish and write the finish datatime stamp.  But...  When going back to the SQL Server Agent and review the jobs, they still say Executing Job Step 1 - even though they are clearly finished.

As said before - this does not happen when runing the package seperatly - only when it is ran as a job...

0
 
LVL 8

Expert Comment

by:H
ID: 16719174
Also go into the DTS  package properties and click on the logging tab...Under Error handling give a path to a text file..and then check the two boxes below the path statement...

- fail package on first error
- write compeletion ststus to event log...

Then run it from sql agent..Look at the text file and the event viewer for errors..

Also in the past ive had to go as far as starting a db trace temprprily and then run the job and look for the issue...but this is only if its failing at a db level...
0
 
LVL 8

Expert Comment

by:H
ID: 16719202
Also from reading your last comment it may be an authentication issue.  Is it possible that the SQL agent job is running with slightly differnt authotity then when you manually execute the DTS package...I have this issue many times with scheduling jobs...
0
 

Author Comment

by:cory_booth
ID: 16719233
I'm using SQL Server 2000 - But I did engage the log file - will post after a "successful" job run.
0
 

Author Comment

by:cory_booth
ID: 16719245
Authentication:

Could be...  But...

As I said before, in the package the flow is completely finished - all the way to the very last SQL Update (which is done to the local server)
0
 

Author Comment

by:cory_booth
ID: 16719273
Heres the log:

DTSRun:  Loading...

DTSRun:  Executing...

DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_3

DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_3

DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_10

DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_10

DTSRun OnStart:  DTSStep_DTSDataPumpTask_10

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

DTSRun OnFinish:  DTSStep_DTSDataPumpTask_10

DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_7

DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_7

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; 22000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 22000

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

DTSRun OnFinish:  DTSStep_DTSDataPumpTask_3

DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_6

DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_6

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; 58476 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 58476

DTSRun OnFinish:  DTSStep_DTSDataPumpTask_4

DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_15

DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_15

DTSRun OnStart:  DTSStep_DTSDataPumpTask_5

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

DTSRun OnFinish:  DTSStep_DTSDataPumpTask_5

DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_13

DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_13

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; 53000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 53000

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

DTSRun OnFinish:  DTSStep_DTSDataPumpTask_6

DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_14

DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_14

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; 18374 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 18374

DTSRun OnFinish:  DTSStep_DTSDataPumpTask_7

DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_12

DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_12

DTSRun OnStart:  DTSStep_DTSDataPumpTask_8

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

DTSRun OnFinish:  DTSStep_DTSDataPumpTask_8

DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_11

DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_11

DTSRun OnStart:  DTSStep_DTSDataPumpTask_9

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 275000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 275000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 276000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 276000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 277000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 277000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 278000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 278000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 279000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 279000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 280000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 280000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 281000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 281000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 282000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 282000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 283000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 283000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 284000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 284000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 285000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 285000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 286000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 286000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 287000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 287000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 288000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 288000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 289000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 289000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 290000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 290000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 291000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 291000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 292000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 292000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 293000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 293000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 294000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 294000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 295000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 295000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 296000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 296000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 297000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 297000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 298000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 298000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 299000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 299000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 300000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 300000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 301000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 301000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 302000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 302000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 303000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 303000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 304000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 304000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 305000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 305000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 306000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 306000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 307000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 307000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 308000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 308000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 309000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 309000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 310000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 310000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 311000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 311000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 312000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 312000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 313000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 313000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 314000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 314000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 315000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 315000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 316000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 316000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 317000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 317000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 318000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 318000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 319000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 319000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 320000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 320000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 321000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 321000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 322000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 322000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 323000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 323000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 324000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 324000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 325000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 325000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 326000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 326000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 327000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 327000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 328000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 328000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 329000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 329000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 330000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 330000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 331000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 331000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 332000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 332000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 333000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 333000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 334000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 334000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 335000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 335000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 336000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 336000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 337000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 337000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 338000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 338000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 339000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 339000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 340000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 340000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 341000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 341000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 342000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 342000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 343000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 343000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 344000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 344000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 345000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 345000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 346000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 346000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 347000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 347000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 348000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 348000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 349000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 349000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 350000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 350000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 351000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 351000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 352000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 352000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 353000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 353000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 354000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 354000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 355000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 355000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 356000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 356000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 357000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 357000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 358000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 358000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 359000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 359000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 360000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 360000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 361000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 361000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 362000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 362000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 363000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 363000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 364000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 364000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 365000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 365000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 366000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 366000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 367000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 367000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 368000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 368000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 369000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 369000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 370000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 370000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 371000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 371000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 372000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 372000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 373000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 373000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 374000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 374000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 375000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 375000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 376000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 376000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 377000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 377000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 378000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 378000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 379000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 379000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 380000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 380000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 381000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 381000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 382000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 382000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 383000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 383000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 384000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 384000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 385000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 385000

DTSRun OnProgress:  DTSStep_DTSDataPumpTask_9; 386000 Rows have been trans
0
 
LVL 8

Expert Comment

by:H
ID: 16719377


<When you run it via the sql agent job sceduler it runs completely but doesnt show the job as complete when refreshing the job>

For some reason sql server agent is not able to confirm the step is actaully finished so the status never refreshs

Add a dummy step to the end of the DTS package that does a simple text file copy or something complete local...

Then run from sql agent again?

Just curious if this works....
0
 

Author Comment

by:cory_booth
ID: 16719402
I'll do that, but as I said before - the last step is a local database date/time stamp update query task...

I'll see if there is something more simple I can do
0
 
LVL 8

Expert Comment

by:H
ID: 16719457
yes I was only curious to find out if it actaully is your final step thats not returning proper completion to sql agent..  basically to point us in the right direction..
0
 

Author Comment

by:cory_booth
ID: 16719468
I added an Active X Task with no script entries
So it goes:

Write Start Date - Truncate Table - Transform Date - Write End Date - Active X
0
 

Author Comment

by:cory_booth
ID: 16719482
Job is finished (according to the data/time stamps) but still says it's executing...

What about these:

DTS Transform Properties (Copy Column)

No Lookups

FAST LOAD - ALWAYS COMMIT (only options checked)
0
 
LVL 8

Accepted Solution

by:
H earned 2000 total points
ID: 16719653
origianlly did you right clickeon the dts package and click schedule job to automatically create the job in sql agent jobs?


In sql agent right click on the job and click properties.  Go to the steps tab.  I assume that there is only one step there and its ID is step 1.  

on the general tab try changing the command to

dtsrun /Sserver_name /Uuser_nName /Ppassword /Npackage_name /Mpackage_password

modify that to meet ur system




0
 

Author Comment

by:cory_booth
ID: 16720107
Thanks for the help hollecar....
I was with my SQL Server Admin.  Found out that on the SQL Server a piece of the CA Datacom Driver was hanging.
The ODBC requires an additional translation layer that was not functioning on the SQL Server.

Working on it as we speak...

0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how the fundamental information of how to create a table.
Suggested Courses

873 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question