| 2017-04-09 19:26:28.0539914 -07:00 |
Child:Start, 19:26:28. |
Child.dtsx |
\Package |
None |
\Master\Execute Child Package\Child |
| 2017-04-09 19:26:26.6317150 -07:00 |
Master:Validation has started. |
Master.dtsx |
\Package |
None |
\Master |
| 2017-04-09 19:26:26.6317150 -07:00 |
Create Results Table:Validation has started. |
Master.dtsx |
\Package\Create Results Table |
None |
\Master\Create Results Table |
| 2017-04-09 19:26:26.6476728 -07:00 |
Create Results Table:Validation is complete. |
Master.dtsx |
\Package\Create Results Table |
None |
\Master\Create Results Table |
| 2017-04-09 19:26:26.6476728 -07:00 |
Drop Results Table:Validation has started. |
Master.dtsx |
\Package\Drop Results Table |
None |
\Master\Drop Results Table |
| 2017-04-09 19:26:26.6476728 -07:00 |
Drop Results Table:Validation is complete. |
Master.dtsx |
\Package\Drop Results Table |
None |
\Master\Drop Results Table |
| 2017-04-09 19:26:26.6476728 -07:00 |
Execute Child Package:Validation has started. |
Master.dtsx |
\Package\Execute Child Package |
None |
\Master\Execute Child Package |
| 2017-04-09 19:26:26.6476728 -07:00 |
Execute Child Package:Validation is complete. |
Master.dtsx |
\Package\Execute Child Package |
None |
\Master\Execute Child Package |
| 2017-04-09 19:26:26.6476728 -07:00 |
Handle Error:Validation has started. |
Master.dtsx |
\Package\Handle Error |
None |
\Master\Handle Error |
| 2017-04-09 19:26:26.6476728 -07:00 |
Handle Error:Validation is complete. |
Master.dtsx |
\Package\Handle Error |
None |
\Master\Handle Error |
| 2017-04-09 19:26:26.6476728 -07:00 |
Load Results:Validation has started. |
Master.dtsx |
\Package\Load Results |
None |
\Master\Load Results |
| 2017-04-09 19:26:26.6476728 -07:00 |
Do Stuff:Validation has started. |
Master.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Load Results\Do Stuff |
| 2017-04-09 19:26:26.6476728 -07:00 |
Do Stuff:Validation is complete. |
Master.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Load Results\Do Stuff |
| 2017-04-09 19:26:26.6476728 -07:00 |
SQL Task B:Validation has started. |
Master.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Load Results\SQL Task B |
| 2017-04-09 19:26:26.6476728 -07:00 |
SQL Task B:Validation is complete. |
Master.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Load Results\SQL Task B |
| 2017-04-09 19:26:26.6476728 -07:00 |
Load Results:Validation is complete. |
Master.dtsx |
\Package\Load Results |
None |
\Master\Load Results |
| 2017-04-09 19:26:26.6476728 -07:00 |
SayBye:Validation has started. |
Master.dtsx |
\Package\SayBye |
None |
\Master\SayBye |
| 2017-04-09 19:26:26.6476728 -07:00 |
Say Bye:Validation has started. |
Master.dtsx |
\Package\SayBye\Say Bye |
None |
\Master\SayBye\Say Bye |
| 2017-04-09 19:26:26.6476728 -07:00 |
Say Bye:Validation is complete. |
Master.dtsx |
\Package\SayBye\Say Bye |
None |
\Master\SayBye\Say Bye |
| 2017-04-09 19:26:26.6476728 -07:00 |
Say Bye Once More:Validation has started. |
Master.dtsx |
\Package\SayBye\Say Bye Once More |
None |
\Master\SayBye\Say Bye Once More |
| 2017-04-09 19:26:26.6476728 -07:00 |
Say Bye Once More:Validation is complete. |
Master.dtsx |
\Package\SayBye\Say Bye Once More |
None |
\Master\SayBye\Say Bye Once More |
| 2017-04-09 19:26:26.6476728 -07:00 |
SayBye:Validation is complete. |
Master.dtsx |
\Package\SayBye |
None |
\Master\SayBye |
| 2017-04-09 19:26:26.6476728 -07:00 |
SQL Task A:Validation has started. |
Master.dtsx |
\Package\SQL Task A |
None |
\Master\SQL Task A |
| 2017-04-09 19:26:26.6476728 -07:00 |
SQL Task A:Validation is complete. |
Master.dtsx |
\Package\SQL Task A |
None |
\Master\SQL Task A |
| 2017-04-09 19:26:26.6476728 -07:00 |
Write Message:Validation has started. |
Master.dtsx |
\Package\Write Message |
None |
\Master\Write Message |
| 2017-04-09 19:26:26.6476728 -07:00 |
Write Message:Validation is complete. |
Master.dtsx |
\Package\Write Message |
None |
\Master\Write Message |
| 2017-04-09 19:26:26.6476728 -07:00 |
Master:Validation is complete. |
Master.dtsx |
\Package |
None |
\Master |
| 2017-04-09 19:26:26.8040336 -07:00 |
Master:Start, 19:26:26. |
Master.dtsx |
\Package |
None |
\Master |
| 2017-04-09 19:26:26.8191809 -07:00 |
Create Results Table:Start, 19:26:26. |
Master.dtsx |
\Package\Create Results Table |
None |
\Master\Create Results Table |
| 2017-04-09 19:26:26.8191809 -07:00 |
Create Results Table:Validation has started. |
Master.dtsx |
\Package\Create Results Table |
None |
\Master\Create Results Table |
| 2017-04-09 19:26:26.8191809 -07:00 |
Create Results Table:Validation is complete. |
Master.dtsx |
\Package\Create Results Table |
None |
\Master\Create Results Table |
| 2017-04-09 19:26:26.9445933 -07:00 |
Create Results Table:Finished, 19:26:26, Elapsed time: 00:00:00.125. |
Master.dtsx |
\Package\Create Results Table |
None |
\Master\Create Results Table |
| 2017-04-09 19:26:26.9445933 -07:00 |
Write Message:Start, 19:26:26. |
Master.dtsx |
\Package\Write Message |
None |
\Master\Write Message |
| 2017-04-09 19:26:26.9445933 -07:00 |
Write Message:Validation has started. |
Master.dtsx |
\Package\Write Message |
None |
\Master\Write Message |
| 2017-04-09 19:26:26.9445933 -07:00 |
Write Message:Validation is complete. |
Master.dtsx |
\Package\Write Message |
None |
\Master\Write Message |
| 2017-04-09 19:26:26.8191809 -07:00 |
SQL Task A:Start, 19:26:26. |
Master.dtsx |
\Package\SQL Task A |
None |
\Master\SQL Task A |
| 2017-04-09 19:26:26.8191809 -07:00 |
SQL Task A:Validation has started. |
Master.dtsx |
\Package\SQL Task A |
None |
\Master\SQL Task A |
| 2017-04-09 19:26:26.8191809 -07:00 |
SQL Task A:Validation is complete. |
Master.dtsx |
\Package\SQL Task A |
None |
\Master\SQL Task A |
| 2017-04-09 19:26:27.9756641 -07:00 |
Write Message:Information: Hi there, this is Sample 1 |
Master.dtsx |
\Package\Write Message |
None |
\Master\Write Message |
| 2017-04-09 19:26:27.9756641 -07:00 |
Write Message:Finished, 19:26:27, Elapsed time: 00:00:01.031. |
Master.dtsx |
\Package\Write Message |
None |
\Master\Write Message |
| 2017-04-09 19:26:27.9756641 -07:00 |
Execute Child Package:Start, 19:26:27. |
Master.dtsx |
\Package\Execute Child Package |
None |
\Master\Execute Child Package |
| 2017-04-09 19:26:27.9756641 -07:00 |
Execute Child Package:Validation has started. |
Master.dtsx |
\Package\Execute Child Package |
None |
\Master\Execute Child Package |
| 2017-04-09 19:26:27.9756641 -07:00 |
Execute Child Package:Validation is complete. |
Master.dtsx |
\Package\Execute Child Package |
None |
\Master\Execute Child Package |
| 2017-04-09 19:26:28.0379643 -07:00 |
Child:Validation has started. |
Child.dtsx |
\Package |
None |
\Master\Execute Child Package\Child |
| 2017-04-09 19:26:28.0379643 -07:00 |
Call Grandchild:Validation has started. |
Child.dtsx |
\Package\Call Grandchild |
None |
\Master\Execute Child Package\Child\Call Grandchild |
| 2017-04-09 19:26:28.0379643 -07:00 |
Call Grandchild:Validation is complete. |
Child.dtsx |
\Package\Call Grandchild |
None |
\Master\Execute Child Package\Child\Call Grandchild |
| 2017-04-09 19:26:28.0379643 -07:00 |
Create Results Table:Validation has started. |
Child.dtsx |
\Package\Create Results Table |
None |
\Master\Execute Child Package\Child\Create Results Table |
| 2017-04-09 19:26:28.0379643 -07:00 |
Create Results Table:Validation is complete. |
Child.dtsx |
\Package\Create Results Table |
None |
\Master\Execute Child Package\Child\Create Results Table |
| 2017-04-09 19:26:28.0379643 -07:00 |
Load Results:Validation has started. |
Child.dtsx |
\Package\Load Results |
None |
\Master\Execute Child Package\Child\Load Results |
| 2017-04-09 19:26:28.0379643 -07:00 |
Do Stuff:Validation has started. |
Child.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Execute Child Package\Child\Load Results\Do Stuff |
| 2017-04-09 19:26:28.0379643 -07:00 |
Do Stuff:Validation is complete. |
Child.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Execute Child Package\Child\Load Results\Do Stuff |
| 2017-04-09 19:26:28.0379643 -07:00 |
SQL Task B:Validation has started. |
Child.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Execute Child Package\Child\Load Results\SQL Task B |
| 2017-04-09 19:26:28.0379643 -07:00 |
SQL Task B:Validation is complete. |
Child.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Execute Child Package\Child\Load Results\SQL Task B |
| 2017-04-09 19:26:28.0379643 -07:00 |
Load Results:Validation is complete. |
Child.dtsx |
\Package\Load Results |
None |
\Master\Execute Child Package\Child\Load Results |
| 2017-04-09 19:26:28.0379643 -07:00 |
Child:Validation is complete. |
Child.dtsx |
\Package |
None |
\Master\Execute Child Package\Child |
| 2017-04-09 19:26:28.0379643 -07:00 |
Child:Validation has started. |
Child.dtsx |
\Package |
None |
\Master\Execute Child Package\Child |
| 2017-04-09 19:26:28.0379643 -07:00 |
Call Grandchild:Validation has started. |
Child.dtsx |
\Package\Call Grandchild |
None |
\Master\Execute Child Package\Child\Call Grandchild |
| 2017-04-09 19:26:28.0379643 -07:00 |
Call Grandchild:Validation is complete. |
Child.dtsx |
\Package\Call Grandchild |
None |
\Master\Execute Child Package\Child\Call Grandchild |
| 2017-04-09 19:26:28.0539914 -07:00 |
Create Results Table:Start, 19:26:28. |
Child.dtsx |
\Package\Create Results Table |
None |
\Master\Execute Child Package\Child\Create Results Table |
| 2017-04-09 19:26:28.0539914 -07:00 |
Create Results Table:Validation has started. |
Child.dtsx |
\Package\Create Results Table |
None |
\Master\Execute Child Package\Child\Create Results Table |
| 2017-04-09 19:26:28.0539914 -07:00 |
Create Results Table:Validation is complete. |
Child.dtsx |
\Package\Create Results Table |
None |
\Master\Execute Child Package\Child\Create Results Table |
| 2017-04-09 19:26:28.0690937 -07:00 |
Create Results Table:Finished, 19:26:28, Elapsed time: 00:00:00.015. |
Child.dtsx |
\Package\Create Results Table |
None |
\Master\Execute Child Package\Child\Create Results Table |
| 2017-04-09 19:26:28.0690937 -07:00 |
Load Results:Start, 19:26:28. |
Child.dtsx |
\Package\Load Results |
None |
\Master\Execute Child Package\Child\Load Results |
| 2017-04-09 19:26:28.0690937 -07:00 |
Load Child Results Table:Start, 19:26:28. |
Child.dtsx |
\Package\Load Results\Load Child Results Table |
None |
\Master\Execute Child Package\Child\Load Results[1]\Load Child Results Table |
| 2017-04-09 19:26:28.0690937 -07:00 |
Load Child Results Table:Validation has started. |
Child.dtsx |
\Package\Load Results\Load Child Results Table |
None |
\Master\Execute Child Package\Child\Load Results[1]\Load Child Results Table |
| 2017-04-09 19:26:28.0690937 -07:00 |
Load Child Results Table:Information: Validation phase is beginning.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
SSIS.Pipeline |
\Master\Execute Child Package\Child\Load Results[1]\Load Child Results Table |
| 2017-04-09 19:26:28.2880431 -07:00 |
Load Child Results Table:Validation is complete. |
Child.dtsx |
\Package\Load Results\Load Child Results Table |
None |
\Master\Execute Child Package\Child\Load Results[1]\Load Child Results Table |
| 2017-04-09 19:26:28.2880431 -07:00 |
Load Child Results Table:Warning: Warning: Could not open global shared memory to communicate with performance DLL; data flow performance counters are not available. To resolve, run this package as an administrator, or on the system's console.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
SSIS.Pipeline |
\Master\Execute Child Package\Child\Load Results[1]\Load Child Results Table |
| 2017-04-09 19:26:28.3035162 -07:00 |
Load Child Results Table:Warning: The output column "my_id_a" (59) on output "Lookup Match Output" (58) and component "Lookup A" (40) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
SSIS.Pipeline |
\Master\Execute Child Package\Child\Load Results[1]\Load Child Results Table |
| 2017-04-09 19:26:28.3035162 -07:00 |
Load Child Results Table:Warning: The output column "my_id_b" (84) on output "Lookup Match Output" (83) and component "Lookup B" (65) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
SSIS.Pipeline |
\Master\Execute Child Package\Child\Load Results[1]\Load Child Results Table |
| 2017-04-09 19:26:28.3035162 -07:00 |
Load Child Results Table:Warning: The output column "my_id" (109) on output "Lookup Match Output" (108) and component "Lookup C" (90) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
SSIS.Pipeline |
\Master\Execute Child Package\Child\Load Results[1]\Load Child Results Table |
| 2017-04-09 19:26:28.3035162 -07:00 |
Load Child Results Table:Information: Prepare for Execute phase is beginning.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
SSIS.Pipeline |
\Master\Execute Child Package\Child\Load Results[1]\Load Child Results Table |
| 2017-04-09 19:26:28.3195020 -07:00 |
Load Child Results Table:Information: Pre-Execute phase is beginning.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
SSIS.Pipeline |
\Master\Execute Child Package\Child\Load Results[1]\Load Child Results Table |
| 2017-04-09 19:26:28.5539673 -07:00 |
Load Child Results Table:Information: Lookup C has cached 505 rows.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
Lookup C [90] |
\Master\Execute Child Package\Child\Load Results[1]\Load Child Results Table |
| 2017-04-09 19:26:28.5539673 -07:00 |
Load Child Results Table:Information: Lookup C has cached a total of 505 rows.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
Lookup C [90] |
\Master\Execute Child Package\Child\Load Results[1]\Load Child Results Table |
| 2017-04-09 19:26:28.5539673 -07:00 |
Load Child Results Table:Warning: The Lookup C encountered duplicate reference key values when caching reference data. This error occurs in Full Cache mode only. Either remove the duplicate key values, or change the cache mode to PARTIAL or NO_CACHE.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
Lookup C [90] |
\Master\Execute Child Package\Child\Load Results[1]\Load Child Results Table |
| 2017-04-09 19:26:28.5539673 -07:00 |
Load Child Results Table:Information: The number of unique rows added to the cache is 504.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
Lookup C [90] |
\Master\Execute Child Package\Child\Load Results[1]\Load Child Results Table |
| 2017-04-09 19:26:28.5539673 -07:00 |
Load Child Results Table:Information: The Lookup C processed 505 rows in the cache. The processing time was 0.219 seconds. The cache used 20200 bytes of memory.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
Lookup C [90] |
\Master\Execute Child Package\Child\Load Results[1]\Load Child Results Table |
| 2017-04-09 19:26:28.0690937 -07:00 |
Call Grandchild:Start, 19:26:28. |
Child.dtsx |
\Package\Call Grandchild |
None |
\Master\Execute Child Package\Child\Call Grandchild |
| 2017-04-09 19:26:28.0690937 -07:00 |
Call Grandchild:Validation has started. |
Child.dtsx |
\Package\Call Grandchild |
None |
\Master\Execute Child Package\Child\Call Grandchild |
| 2017-04-09 19:26:28.0690937 -07:00 |
Call Grandchild:Validation is complete. |
Child.dtsx |
\Package\Call Grandchild |
None |
\Master\Execute Child Package\Child\Call Grandchild |
| 2017-04-09 19:26:28.1003334 -07:00 |
Grandchild:Validation has started. |
Grandchild.dtsx |
\Package |
None |
\Master\Execute Child Package\Child\Call Grandchild\Grandchild |
| 2017-04-09 19:26:28.1003334 -07:00 |
Do Something:Validation has started. |
Grandchild.dtsx |
\Package\Do Something |
None |
\Master\Execute Child Package\Child\Call Grandchild\Grandchild\Do Something |
| 2017-04-09 19:26:28.1003334 -07:00 |
Do Something:Validation is complete. |
Grandchild.dtsx |
\Package\Do Something |
None |
\Master\Execute Child Package\Child\Call Grandchild\Grandchild\Do Something |
| 2017-04-09 19:26:28.1003334 -07:00 |
Play with Username:Validation has started. |
Grandchild.dtsx |
\Package\Play with Username |
None |
\Master\Execute Child Package\Child\Call Grandchild\Grandchild\Play with Username |
| 2017-04-09 19:26:28.1003334 -07:00 |
Play with Username:Validation is complete. |
Grandchild.dtsx |
\Package\Play with Username |
None |
\Master\Execute Child Package\Child\Call Grandchild\Grandchild\Play with Username |
| 2017-04-09 19:26:28.1003334 -07:00 |
Grandchild:Validation is complete. |
Grandchild.dtsx |
\Package |
None |
\Master\Execute Child Package\Child\Call Grandchild\Grandchild |
| 2017-04-09 19:26:28.1003334 -07:00 |
Grandchild:Validation has started. |
Grandchild.dtsx |
\Package |
None |
\Master\Execute Child Package\Child\Call Grandchild\Grandchild |
| 2017-04-09 19:26:28.1003334 -07:00 |
Do Something:Validation has started. |
Grandchild.dtsx |
\Package\Do Something |
None |
\Master\Execute Child Package\Child\Call Grandchild\Grandchild\Do Something |
| 2017-04-09 19:26:28.1003334 -07:00 |
Do Something:Validation is complete. |
Grandchild.dtsx |
\Package\Do Something |
None |
\Master\Execute Child Package\Child\Call Grandchild\Grandchild\Do Something |
| 2017-04-09 19:26:28.1003334 -07:00 |
Play with Username:Validation has started. |
Grandchild.dtsx |
\Package\Play with Username |
None |
\Master\Execute Child Package\Child\Call Grandchild\Grandchild\Play with Username |
| 2017-04-09 19:26:28.1003334 -07:00 |
Play with Username:Validation is complete. |
Grandchild.dtsx |
\Package\Play with Username |
None |
\Master\Execute Child Package\Child\Call Grandchild\Grandchild\Play with Username |
| 2017-04-09 19:26:28.1003334 -07:00 |
Grandchild:Validation is complete. |
Grandchild.dtsx |
\Package |
None |
\Master\Execute Child Package\Child\Call Grandchild\Grandchild |
| 2017-04-09 19:26:29.7880115 -07:00 |
SQL Task B:Start, 19:26:29. |
Child.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Execute Child Package\Child\Load Results[1]\SQL Task B |
| 2017-04-09 19:26:29.7880115 -07:00 |
SQL Task B:Validation has started. |
Child.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Execute Child Package\Child\Load Results[1]\SQL Task B |
| 2017-04-09 19:26:29.7880115 -07:00 |
SQL Task B:Validation is complete. |
Child.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Execute Child Package\Child\Load Results[1]\SQL Task B |
| 2017-04-09 19:26:28.1003334 -07:00 |
Grandchild:Start, 19:26:28. |
Grandchild.dtsx |
\Package |
None |
\Master\Execute Child Package\Child\Call Grandchild\Grandchild |
| 2017-04-09 19:26:28.0379643 -07:00 |
Create Results Table:Validation has started. |
Child.dtsx |
\Package\Create Results Table |
None |
\Master\Execute Child Package\Child\Create Results Table |
| 2017-04-09 19:26:28.0379643 -07:00 |
Create Results Table:Validation is complete. |
Child.dtsx |
\Package\Create Results Table |
None |
\Master\Execute Child Package\Child\Create Results Table |
| 2017-04-09 19:26:28.0379643 -07:00 |
Load Results:Validation has started. |
Child.dtsx |
\Package\Load Results |
None |
\Master\Execute Child Package\Child\Load Results |
| 2017-04-09 19:26:28.0379643 -07:00 |
Do Stuff:Validation has started. |
Child.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Execute Child Package\Child\Load Results\Do Stuff |
| 2017-04-09 19:26:28.0379643 -07:00 |
Do Stuff:Validation is complete. |
Child.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Execute Child Package\Child\Load Results\Do Stuff |
| 2017-04-09 19:26:28.0379643 -07:00 |
SQL Task B:Validation has started. |
Child.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Execute Child Package\Child\Load Results\SQL Task B |
| 2017-04-09 19:26:28.0379643 -07:00 |
SQL Task B:Validation is complete. |
Child.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Execute Child Package\Child\Load Results\SQL Task B |
| 2017-04-09 19:26:28.0379643 -07:00 |
Load Results:Validation is complete. |
Child.dtsx |
\Package\Load Results |
None |
\Master\Execute Child Package\Child\Load Results |
| 2017-04-09 19:26:28.0539914 -07:00 |
Child:Validation is complete. |
Child.dtsx |
\Package |
None |
\Master\Execute Child Package\Child |
| 2017-04-09 19:26:28.1003334 -07:00 |
Do Something:Start, 19:26:28. |
Grandchild.dtsx |
\Package\Do Something |
None |
\Master\Execute Child Package\Child\Call Grandchild\Grandchild\Do Something |
| 2017-04-09 19:26:28.1003334 -07:00 |
Do Something:Validation has started. |
Grandchild.dtsx |
\Package\Do Something |
None |
\Master\Execute Child Package\Child\Call Grandchild\Grandchild\Do Something |
| 2017-04-09 19:26:28.1003334 -07:00 |
Do Something:Validation is complete. |
Grandchild.dtsx |
\Package\Do Something |
None |
\Master\Execute Child Package\Child\Call Grandchild\Grandchild\Do Something |
| 2017-04-09 19:26:28.1318536 -07:00 |
Do Something:Finished, 19:26:28, Elapsed time: 00:00:00.032. |
Grandchild.dtsx |
\Package\Do Something |
None |
\Master\Execute Child Package\Child\Call Grandchild\Grandchild\Do Something |
| 2017-04-09 19:26:28.1318536 -07:00 |
Play with Username:Start, 19:26:28. |
Grandchild.dtsx |
\Package\Play with Username |
None |
\Master\Execute Child Package\Child\Call Grandchild\Grandchild\Play with Username |
| 2017-04-09 19:26:28.1318536 -07:00 |
Play with Username:Validation has started. |
Grandchild.dtsx |
\Package\Play with Username |
None |
\Master\Execute Child Package\Child\Call Grandchild\Grandchild\Play with Username |
| 2017-04-09 19:26:28.1318536 -07:00 |
Play with Username:Validation is complete. |
Grandchild.dtsx |
\Package\Play with Username |
None |
\Master\Execute Child Package\Child\Call Grandchild\Grandchild\Play with Username |
| 2017-04-09 19:26:28.1318536 -07:00 |
Play with Username:Information: Sending 'Davide' to sleep |
Grandchild.dtsx |
\Package\Play with Username |
None |
\Master\Execute Child Package\Child\Call Grandchild\Grandchild\Play with Username |
| 2017-04-09 19:26:28.9284833 -07:00 |
SQL Task A:Finished, 19:26:28, Elapsed time: 00:00:02.110. |
Master.dtsx |
\Package\SQL Task A |
None |
\Master\SQL Task A |
| 2017-04-09 19:26:29.7723482 -07:00 |
Load Child Results Table:Information: The final commit for the data insertion in "DST - Bad" has started.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
DST - Bad [2] |
\Master\Execute Child Package\Child\Load Results[1]\Load Child Results Table |
| 2017-04-09 19:26:29.7723482 -07:00 |
Load Child Results Table:Information: The final commit for the data insertion in "DST - Bad" has ended.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
DST - Bad [2] |
\Master\Execute Child Package\Child\Load Results[1]\Load Child Results Table |
| 2017-04-09 19:26:29.7723482 -07:00 |
Load Child Results Table:Information: The final commit for the data insertion in "DST - Good" has started.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
DST - Good [21] |
\Master\Execute Child Package\Child\Load Results[1]\Load Child Results Table |
| 2017-04-09 19:26:29.7723482 -07:00 |
Load Child Results Table:Information: The final commit for the data insertion in "DST - Good" has ended.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
DST - Good [21] |
\Master\Execute Child Package\Child\Load Results[1]\Load Child Results Table |
| 2017-04-09 19:26:29.2566765 -07:00 |
Load Child Results Table:Information: Lookup B has cached 55 rows.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
Lookup B [65] |
\Master\Execute Child Package\Child\Load Results[1]\Load Child Results Table |
| 2017-04-09 19:26:29.3817389 -07:00 |
Load Child Results Table:Information: Lookup B has cached a total of 55 rows.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
Lookup B [65] |
\Master\Execute Child Package\Child\Load Results[1]\Load Child Results Table |
| 2017-04-09 19:26:29.3817389 -07:00 |
Load Child Results Table:Warning: The Lookup B encountered duplicate reference key values when caching reference data. This error occurs in Full Cache mode only. Either remove the duplicate key values, or change the cache mode to PARTIAL or NO_CACHE.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
Lookup B [65] |
\Master\Execute Child Package\Child\Load Results[1]\Load Child Results Table |
| 2017-04-09 19:26:29.3973087 -07:00 |
Load Child Results Table:Information: The number of unique rows added to the cache is 54.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
Lookup B [65] |
\Master\Execute Child Package\Child\Load Results[1]\Load Child Results Table |
| 2017-04-09 19:26:29.3973087 -07:00 |
Load Child Results Table:Information: The Lookup B processed 55 rows in the cache. The processing time was 0.531 seconds. The cache used 2200 bytes of memory.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
Lookup B [65] |
\Master\Execute Child Package\Child\Load Results[1]\Load Child Results Table |
| 2017-04-09 19:26:29.6632315 -07:00 |
Load Child Results Table:Information: Lookup A has cached 1505 rows.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
Lookup A [40] |
\Master\Execute Child Package\Child\Load Results[1]\Load Child Results Table |
| 2017-04-09 19:26:29.6632315 -07:00 |
Load Child Results Table:Information: Lookup A has cached a total of 1505 rows.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
Lookup A [40] |
\Master\Execute Child Package\Child\Load Results[1]\Load Child Results Table |
| 2017-04-09 19:26:29.6632315 -07:00 |
Load Child Results Table:Warning: The Lookup A encountered duplicate reference key values when caching reference data. This error occurs in Full Cache mode only. Either remove the duplicate key values, or change the cache mode to PARTIAL or NO_CACHE.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
Lookup A [40] |
\Master\Execute Child Package\Child\Load Results[1]\Load Child Results Table |
| 2017-04-09 19:26:29.6632315 -07:00 |
Load Child Results Table:Information: The number of unique rows added to the cache is 1504.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
Lookup A [40] |
\Master\Execute Child Package\Child\Load Results[1]\Load Child Results Table |
| 2017-04-09 19:26:29.6632315 -07:00 |
Load Child Results Table:Information: The Lookup A processed 1505 rows in the cache. The processing time was 0.266 seconds. The cache used 60200 bytes of memory.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
Lookup A [40] |
\Master\Execute Child Package\Child\Load Results[1]\Load Child Results Table |
| 2017-04-09 19:26:29.7575744 -07:00 |
Load Child Results Table:Information: Execute phase is beginning.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
SSIS.Pipeline |
\Master\Execute Child Package\Child\Load Results[1]\Load Child Results Table |
| 2017-04-09 19:26:29.7723482 -07:00 |
Load Child Results Table:Information: Post Execute phase is beginning.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
SSIS.Pipeline |
\Master\Execute Child Package\Child\Load Results[1]\Load Child Results Table |
| 2017-04-09 19:26:29.7880115 -07:00 |
Load Child Results Table:Information: "DST - Bad" wrote 312 rows.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
SSIS.Pipeline |
\Master\Execute Child Package\Child\Load Results[1]\Load Child Results Table |
| 2017-04-09 19:26:29.7880115 -07:00 |
Load Child Results Table:Information: "DST - Good" wrote 89 rows.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
SSIS.Pipeline |
\Master\Execute Child Package\Child\Load Results[1]\Load Child Results Table |
| 2017-04-09 19:26:29.7880115 -07:00 |
Load Child Results Table:Information: Cleanup phase is beginning.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
SSIS.Pipeline |
\Master\Execute Child Package\Child\Load Results[1]\Load Child Results Table |
| 2017-04-09 19:26:29.7880115 -07:00 |
Load Child Results Table:Finished, 19:26:29, Elapsed time: 00:00:01.719. |
Child.dtsx |
\Package\Load Results\Load Child Results Table |
None |
\Master\Execute Child Package\Child\Load Results[1]\Load Child Results Table |
| 2017-04-09 19:26:29.7880115 -07:00 |
Do Stuff:Start, 19:26:29. |
Child.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Execute Child Package\Child\Load Results[1]\Do Stuff |
| 2017-04-09 19:26:29.7880115 -07:00 |
Do Stuff:Validation has started. |
Child.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Execute Child Package\Child\Load Results[1]\Do Stuff |
| 2017-04-09 19:26:29.7880115 -07:00 |
Do Stuff:Validation is complete. |
Child.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Execute Child Package\Child\Load Results[1]\Do Stuff |
| 2017-04-09 19:26:29.8034832 -07:00 |
Do Stuff:Information: Will I raise an Exception? False |
Child.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Execute Child Package\Child\Load Results[1]\Do Stuff |
| 2017-04-09 19:26:30.8034790 -07:00 |
SQL Task B:Finished, 19:26:30, Elapsed time: 00:00:01.016. |
Child.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Execute Child Package\Child\Load Results[1]\SQL Task B |
| 2017-04-09 19:26:30.8034790 -07:00 |
Load Child Results Table:Start, 19:26:30. |
Child.dtsx |
\Package\Load Results\Load Child Results Table |
None |
\Master\Execute Child Package\Child\Load Results[2]\Load Child Results Table |
| 2017-04-09 19:26:30.8034790 -07:00 |
Load Child Results Table:Validation has started. |
Child.dtsx |
\Package\Load Results\Load Child Results Table |
None |
\Master\Execute Child Package\Child\Load Results[2]\Load Child Results Table |
| 2017-04-09 19:26:30.8034790 -07:00 |
Load Child Results Table:Information: Validation phase is beginning.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
SSIS.Pipeline |
\Master\Execute Child Package\Child\Load Results[2]\Load Child Results Table |
| 2017-04-09 19:26:31.0070875 -07:00 |
Load Child Results Table:Validation is complete. |
Child.dtsx |
\Package\Load Results\Load Child Results Table |
None |
\Master\Execute Child Package\Child\Load Results[2]\Load Child Results Table |
| 2017-04-09 19:26:31.0070875 -07:00 |
Load Child Results Table:Warning: The output column "my_id_a" (59) on output "Lookup Match Output" (58) and component "Lookup A" (40) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
SSIS.Pipeline |
\Master\Execute Child Package\Child\Load Results[2]\Load Child Results Table |
| 2017-04-09 19:26:31.0070875 -07:00 |
Load Child Results Table:Warning: The output column "my_id_b" (84) on output "Lookup Match Output" (83) and component "Lookup B" (65) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
SSIS.Pipeline |
\Master\Execute Child Package\Child\Load Results[2]\Load Child Results Table |
| 2017-04-09 19:26:31.0070875 -07:00 |
Load Child Results Table:Warning: The output column "my_id" (109) on output "Lookup Match Output" (108) and component "Lookup C" (90) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
SSIS.Pipeline |
\Master\Execute Child Package\Child\Load Results[2]\Load Child Results Table |
| 2017-04-09 19:26:31.0070875 -07:00 |
Load Child Results Table:Information: Prepare for Execute phase is beginning.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
SSIS.Pipeline |
\Master\Execute Child Package\Child\Load Results[2]\Load Child Results Table |
| 2017-04-09 19:26:31.0380294 -07:00 |
Load Child Results Table:Information: Pre-Execute phase is beginning.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
SSIS.Pipeline |
\Master\Execute Child Package\Child\Load Results[2]\Load Child Results Table |
| 2017-04-09 19:26:31.2725710 -07:00 |
Load Child Results Table:Information: Lookup C has cached a total of 505 rows.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
Lookup C [90] |
\Master\Execute Child Package\Child\Load Results[2]\Load Child Results Table |
| 2017-04-09 19:26:31.2725710 -07:00 |
Load Child Results Table:Warning: The Lookup C encountered duplicate reference key values when caching reference data. This error occurs in Full Cache mode only. Either remove the duplicate key values, or change the cache mode to PARTIAL or NO_CACHE.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
Lookup C [90] |
\Master\Execute Child Package\Child\Load Results[2]\Load Child Results Table |
| 2017-04-09 19:26:31.2725710 -07:00 |
Load Child Results Table:Information: The number of unique rows added to the cache is 504.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
Lookup C [90] |
\Master\Execute Child Package\Child\Load Results[2]\Load Child Results Table |
| 2017-04-09 19:26:31.2725710 -07:00 |
Load Child Results Table:Information: The Lookup C processed 505 rows in the cache. The processing time was 0.218 seconds. The cache used 20200 bytes of memory.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
Lookup C [90] |
\Master\Execute Child Package\Child\Load Results[2]\Load Child Results Table |
| 2017-04-09 19:26:29.8034832 -07:00 |
Do Stuff:Finished, 19:26:29, Elapsed time: 00:00:00.016. |
Child.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Execute Child Package\Child\Load Results[1]\Do Stuff |
| 2017-04-09 19:26:32.1942925 -07:00 |
Load Child Results Table:Information: Lookup B has cached a total of 55 rows.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
Lookup B [65] |
\Master\Execute Child Package\Child\Load Results[2]\Load Child Results Table |
| 2017-04-09 19:26:32.1942925 -07:00 |
Load Child Results Table:Warning: The Lookup B encountered duplicate reference key values when caching reference data. This error occurs in Full Cache mode only. Either remove the duplicate key values, or change the cache mode to PARTIAL or NO_CACHE.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
Lookup B [65] |
\Master\Execute Child Package\Child\Load Results[2]\Load Child Results Table |
| 2017-04-09 19:26:32.2097716 -07:00 |
Load Child Results Table:Information: The number of unique rows added to the cache is 54.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
Lookup B [65] |
\Master\Execute Child Package\Child\Load Results[2]\Load Child Results Table |
| 2017-04-09 19:26:32.2097716 -07:00 |
Load Child Results Table:Information: The Lookup B processed 55 rows in the cache. The processing time was 0.328 seconds. The cache used 2200 bytes of memory.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
Lookup B [65] |
\Master\Execute Child Package\Child\Load Results[2]\Load Child Results Table |
| 2017-04-09 19:26:32.3035516 -07:00 |
Load Child Results Table:Information: Lookup A has cached a total of 1505 rows.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
Lookup A [40] |
\Master\Execute Child Package\Child\Load Results[2]\Load Child Results Table |
| 2017-04-09 19:26:32.3035516 -07:00 |
Load Child Results Table:Warning: The Lookup A encountered duplicate reference key values when caching reference data. This error occurs in Full Cache mode only. Either remove the duplicate key values, or change the cache mode to PARTIAL or NO_CACHE.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
Lookup A [40] |
\Master\Execute Child Package\Child\Load Results[2]\Load Child Results Table |
| 2017-04-09 19:26:32.3035516 -07:00 |
Load Child Results Table:Information: The number of unique rows added to the cache is 1504.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
Lookup A [40] |
\Master\Execute Child Package\Child\Load Results[2]\Load Child Results Table |
| 2017-04-09 19:26:32.3035516 -07:00 |
Load Child Results Table:Information: The Lookup A processed 1505 rows in the cache. The processing time was 0.094 seconds. The cache used 60200 bytes of memory.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
Lookup A [40] |
\Master\Execute Child Package\Child\Load Results[2]\Load Child Results Table |
| 2017-04-09 19:26:32.3355100 -07:00 |
Load Child Results Table:Information: Execute phase is beginning.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
SSIS.Pipeline |
\Master\Execute Child Package\Child\Load Results[2]\Load Child Results Table |
| 2017-04-09 19:26:32.3504778 -07:00 |
Load Child Results Table:Information: Post Execute phase is beginning.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
SSIS.Pipeline |
\Master\Execute Child Package\Child\Load Results[2]\Load Child Results Table |
| 2017-04-09 19:26:32.3664450 -07:00 |
Load Child Results Table:Information: "DST - Bad" wrote 1451 rows.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
SSIS.Pipeline |
\Master\Execute Child Package\Child\Load Results[2]\Load Child Results Table |
| 2017-04-09 19:26:32.3664450 -07:00 |
Load Child Results Table:Information: "DST - Good" wrote 415 rows.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
SSIS.Pipeline |
\Master\Execute Child Package\Child\Load Results[2]\Load Child Results Table |
| 2017-04-09 19:26:32.3664450 -07:00 |
Load Child Results Table:Information: Cleanup phase is beginning.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
SSIS.Pipeline |
\Master\Execute Child Package\Child\Load Results[2]\Load Child Results Table |
| 2017-04-09 19:26:32.3664450 -07:00 |
Load Child Results Table:Finished, 19:26:32, Elapsed time: 00:00:01.562. |
Child.dtsx |
\Package\Load Results\Load Child Results Table |
None |
\Master\Execute Child Package\Child\Load Results[2]\Load Child Results Table |
| 2017-04-09 19:26:32.3504778 -07:00 |
Load Child Results Table:Information: The final commit for the data insertion in "DST - Good" has started.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
DST - Good [21] |
\Master\Execute Child Package\Child\Load Results[2]\Load Child Results Table |
| 2017-04-09 19:26:32.3504778 -07:00 |
Load Child Results Table:Information: The final commit for the data insertion in "DST - Good" has ended.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
DST - Good [21] |
\Master\Execute Child Package\Child\Load Results[2]\Load Child Results Table |
| 2017-04-09 19:26:32.3664450 -07:00 |
Do Stuff:Start, 19:26:32. |
Child.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Execute Child Package\Child\Load Results[2]\Do Stuff |
| 2017-04-09 19:26:32.3664450 -07:00 |
Do Stuff:Validation has started. |
Child.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Execute Child Package\Child\Load Results[2]\Do Stuff |
| 2017-04-09 19:26:32.3664450 -07:00 |
Do Stuff:Validation is complete. |
Child.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Execute Child Package\Child\Load Results[2]\Do Stuff |
| 2017-04-09 19:26:32.3664450 -07:00 |
Do Stuff:Information: Will I raise an Exception? False |
Child.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Execute Child Package\Child\Load Results[2]\Do Stuff |
| 2017-04-09 19:26:32.3664450 -07:00 |
Do Stuff:Finished, 19:26:32, Elapsed time: 00:00:00.000. |
Child.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Execute Child Package\Child\Load Results[2]\Do Stuff |
| 2017-04-09 19:26:32.3664450 -07:00 |
SQL Task B:Start, 19:26:32. |
Child.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Execute Child Package\Child\Load Results[2]\SQL Task B |
| 2017-04-09 19:26:32.3664450 -07:00 |
SQL Task B:Validation has started. |
Child.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Execute Child Package\Child\Load Results[2]\SQL Task B |
| 2017-04-09 19:26:32.3664450 -07:00 |
SQL Task B:Validation is complete. |
Child.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Execute Child Package\Child\Load Results[2]\SQL Task B |
| 2017-04-09 19:26:32.3504778 -07:00 |
Load Child Results Table:Information: The final commit for the data insertion in "DST - Bad" has started.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
DST - Bad [2] |
\Master\Execute Child Package\Child\Load Results[2]\Load Child Results Table |
| 2017-04-09 19:26:32.3504778 -07:00 |
Load Child Results Table:Information: The final commit for the data insertion in "DST - Bad" has ended.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
DST - Bad [2] |
\Master\Execute Child Package\Child\Load Results[2]\Load Child Results Table |
| 2017-04-09 19:26:33.1638298 -07:00 |
Call Grandchild:Finished, 19:26:33, Elapsed time: 00:00:05.094. |
Child.dtsx |
\Package\Call Grandchild |
None |
\Master\Execute Child Package\Child\Call Grandchild |
| 2017-04-09 19:26:33.1478877 -07:00 |
Grandchild:Finished, 19:26:33, Elapsed time: 00:00:05.047. |
Grandchild.dtsx |
\Package |
None |
\Master\Execute Child Package\Child\Call Grandchild\Grandchild |
| 2017-04-09 19:26:33.1478877 -07:00 |
Play with Username:Information: Done |
Grandchild.dtsx |
\Package\Play with Username |
None |
\Master\Execute Child Package\Child\Call Grandchild\Grandchild\Play with Username |
| 2017-04-09 19:26:33.1478877 -07:00 |
Play with Username:Finished, 19:26:33, Elapsed time: 00:00:05.015. |
Grandchild.dtsx |
\Package\Play with Username |
None |
\Master\Execute Child Package\Child\Call Grandchild\Grandchild\Play with Username |
| 2017-04-09 19:26:34.3978912 -07:00 |
Load Child Results Table:Start, 19:26:34. |
Child.dtsx |
\Package\Load Results\Load Child Results Table |
None |
\Master\Execute Child Package\Child\Load Results[3]\Load Child Results Table |
| 2017-04-09 19:26:34.3978912 -07:00 |
Load Child Results Table:Validation has started. |
Child.dtsx |
\Package\Load Results\Load Child Results Table |
None |
\Master\Execute Child Package\Child\Load Results[3]\Load Child Results Table |
| 2017-04-09 19:26:34.3978912 -07:00 |
Load Child Results Table:Information: Validation phase is beginning.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
SSIS.Pipeline |
\Master\Execute Child Package\Child\Load Results[3]\Load Child Results Table |
| 2017-04-09 19:26:34.4910124 -07:00 |
Load Child Results Table:Validation is complete. |
Child.dtsx |
\Package\Load Results\Load Child Results Table |
None |
\Master\Execute Child Package\Child\Load Results[3]\Load Child Results Table |
| 2017-04-09 19:26:34.4910124 -07:00 |
Load Child Results Table:Warning: The output column "my_id_a" (59) on output "Lookup Match Output" (58) and component "Lookup A" (40) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
SSIS.Pipeline |
\Master\Execute Child Package\Child\Load Results[3]\Load Child Results Table |
| 2017-04-09 19:27:57.1976692 -07:00 |
Do Stuff:Start, 19:27:57. |
Master.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Load Results[4]\Do Stuff |
| 2017-04-09 19:27:57.1976692 -07:00 |
Do Stuff:Validation has started. |
Master.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Load Results[4]\Do Stuff |
| 2017-04-09 19:26:34.5066130 -07:00 |
Load Child Results Table:Warning: The output column "my_id_b" (84) on output "Lookup Match Output" (83) and component "Lookup B" (65) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
SSIS.Pipeline |
\Master\Execute Child Package\Child\Load Results[3]\Load Child Results Table |
| 2017-04-09 19:26:34.5066130 -07:00 |
Load Child Results Table:Warning: The output column "my_id" (109) on output "Lookup Match Output" (108) and component "Lookup C" (90) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
SSIS.Pipeline |
\Master\Execute Child Package\Child\Load Results[3]\Load Child Results Table |
| 2017-04-09 19:26:34.5066130 -07:00 |
Load Child Results Table:Information: Prepare for Execute phase is beginning.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
SSIS.Pipeline |
\Master\Execute Child Package\Child\Load Results[3]\Load Child Results Table |
| 2017-04-09 19:26:34.5378517 -07:00 |
Load Child Results Table:Information: Pre-Execute phase is beginning.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
SSIS.Pipeline |
\Master\Execute Child Package\Child\Load Results[3]\Load Child Results Table |
| 2017-04-09 19:26:34.5535127 -07:00 |
Load Child Results Table:Information: Lookup C has cached 505 rows.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
Lookup C [90] |
\Master\Execute Child Package\Child\Load Results[3]\Load Child Results Table |
| 2017-04-09 19:26:34.5535127 -07:00 |
Load Child Results Table:Information: Lookup C has cached a total of 505 rows.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
Lookup C [90] |
\Master\Execute Child Package\Child\Load Results[3]\Load Child Results Table |
| 2017-04-09 19:26:34.5535127 -07:00 |
Load Child Results Table:Warning: The Lookup C encountered duplicate reference key values when caching reference data. This error occurs in Full Cache mode only. Either remove the duplicate key values, or change the cache mode to PARTIAL or NO_CACHE.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
Lookup C [90] |
\Master\Execute Child Package\Child\Load Results[3]\Load Child Results Table |
| 2017-04-09 19:26:34.5535127 -07:00 |
Load Child Results Table:Information: The number of unique rows added to the cache is 504.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
Lookup C [90] |
\Master\Execute Child Package\Child\Load Results[3]\Load Child Results Table |
| 2017-04-09 19:26:34.5535127 -07:00 |
Load Child Results Table:Information: The Lookup C processed 505 rows in the cache. The processing time was 0.016 seconds. The cache used 20200 bytes of memory.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
Lookup C [90] |
\Master\Execute Child Package\Child\Load Results[3]\Load Child Results Table |
| 2017-04-09 19:26:34.3978912 -07:00 |
SQL Task B:Finished, 19:26:34, Elapsed time: 00:00:02.031. |
Child.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Execute Child Package\Child\Load Results[2]\SQL Task B |
| 2017-04-09 19:26:34.6474095 -07:00 |
Load Child Results Table:Information: Lookup B has cached 55 rows.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
Lookup B [65] |
\Master\Execute Child Package\Child\Load Results[3]\Load Child Results Table |
| 2017-04-09 19:26:34.6474095 -07:00 |
Load Child Results Table:Information: Lookup B has cached a total of 55 rows.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
Lookup B [65] |
\Master\Execute Child Package\Child\Load Results[3]\Load Child Results Table |
| 2017-04-09 19:26:34.6474095 -07:00 |
Load Child Results Table:Warning: The Lookup B encountered duplicate reference key values when caching reference data. This error occurs in Full Cache mode only. Either remove the duplicate key values, or change the cache mode to PARTIAL or NO_CACHE.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
Lookup B [65] |
\Master\Execute Child Package\Child\Load Results[3]\Load Child Results Table |
| 2017-04-09 19:26:34.6474095 -07:00 |
Load Child Results Table:Information: The number of unique rows added to the cache is 54.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
Lookup B [65] |
\Master\Execute Child Package\Child\Load Results[3]\Load Child Results Table |
| 2017-04-09 19:26:34.6474095 -07:00 |
Load Child Results Table:Information: The Lookup B processed 55 rows in the cache. The processing time was 0.031 seconds. The cache used 2200 bytes of memory.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
Lookup B [65] |
\Master\Execute Child Package\Child\Load Results[3]\Load Child Results Table |
| 2017-04-09 19:26:34.6793489 -07:00 |
Load Child Results Table:Information: Lookup A has cached 1505 rows.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
Lookup A [40] |
\Master\Execute Child Package\Child\Load Results[3]\Load Child Results Table |
| 2017-04-09 19:26:34.6793489 -07:00 |
Load Child Results Table:Information: Lookup A has cached a total of 1505 rows.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
Lookup A [40] |
\Master\Execute Child Package\Child\Load Results[3]\Load Child Results Table |
| 2017-04-09 19:26:34.6793489 -07:00 |
Load Child Results Table:Warning: The Lookup A encountered duplicate reference key values when caching reference data. This error occurs in Full Cache mode only. Either remove the duplicate key values, or change the cache mode to PARTIAL or NO_CACHE.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
Lookup A [40] |
\Master\Execute Child Package\Child\Load Results[3]\Load Child Results Table |
| 2017-04-09 19:26:34.6793489 -07:00 |
Load Child Results Table:Information: The number of unique rows added to the cache is 1504.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
Lookup A [40] |
\Master\Execute Child Package\Child\Load Results[3]\Load Child Results Table |
| 2017-04-09 19:26:34.6793489 -07:00 |
Load Child Results Table:Information: The Lookup A processed 1505 rows in the cache. The processing time was 0.032 seconds. The cache used 60200 bytes of memory.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
Lookup A [40] |
\Master\Execute Child Package\Child\Load Results[3]\Load Child Results Table |
| 2017-04-09 19:26:34.6942213 -07:00 |
Load Child Results Table:Information: Execute phase is beginning.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
SSIS.Pipeline |
\Master\Execute Child Package\Child\Load Results[3]\Load Child Results Table |
| 2017-04-09 19:26:34.7150191 -07:00 |
Load Child Results Table:Information: Post Execute phase is beginning.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
SSIS.Pipeline |
\Master\Execute Child Package\Child\Load Results[3]\Load Child Results Table |
| 2017-04-09 19:26:34.7256820 -07:00 |
Load Child Results Table:Information: "DST - Bad" wrote 1287 rows.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
SSIS.Pipeline |
\Master\Execute Child Package\Child\Load Results[3]\Load Child Results Table |
| 2017-04-09 19:26:34.7256820 -07:00 |
Load Child Results Table:Information: "DST - Good" wrote 357 rows.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
SSIS.Pipeline |
\Master\Execute Child Package\Child\Load Results[3]\Load Child Results Table |
| 2017-04-09 19:26:34.7256820 -07:00 |
Load Child Results Table:Information: Cleanup phase is beginning.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
SSIS.Pipeline |
\Master\Execute Child Package\Child\Load Results[3]\Load Child Results Table |
| 2017-04-09 19:26:34.7256820 -07:00 |
Load Child Results Table:Finished, 19:26:34, Elapsed time: 00:00:00.328. |
Child.dtsx |
\Package\Load Results\Load Child Results Table |
None |
\Master\Execute Child Package\Child\Load Results[3]\Load Child Results Table |
| 2017-04-09 19:26:34.7256820 -07:00 |
Do Stuff:Start, 19:26:34. |
Child.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Execute Child Package\Child\Load Results[3]\Do Stuff |
| 2017-04-09 19:26:34.7256820 -07:00 |
Do Stuff:Validation has started. |
Child.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Execute Child Package\Child\Load Results[3]\Do Stuff |
| 2017-04-09 19:26:34.7256820 -07:00 |
Do Stuff:Validation is complete. |
Child.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Execute Child Package\Child\Load Results[3]\Do Stuff |
| 2017-04-09 19:26:34.7256820 -07:00 |
Do Stuff:Information: Will I raise an Exception? False |
Child.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Execute Child Package\Child\Load Results[3]\Do Stuff |
| 2017-04-09 19:26:34.7256820 -07:00 |
Do Stuff:Finished, 19:26:34, Elapsed time: 00:00:00.000. |
Child.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Execute Child Package\Child\Load Results[3]\Do Stuff |
| 2017-04-09 19:26:34.7256820 -07:00 |
SQL Task B:Start, 19:26:34. |
Child.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Execute Child Package\Child\Load Results[3]\SQL Task B |
| 2017-04-09 19:26:34.7256820 -07:00 |
SQL Task B:Validation has started. |
Child.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Execute Child Package\Child\Load Results[3]\SQL Task B |
| 2017-04-09 19:26:34.7256820 -07:00 |
SQL Task B:Validation is complete. |
Child.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Execute Child Package\Child\Load Results[3]\SQL Task B |
| 2017-04-09 19:26:34.7150191 -07:00 |
Load Child Results Table:Information: The final commit for the data insertion in "DST - Bad" has started.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
DST - Bad [2] |
\Master\Execute Child Package\Child\Load Results[3]\Load Child Results Table |
| 2017-04-09 19:26:34.7150191 -07:00 |
Load Child Results Table:Information: The final commit for the data insertion in "DST - Bad" has ended.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
DST - Bad [2] |
\Master\Execute Child Package\Child\Load Results[3]\Load Child Results Table |
| 2017-04-09 19:26:34.7150191 -07:00 |
Load Child Results Table:Information: The final commit for the data insertion in "DST - Good" has started.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
DST - Good [21] |
\Master\Execute Child Package\Child\Load Results[3]\Load Child Results Table |
| 2017-04-09 19:26:34.7150191 -07:00 |
Load Child Results Table:Information: The final commit for the data insertion in "DST - Good" has ended.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
DST - Good [21] |
\Master\Execute Child Package\Child\Load Results[3]\Load Child Results Table |
| 2017-04-09 19:26:37.7572520 -07:00 |
Load Child Results Table:Start, 19:26:37. |
Child.dtsx |
\Package\Load Results\Load Child Results Table |
None |
\Master\Execute Child Package\Child\Load Results[4]\Load Child Results Table |
| 2017-04-09 19:26:37.7572520 -07:00 |
Load Child Results Table:Validation has started. |
Child.dtsx |
\Package\Load Results\Load Child Results Table |
None |
\Master\Execute Child Package\Child\Load Results[4]\Load Child Results Table |
| 2017-04-09 19:26:37.7572520 -07:00 |
Load Child Results Table:Information: Validation phase is beginning.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
SSIS.Pipeline |
\Master\Execute Child Package\Child\Load Results[4]\Load Child Results Table |
| 2017-04-09 19:26:37.8509826 -07:00 |
Load Child Results Table:Validation is complete. |
Child.dtsx |
\Package\Load Results\Load Child Results Table |
None |
\Master\Execute Child Package\Child\Load Results[4]\Load Child Results Table |
| 2017-04-09 19:26:37.8509826 -07:00 |
Load Child Results Table:Warning: The output column "my_id_a" (59) on output "Lookup Match Output" (58) and component "Lookup A" (40) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
SSIS.Pipeline |
\Master\Execute Child Package\Child\Load Results[4]\Load Child Results Table |
| 2017-04-09 19:26:37.8509826 -07:00 |
Load Child Results Table:Warning: The output column "my_id_b" (84) on output "Lookup Match Output" (83) and component "Lookup B" (65) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
SSIS.Pipeline |
\Master\Execute Child Package\Child\Load Results[4]\Load Child Results Table |
| 2017-04-09 19:26:37.8509826 -07:00 |
Load Child Results Table:Warning: The output column "my_id" (109) on output "Lookup Match Output" (108) and component "Lookup C" (90) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
SSIS.Pipeline |
\Master\Execute Child Package\Child\Load Results[4]\Load Child Results Table |
| 2017-04-09 19:26:37.8509826 -07:00 |
Load Child Results Table:Information: Prepare for Execute phase is beginning.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
SSIS.Pipeline |
\Master\Execute Child Package\Child\Load Results[4]\Load Child Results Table |
| 2017-04-09 19:26:37.8817003 -07:00 |
Load Child Results Table:Information: Pre-Execute phase is beginning.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
SSIS.Pipeline |
\Master\Execute Child Package\Child\Load Results[4]\Load Child Results Table |
| 2017-04-09 19:26:37.8973897 -07:00 |
Load Child Results Table:Information: Lookup C has cached a total of 505 rows.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
Lookup C [90] |
\Master\Execute Child Package\Child\Load Results[4]\Load Child Results Table |
| 2017-04-09 19:26:37.8973897 -07:00 |
Load Child Results Table:Warning: The Lookup C encountered duplicate reference key values when caching reference data. This error occurs in Full Cache mode only. Either remove the duplicate key values, or change the cache mode to PARTIAL or NO_CACHE.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
Lookup C [90] |
\Master\Execute Child Package\Child\Load Results[4]\Load Child Results Table |
| 2017-04-09 19:26:37.8973897 -07:00 |
Load Child Results Table:Information: The number of unique rows added to the cache is 504.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
Lookup C [90] |
\Master\Execute Child Package\Child\Load Results[4]\Load Child Results Table |
| 2017-04-09 19:26:37.8973897 -07:00 |
Load Child Results Table:Information: The Lookup C processed 505 rows in the cache. The processing time was 0.001 seconds. The cache used 20200 bytes of memory.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
Lookup C [90] |
\Master\Execute Child Package\Child\Load Results[4]\Load Child Results Table |
| 2017-04-09 19:26:37.9447259 -07:00 |
Load Child Results Table:Information: Lookup B has cached a total of 55 rows.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
Lookup B [65] |
\Master\Execute Child Package\Child\Load Results[4]\Load Child Results Table |
| 2017-04-09 19:26:37.9447259 -07:00 |
Load Child Results Table:Warning: The Lookup B encountered duplicate reference key values when caching reference data. This error occurs in Full Cache mode only. Either remove the duplicate key values, or change the cache mode to PARTIAL or NO_CACHE.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
Lookup B [65] |
\Master\Execute Child Package\Child\Load Results[4]\Load Child Results Table |
| 2017-04-09 19:26:37.9447259 -07:00 |
Load Child Results Table:Information: The number of unique rows added to the cache is 54.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
Lookup B [65] |
\Master\Execute Child Package\Child\Load Results[4]\Load Child Results Table |
| 2017-04-09 19:26:37.9447259 -07:00 |
Load Child Results Table:Information: The Lookup B processed 55 rows in the cache. The processing time was 0.015 seconds. The cache used 2200 bytes of memory.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
Lookup B [65] |
\Master\Execute Child Package\Child\Load Results[4]\Load Child Results Table |
| 2017-04-09 19:26:37.9597695 -07:00 |
Load Child Results Table:Information: Lookup A has cached a total of 1505 rows.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
Lookup A [40] |
\Master\Execute Child Package\Child\Load Results[4]\Load Child Results Table |
| 2017-04-09 19:26:37.9597695 -07:00 |
Load Child Results Table:Warning: The Lookup A encountered duplicate reference key values when caching reference data. This error occurs in Full Cache mode only. Either remove the duplicate key values, or change the cache mode to PARTIAL or NO_CACHE.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
Lookup A [40] |
\Master\Execute Child Package\Child\Load Results[4]\Load Child Results Table |
| 2017-04-09 19:26:37.9597695 -07:00 |
Load Child Results Table:Information: The number of unique rows added to the cache is 1504.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
Lookup A [40] |
\Master\Execute Child Package\Child\Load Results[4]\Load Child Results Table |
| 2017-04-09 19:26:37.9911711 -07:00 |
Load Child Results Table:Information: The final commit for the data insertion in "DST - Good" has started.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
DST - Good [21] |
\Master\Execute Child Package\Child\Load Results[4]\Load Child Results Table |
| 2017-04-09 19:26:37.9911711 -07:00 |
Load Child Results Table:Information: The final commit for the data insertion in "DST - Good" has ended.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
DST - Good [21] |
\Master\Execute Child Package\Child\Load Results[4]\Load Child Results Table |
| 2017-04-09 19:26:37.7572520 -07:00 |
SQL Task B:Finished, 19:26:37, Elapsed time: 00:00:03.032. |
Child.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Execute Child Package\Child\Load Results[3]\SQL Task B |
| 2017-04-09 19:26:37.9597695 -07:00 |
Load Child Results Table:Information: The Lookup A processed 1505 rows in the cache. The processing time was 0.001 seconds. The cache used 60200 bytes of memory.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
Lookup A [40] |
\Master\Execute Child Package\Child\Load Results[4]\Load Child Results Table |
| 2017-04-09 19:26:37.9756110 -07:00 |
Load Child Results Table:Information: Execute phase is beginning.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
SSIS.Pipeline |
\Master\Execute Child Package\Child\Load Results[4]\Load Child Results Table |
| 2017-04-09 19:26:37.9911711 -07:00 |
Load Child Results Table:Information: The final commit for the data insertion in "DST - Bad" has started.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
DST - Bad [2] |
\Master\Execute Child Package\Child\Load Results[4]\Load Child Results Table |
| 2017-04-09 19:26:37.9911711 -07:00 |
Load Child Results Table:Information: The final commit for the data insertion in "DST - Bad" has ended.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
DST - Bad [2] |
\Master\Execute Child Package\Child\Load Results[4]\Load Child Results Table |
| 2017-04-09 19:26:37.9911711 -07:00 |
Load Child Results Table:Information: Post Execute phase is beginning.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
SSIS.Pipeline |
\Master\Execute Child Package\Child\Load Results[4]\Load Child Results Table |
| 2017-04-09 19:26:38.0070973 -07:00 |
Load Child Results Table:Information: "DST - Bad" wrote 961 rows.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
SSIS.Pipeline |
\Master\Execute Child Package\Child\Load Results[4]\Load Child Results Table |
| 2017-04-09 19:26:38.0070973 -07:00 |
Load Child Results Table:Information: "DST - Good" wrote 283 rows.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
SSIS.Pipeline |
\Master\Execute Child Package\Child\Load Results[4]\Load Child Results Table |
| 2017-04-09 19:26:38.0070973 -07:00 |
Load Child Results Table:Information: Cleanup phase is beginning.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
SSIS.Pipeline |
\Master\Execute Child Package\Child\Load Results[4]\Load Child Results Table |
| 2017-04-09 19:26:38.0070973 -07:00 |
Load Child Results Table:Finished, 19:26:38, Elapsed time: 00:00:00.250. |
Child.dtsx |
\Package\Load Results\Load Child Results Table |
None |
\Master\Execute Child Package\Child\Load Results[4]\Load Child Results Table |
| 2017-04-09 19:26:38.0070973 -07:00 |
Do Stuff:Start, 19:26:38. |
Child.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Execute Child Package\Child\Load Results[4]\Do Stuff |
| 2017-04-09 19:26:38.0070973 -07:00 |
Do Stuff:Validation has started. |
Child.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Execute Child Package\Child\Load Results[4]\Do Stuff |
| 2017-04-09 19:26:38.0070973 -07:00 |
Do Stuff:Validation is complete. |
Child.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Execute Child Package\Child\Load Results[4]\Do Stuff |
| 2017-04-09 19:26:38.0070973 -07:00 |
Do Stuff:Information: Will I raise an Exception? False |
Child.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Execute Child Package\Child\Load Results[4]\Do Stuff |
| 2017-04-09 19:26:38.0070973 -07:00 |
Do Stuff:Finished, 19:26:38, Elapsed time: 00:00:00.000. |
Child.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Execute Child Package\Child\Load Results[4]\Do Stuff |
| 2017-04-09 19:26:38.0070973 -07:00 |
SQL Task B:Start, 19:26:38. |
Child.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Execute Child Package\Child\Load Results[4]\SQL Task B |
| 2017-04-09 19:26:38.0070973 -07:00 |
SQL Task B:Validation has started. |
Child.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Execute Child Package\Child\Load Results[4]\SQL Task B |
| 2017-04-09 19:26:38.0070973 -07:00 |
SQL Task B:Validation is complete. |
Child.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Execute Child Package\Child\Load Results[4]\SQL Task B |
| 2017-04-09 19:26:42.0384463 -07:00 |
Load Child Results Table:Start, 19:26:42. |
Child.dtsx |
\Package\Load Results\Load Child Results Table |
None |
\Master\Execute Child Package\Child\Load Results[5]\Load Child Results Table |
| 2017-04-09 19:26:42.0384463 -07:00 |
Load Child Results Table:Validation has started. |
Child.dtsx |
\Package\Load Results\Load Child Results Table |
None |
\Master\Execute Child Package\Child\Load Results[5]\Load Child Results Table |
| 2017-04-09 19:26:42.0384463 -07:00 |
Load Child Results Table:Information: Validation phase is beginning.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
SSIS.Pipeline |
\Master\Execute Child Package\Child\Load Results[5]\Load Child Results Table |
| 2017-04-09 19:26:42.0384463 -07:00 |
SQL Task B:Finished, 19:26:42, Elapsed time: 00:00:04.031. |
Child.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Execute Child Package\Child\Load Results[4]\SQL Task B |
| 2017-04-09 19:26:42.1476277 -07:00 |
Load Child Results Table:Validation is complete. |
Child.dtsx |
\Package\Load Results\Load Child Results Table |
None |
\Master\Execute Child Package\Child\Load Results[5]\Load Child Results Table |
| 2017-04-09 19:26:42.1476277 -07:00 |
Load Child Results Table:Warning: The output column "my_id_a" (59) on output "Lookup Match Output" (58) and component "Lookup A" (40) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
SSIS.Pipeline |
\Master\Execute Child Package\Child\Load Results[5]\Load Child Results Table |
| 2017-04-09 19:26:42.1476277 -07:00 |
Load Child Results Table:Warning: The output column "my_id_b" (84) on output "Lookup Match Output" (83) and component "Lookup B" (65) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
SSIS.Pipeline |
\Master\Execute Child Package\Child\Load Results[5]\Load Child Results Table |
| 2017-04-09 19:26:42.1476277 -07:00 |
Load Child Results Table:Warning: The output column "my_id" (109) on output "Lookup Match Output" (108) and component "Lookup C" (90) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
SSIS.Pipeline |
\Master\Execute Child Package\Child\Load Results[5]\Load Child Results Table |
| 2017-04-09 19:26:42.1476277 -07:00 |
Load Child Results Table:Information: Prepare for Execute phase is beginning.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
SSIS.Pipeline |
\Master\Execute Child Package\Child\Load Results[5]\Load Child Results Table |
| 2017-04-09 19:26:42.1942120 -07:00 |
Load Child Results Table:Information: Pre-Execute phase is beginning.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
SSIS.Pipeline |
\Master\Execute Child Package\Child\Load Results[5]\Load Child Results Table |
| 2017-04-09 19:26:42.1942120 -07:00 |
Load Child Results Table:Information: Lookup C has cached 505 rows.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
Lookup C [90] |
\Master\Execute Child Package\Child\Load Results[5]\Load Child Results Table |
| 2017-04-09 19:26:42.1942120 -07:00 |
Load Child Results Table:Information: Lookup C has cached a total of 505 rows.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
Lookup C [90] |
\Master\Execute Child Package\Child\Load Results[5]\Load Child Results Table |
| 2017-04-09 19:26:42.2105211 -07:00 |
Load Child Results Table:Warning: The Lookup C encountered duplicate reference key values when caching reference data. This error occurs in Full Cache mode only. Either remove the duplicate key values, or change the cache mode to PARTIAL or NO_CACHE.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
Lookup C [90] |
\Master\Execute Child Package\Child\Load Results[5]\Load Child Results Table |
| 2017-04-09 19:26:42.2105211 -07:00 |
Load Child Results Table:Information: The number of unique rows added to the cache is 504.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
Lookup C [90] |
\Master\Execute Child Package\Child\Load Results[5]\Load Child Results Table |
| 2017-04-09 19:26:42.2105211 -07:00 |
Load Child Results Table:Information: The Lookup C processed 505 rows in the cache. The processing time was 0.016 seconds. The cache used 20200 bytes of memory.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
Lookup C [90] |
\Master\Execute Child Package\Child\Load Results[5]\Load Child Results Table |
| 2017-04-09 19:26:42.2409950 -07:00 |
Load Child Results Table:Information: Lookup B has cached 55 rows.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
Lookup B [65] |
\Master\Execute Child Package\Child\Load Results[5]\Load Child Results Table |
| 2017-04-09 19:26:42.2409950 -07:00 |
Load Child Results Table:Information: Lookup B has cached a total of 55 rows.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
Lookup B [65] |
\Master\Execute Child Package\Child\Load Results[5]\Load Child Results Table |
| 2017-04-09 19:26:42.2409950 -07:00 |
Load Child Results Table:Warning: The Lookup B encountered duplicate reference key values when caching reference data. This error occurs in Full Cache mode only. Either remove the duplicate key values, or change the cache mode to PARTIAL or NO_CACHE.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
Lookup B [65] |
\Master\Execute Child Package\Child\Load Results[5]\Load Child Results Table |
| 2017-04-09 19:26:42.2409950 -07:00 |
Load Child Results Table:Information: The number of unique rows added to the cache is 54.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
Lookup B [65] |
\Master\Execute Child Package\Child\Load Results[5]\Load Child Results Table |
| 2017-04-09 19:26:42.2574343 -07:00 |
Load Child Results Table:Information: The Lookup B processed 55 rows in the cache. The processing time was 0.001 seconds. The cache used 2200 bytes of memory.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
Lookup B [65] |
\Master\Execute Child Package\Child\Load Results[5]\Load Child Results Table |
| 2017-04-09 19:26:42.2574343 -07:00 |
Load Child Results Table:Information: Lookup A has cached 1505 rows.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
Lookup A [40] |
\Master\Execute Child Package\Child\Load Results[5]\Load Child Results Table |
| 2017-04-09 19:26:42.2574343 -07:00 |
Load Child Results Table:Information: Lookup A has cached a total of 1505 rows.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
Lookup A [40] |
\Master\Execute Child Package\Child\Load Results[5]\Load Child Results Table |
| 2017-04-09 19:26:42.2723938 -07:00 |
Load Child Results Table:Warning: The Lookup A encountered duplicate reference key values when caching reference data. This error occurs in Full Cache mode only. Either remove the duplicate key values, or change the cache mode to PARTIAL or NO_CACHE.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
Lookup A [40] |
\Master\Execute Child Package\Child\Load Results[5]\Load Child Results Table |
| 2017-04-09 19:26:42.2723938 -07:00 |
Load Child Results Table:Information: The number of unique rows added to the cache is 1504.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
Lookup A [40] |
\Master\Execute Child Package\Child\Load Results[5]\Load Child Results Table |
| 2017-04-09 19:26:42.2878696 -07:00 |
Load Child Results Table:Information: The final commit for the data insertion in "DST - Good" has started.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
DST - Good [21] |
\Master\Execute Child Package\Child\Load Results[5]\Load Child Results Table |
| 2017-04-09 19:26:42.2878696 -07:00 |
Load Child Results Table:Information: The final commit for the data insertion in "DST - Good" has ended.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
DST - Good [21] |
\Master\Execute Child Package\Child\Load Results[5]\Load Child Results Table |
| 2017-04-09 19:26:42.2878696 -07:00 |
Load Child Results Table:Information: The final commit for the data insertion in "DST - Bad" has started.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
DST - Bad [2] |
\Master\Execute Child Package\Child\Load Results[5]\Load Child Results Table |
| 2017-04-09 19:26:42.2878696 -07:00 |
Load Child Results Table:Information: The final commit for the data insertion in "DST - Bad" has ended.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
DST - Bad [2] |
\Master\Execute Child Package\Child\Load Results[5]\Load Child Results Table |
| 2017-04-09 19:26:42.2723938 -07:00 |
Load Child Results Table:Information: The Lookup A processed 1505 rows in the cache. The processing time was 0.015 seconds. The cache used 60200 bytes of memory.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
Lookup A [40] |
\Master\Execute Child Package\Child\Load Results[5]\Load Child Results Table |
| 2017-04-09 19:26:42.2723938 -07:00 |
Load Child Results Table:Information: Execute phase is beginning.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
SSIS.Pipeline |
\Master\Execute Child Package\Child\Load Results[5]\Load Child Results Table |
| 2017-04-09 19:26:42.2878696 -07:00 |
Load Child Results Table:Information: Post Execute phase is beginning.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
SSIS.Pipeline |
\Master\Execute Child Package\Child\Load Results[5]\Load Child Results Table |
| 2017-04-09 19:26:42.3034934 -07:00 |
Load Child Results Table:Information: "DST - Bad" wrote 1278 rows.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
SSIS.Pipeline |
\Master\Execute Child Package\Child\Load Results[5]\Load Child Results Table |
| 2017-04-09 19:26:42.3034934 -07:00 |
Load Child Results Table:Information: "DST - Good" wrote 366 rows.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
SSIS.Pipeline |
\Master\Execute Child Package\Child\Load Results[5]\Load Child Results Table |
| 2017-04-09 19:26:42.3034934 -07:00 |
Load Child Results Table:Information: Cleanup phase is beginning.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
SSIS.Pipeline |
\Master\Execute Child Package\Child\Load Results[5]\Load Child Results Table |
| 2017-04-09 19:26:42.3034934 -07:00 |
Load Child Results Table:Finished, 19:26:42, Elapsed time: 00:00:00.266. |
Child.dtsx |
\Package\Load Results\Load Child Results Table |
None |
\Master\Execute Child Package\Child\Load Results[5]\Load Child Results Table |
| 2017-04-09 19:26:42.3034934 -07:00 |
Do Stuff:Start, 19:26:42. |
Child.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Execute Child Package\Child\Load Results[5]\Do Stuff |
| 2017-04-09 19:26:42.3034934 -07:00 |
Do Stuff:Validation has started. |
Child.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Execute Child Package\Child\Load Results[5]\Do Stuff |
| 2017-04-09 19:26:42.3034934 -07:00 |
Do Stuff:Validation is complete. |
Child.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Execute Child Package\Child\Load Results[5]\Do Stuff |
| 2017-04-09 19:26:42.3034934 -07:00 |
Do Stuff:Information: Will I raise an Exception? False |
Child.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Execute Child Package\Child\Load Results[5]\Do Stuff |
| 2017-04-09 19:26:42.3034934 -07:00 |
Do Stuff:Finished, 19:26:42, Elapsed time: 00:00:00.000. |
Child.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Execute Child Package\Child\Load Results[5]\Do Stuff |
| 2017-04-09 19:26:42.3034934 -07:00 |
SQL Task B:Start, 19:26:42. |
Child.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Execute Child Package\Child\Load Results[5]\SQL Task B |
| 2017-04-09 19:26:42.3034934 -07:00 |
SQL Task B:Validation has started. |
Child.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Execute Child Package\Child\Load Results[5]\SQL Task B |
| 2017-04-09 19:26:42.3034934 -07:00 |
SQL Task B:Validation is complete. |
Child.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Execute Child Package\Child\Load Results[5]\SQL Task B |
| 2017-04-09 19:26:47.3193982 -07:00 |
Load Results:Finished, 19:26:47, Elapsed time: 00:00:19.250. |
Child.dtsx |
\Package\Load Results |
None |
\Master\Execute Child Package\Child\Load Results |
| 2017-04-09 19:26:47.3193982 -07:00 |
Child:Finished, 19:26:47, Elapsed time: 00:00:19.265. |
Child.dtsx |
\Package |
None |
\Master\Execute Child Package\Child |
| 2017-04-09 19:26:47.3193982 -07:00 |
SQL Task B:Finished, 19:26:47, Elapsed time: 00:00:05.015. |
Child.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Execute Child Package\Child\Load Results[5]\SQL Task B |
| 2017-04-09 19:26:47.3352783 -07:00 |
Execute Child Package:Finished, 19:26:47, Elapsed time: 00:00:19.360. |
Master.dtsx |
\Package\Execute Child Package |
None |
\Master\Execute Child Package |
| 2017-04-09 19:26:47.3352783 -07:00 |
Load Results:Start, 19:26:47. |
Master.dtsx |
\Package\Load Results |
None |
\Master\Load Results |
| 2017-04-09 19:26:47.3352783 -07:00 |
Load Master Result Table:Start, 19:26:47. |
Master.dtsx |
\Package\Load Results\Load Master Result Table |
None |
\Master\Load Results[1]\Load Master Result Table |
| 2017-04-09 19:26:47.3352783 -07:00 |
Load Master Result Table:Validation has started. |
Master.dtsx |
\Package\Load Results\Load Master Result Table |
None |
\Master\Load Results[1]\Load Master Result Table |
| 2017-04-09 19:26:47.3352783 -07:00 |
Load Master Result Table:Information: Validation phase is beginning.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
SSIS.Pipeline |
\Master\Load Results[1]\Load Master Result Table |
| 2017-04-09 19:26:47.3973823 -07:00 |
Load Master Result Table:Validation is complete. |
Master.dtsx |
\Package\Load Results\Load Master Result Table |
None |
\Master\Load Results[1]\Load Master Result Table |
| 2017-04-09 19:26:47.3973823 -07:00 |
Load Master Result Table:Warning: The output column "my_id" (59) on output "Lookup Match Output" (58) and component "Lookup" (40) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
SSIS.Pipeline |
\Master\Load Results[1]\Load Master Result Table |
| 2017-04-09 19:26:47.3973823 -07:00 |
Load Master Result Table:Information: Prepare for Execute phase is beginning.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
SSIS.Pipeline |
\Master\Load Results[1]\Load Master Result Table |
| 2017-04-09 19:26:47.4288476 -07:00 |
Load Master Result Table:Information: Pre-Execute phase is beginning.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
SSIS.Pipeline |
\Master\Load Results[1]\Load Master Result Table |
| 2017-04-09 19:26:47.4757390 -07:00 |
Load Master Result Table:Information: Lookup has cached 505 rows.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
Lookup [40] |
\Master\Load Results[1]\Load Master Result Table |
| 2017-04-09 19:26:47.4757390 -07:00 |
Load Master Result Table:Information: Lookup has cached a total of 505 rows.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
Lookup [40] |
\Master\Load Results[1]\Load Master Result Table |
| 2017-04-09 19:26:47.4757390 -07:00 |
Load Master Result Table:Warning: The Lookup encountered duplicate reference key values when caching reference data. This error occurs in Full Cache mode only. Either remove the duplicate key values, or change the cache mode to PARTIAL or NO_CACHE.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
Lookup [40] |
\Master\Load Results[1]\Load Master Result Table |
| 2017-04-09 19:26:47.4757390 -07:00 |
Load Master Result Table:Information: The number of unique rows added to the cache is 504.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
Lookup [40] |
\Master\Load Results[1]\Load Master Result Table |
| 2017-04-09 19:26:47.4757390 -07:00 |
Load Master Result Table:Information: The Lookup processed 505 rows in the cache. The processing time was 0.015 seconds. The cache used 20200 bytes of memory.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
Lookup [40] |
\Master\Load Results[1]\Load Master Result Table |
| 2017-04-09 19:26:47.4910301 -07:00 |
Load Master Result Table:Information: Execute phase is beginning.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
SSIS.Pipeline |
\Master\Load Results[1]\Load Master Result Table |
| 2017-04-09 19:26:47.4910301 -07:00 |
Load Master Result Table:Information: The final commit for the data insertion in "DST - Bad" has started.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
DST - Bad [2] |
\Master\Load Results[1]\Load Master Result Table |
| 2017-04-09 19:26:47.4910301 -07:00 |
Load Master Result Table:Information: The final commit for the data insertion in "DST - Bad" has ended.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
DST - Bad [2] |
\Master\Load Results[1]\Load Master Result Table |
| 2017-04-09 19:26:47.4910301 -07:00 |
Load Master Result Table:Information: Post Execute phase is beginning.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
SSIS.Pipeline |
\Master\Load Results[1]\Load Master Result Table |
| 2017-04-09 19:26:47.4910301 -07:00 |
Load Master Result Table:Information: "DST - Bad" wrote 1453 rows.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
SSIS.Pipeline |
\Master\Load Results[1]\Load Master Result Table |
| 2017-04-09 19:26:47.4910301 -07:00 |
Load Master Result Table:Information: "DST - Good" wrote 413 rows.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
SSIS.Pipeline |
\Master\Load Results[1]\Load Master Result Table |
| 2017-04-09 19:26:47.4910301 -07:00 |
Load Master Result Table:Information: The final commit for the data insertion in "DST - Good" has started.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
DST - Good [21] |
\Master\Load Results[1]\Load Master Result Table |
| 2017-04-09 19:26:47.4910301 -07:00 |
Load Master Result Table:Information: The final commit for the data insertion in "DST - Good" has ended.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
DST - Good [21] |
\Master\Load Results[1]\Load Master Result Table |
| 2017-04-09 19:26:47.5070652 -07:00 |
SQL Task B:Start, 19:26:47. |
Master.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Load Results[1]\SQL Task B |
| 2017-04-09 19:26:47.5070652 -07:00 |
SQL Task B:Validation has started. |
Master.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Load Results[1]\SQL Task B |
| 2017-04-09 19:26:47.5070652 -07:00 |
SQL Task B:Validation is complete. |
Master.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Load Results[1]\SQL Task B |
| 2017-04-09 19:26:47.4910301 -07:00 |
Load Master Result Table:Information: Cleanup phase is beginning.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
SSIS.Pipeline |
\Master\Load Results[1]\Load Master Result Table |
| 2017-04-09 19:26:47.5070652 -07:00 |
Load Master Result Table:Finished, 19:26:47, Elapsed time: 00:00:00.172. |
Master.dtsx |
\Package\Load Results\Load Master Result Table |
None |
\Master\Load Results[1]\Load Master Result Table |
| 2017-04-09 19:26:47.5070652 -07:00 |
Do Stuff:Start, 19:26:47. |
Master.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Load Results[1]\Do Stuff |
| 2017-04-09 19:26:47.5070652 -07:00 |
Do Stuff:Validation has started. |
Master.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Load Results[1]\Do Stuff |
| 2017-04-09 19:26:47.5070652 -07:00 |
Do Stuff:Validation is complete. |
Master.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Load Results[1]\Do Stuff |
| 2017-04-09 19:26:47.5070652 -07:00 |
Do Stuff:Finished, 19:26:47, Elapsed time: 00:00:00.000. |
Master.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Load Results[1]\Do Stuff |
| 2017-04-09 19:27:00.7107532 -07:00 |
Load Master Result Table:Information: The final commit for the data insertion in "DST - Good" has started.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
DST - Good [21] |
\Master\Load Results[2]\Load Master Result Table |
| 2017-04-09 19:27:00.7107532 -07:00 |
Load Master Result Table:Information: The final commit for the data insertion in "DST - Good" has ended.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
DST - Good [21] |
\Master\Load Results[2]\Load Master Result Table |
| 2017-04-09 19:27:00.7107532 -07:00 |
Load Master Result Table:Information: The final commit for the data insertion in "DST - Bad" has started.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
DST - Bad [2] |
\Master\Load Results[2]\Load Master Result Table |
| 2017-04-09 19:27:00.7107532 -07:00 |
Load Master Result Table:Information: The final commit for the data insertion in "DST - Bad" has ended.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
DST - Bad [2] |
\Master\Load Results[2]\Load Master Result Table |
| 2017-04-09 19:27:00.5226727 -07:00 |
Load Master Result Table:Start, 19:27:00. |
Master.dtsx |
\Package\Load Results\Load Master Result Table |
None |
\Master\Load Results[2]\Load Master Result Table |
| 2017-04-09 19:27:00.5226727 -07:00 |
Load Master Result Table:Validation has started. |
Master.dtsx |
\Package\Load Results\Load Master Result Table |
None |
\Master\Load Results[2]\Load Master Result Table |
| 2017-04-09 19:27:00.5226727 -07:00 |
Load Master Result Table:Information: Validation phase is beginning.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
SSIS.Pipeline |
\Master\Load Results[2]\Load Master Result Table |
| 2017-04-09 19:27:00.6166639 -07:00 |
Load Master Result Table:Validation is complete. |
Master.dtsx |
\Package\Load Results\Load Master Result Table |
None |
\Master\Load Results[2]\Load Master Result Table |
| 2017-04-09 19:27:00.6319038 -07:00 |
Load Master Result Table:Warning: The output column "my_id" (59) on output "Lookup Match Output" (58) and component "Lookup" (40) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
SSIS.Pipeline |
\Master\Load Results[2]\Load Master Result Table |
| 2017-04-09 19:27:00.6319038 -07:00 |
Load Master Result Table:Information: Prepare for Execute phase is beginning.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
SSIS.Pipeline |
\Master\Load Results[2]\Load Master Result Table |
| 2017-04-09 19:27:00.6629360 -07:00 |
Load Master Result Table:Information: Pre-Execute phase is beginning.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
SSIS.Pipeline |
\Master\Load Results[2]\Load Master Result Table |
| 2017-04-09 19:27:00.7107532 -07:00 |
Load Master Result Table:Information: Lookup has cached 505 rows.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
Lookup [40] |
\Master\Load Results[2]\Load Master Result Table |
| 2017-04-09 19:27:00.7107532 -07:00 |
Load Master Result Table:Information: Lookup has cached a total of 505 rows.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
Lookup [40] |
\Master\Load Results[2]\Load Master Result Table |
| 2017-04-09 19:27:00.7107532 -07:00 |
Load Master Result Table:Warning: The Lookup encountered duplicate reference key values when caching reference data. This error occurs in Full Cache mode only. Either remove the duplicate key values, or change the cache mode to PARTIAL or NO_CACHE.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
Lookup [40] |
\Master\Load Results[2]\Load Master Result Table |
| 2017-04-09 19:27:00.7107532 -07:00 |
Load Master Result Table:Information: The number of unique rows added to the cache is 504.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
Lookup [40] |
\Master\Load Results[2]\Load Master Result Table |
| 2017-04-09 19:27:00.7107532 -07:00 |
Load Master Result Table:Information: The Lookup processed 505 rows in the cache. The processing time was 0.016 seconds. The cache used 20200 bytes of memory.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
Lookup [40] |
\Master\Load Results[2]\Load Master Result Table |
| 2017-04-09 19:27:00.7107532 -07:00 |
Load Master Result Table:Information: Execute phase is beginning.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
SSIS.Pipeline |
\Master\Load Results[2]\Load Master Result Table |
| 2017-04-09 19:27:00.7254428 -07:00 |
Load Master Result Table:Information: Post Execute phase is beginning.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
SSIS.Pipeline |
\Master\Load Results[2]\Load Master Result Table |
| 2017-04-09 19:27:00.7254428 -07:00 |
Load Master Result Table:Information: "DST - Bad" wrote 326 rows.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
SSIS.Pipeline |
\Master\Load Results[2]\Load Master Result Table |
| 2017-04-09 19:27:00.7254428 -07:00 |
Load Master Result Table:Information: "DST - Good" wrote 74 rows.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
SSIS.Pipeline |
\Master\Load Results[2]\Load Master Result Table |
| 2017-04-09 19:27:00.7254428 -07:00 |
Load Master Result Table:Information: Cleanup phase is beginning.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
SSIS.Pipeline |
\Master\Load Results[2]\Load Master Result Table |
| 2017-04-09 19:27:00.7254428 -07:00 |
Load Master Result Table:Finished, 19:27:00, Elapsed time: 00:00:00.203. |
Master.dtsx |
\Package\Load Results\Load Master Result Table |
None |
\Master\Load Results[2]\Load Master Result Table |
| 2017-04-09 19:27:00.7254428 -07:00 |
Do Stuff:Start, 19:27:00. |
Master.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Load Results[2]\Do Stuff |
| 2017-04-09 19:27:00.7254428 -07:00 |
Do Stuff:Validation has started. |
Master.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Load Results[2]\Do Stuff |
| 2017-04-09 19:27:00.7254428 -07:00 |
Do Stuff:Validation is complete. |
Master.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Load Results[2]\Do Stuff |
| 2017-04-09 19:27:00.7254428 -07:00 |
Do Stuff:Finished, 19:27:00, Elapsed time: 00:00:00.000. |
Master.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Load Results[2]\Do Stuff |
| 2017-04-09 19:27:00.5226727 -07:00 |
SQL Task B:Finished, 19:27:00, Elapsed time: 00:00:13.015. |
Master.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Load Results[1]\SQL Task B |
| 2017-04-09 19:27:00.7254428 -07:00 |
SQL Task B:Start, 19:27:00. |
Master.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Load Results[2]\SQL Task B |
| 2017-04-09 19:27:00.7254428 -07:00 |
SQL Task B:Validation has started. |
Master.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Load Results[2]\SQL Task B |
| 2017-04-09 19:27:00.7254428 -07:00 |
SQL Task B:Validation is complete. |
Master.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Load Results[2]\SQL Task B |
| 2017-04-09 19:27:23.8508375 -07:00 |
Load Master Result Table:Information: The final commit for the data insertion in "DST - Good" has started.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
DST - Good [21] |
\Master\Load Results[3]\Load Master Result Table |
| 2017-04-09 19:27:23.8508375 -07:00 |
Load Master Result Table:Information: The final commit for the data insertion in "DST - Good" has ended.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
DST - Good [21] |
\Master\Load Results[3]\Load Master Result Table |
| 2017-04-09 19:27:23.7415533 -07:00 |
Load Master Result Table:Start, 19:27:23. |
Master.dtsx |
\Package\Load Results\Load Master Result Table |
None |
\Master\Load Results[3]\Load Master Result Table |
| 2017-04-09 19:27:23.7415533 -07:00 |
Load Master Result Table:Validation has started. |
Master.dtsx |
\Package\Load Results\Load Master Result Table |
None |
\Master\Load Results[3]\Load Master Result Table |
| 2017-04-09 19:27:23.7415533 -07:00 |
Load Master Result Table:Information: Validation phase is beginning.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
SSIS.Pipeline |
\Master\Load Results[3]\Load Master Result Table |
| 2017-04-09 19:27:23.7883977 -07:00 |
Load Master Result Table:Validation is complete. |
Master.dtsx |
\Package\Load Results\Load Master Result Table |
None |
\Master\Load Results[3]\Load Master Result Table |
| 2017-04-09 19:27:23.7883977 -07:00 |
Load Master Result Table:Warning: The output column "my_id" (59) on output "Lookup Match Output" (58) and component "Lookup" (40) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
SSIS.Pipeline |
\Master\Load Results[3]\Load Master Result Table |
| 2017-04-09 19:27:23.7883977 -07:00 |
Load Master Result Table:Information: Prepare for Execute phase is beginning.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
SSIS.Pipeline |
\Master\Load Results[3]\Load Master Result Table |
| 2017-04-09 19:27:23.8036679 -07:00 |
Load Master Result Table:Information: Pre-Execute phase is beginning.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
SSIS.Pipeline |
\Master\Load Results[3]\Load Master Result Table |
| 2017-04-09 19:27:23.8354523 -07:00 |
Load Master Result Table:Information: Lookup has cached 505 rows.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
Lookup [40] |
\Master\Load Results[3]\Load Master Result Table |
| 2017-04-09 19:27:23.8354523 -07:00 |
Load Master Result Table:Information: Lookup has cached a total of 505 rows.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
Lookup [40] |
\Master\Load Results[3]\Load Master Result Table |
| 2017-04-09 19:27:23.8508375 -07:00 |
Load Master Result Table:Warning: The Lookup encountered duplicate reference key values when caching reference data. This error occurs in Full Cache mode only. Either remove the duplicate key values, or change the cache mode to PARTIAL or NO_CACHE.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
Lookup [40] |
\Master\Load Results[3]\Load Master Result Table |
| 2017-04-09 19:27:23.8508375 -07:00 |
Load Master Result Table:Information: The number of unique rows added to the cache is 504.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
Lookup [40] |
\Master\Load Results[3]\Load Master Result Table |
| 2017-04-09 19:27:23.8508375 -07:00 |
Load Master Result Table:Information: The Lookup processed 505 rows in the cache. The processing time was 0.015 seconds. The cache used 20200 bytes of memory.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
Lookup [40] |
\Master\Load Results[3]\Load Master Result Table |
| 2017-04-09 19:27:23.8508375 -07:00 |
Load Master Result Table:Information: Execute phase is beginning.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
SSIS.Pipeline |
\Master\Load Results[3]\Load Master Result Table |
| 2017-04-09 19:27:23.8508375 -07:00 |
Load Master Result Table:Information: The final commit for the data insertion in "DST - Bad" has started.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
DST - Bad [2] |
\Master\Load Results[3]\Load Master Result Table |
| 2017-04-09 19:27:23.8508375 -07:00 |
Load Master Result Table:Information: The final commit for the data insertion in "DST - Bad" has ended.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
DST - Bad [2] |
\Master\Load Results[3]\Load Master Result Table |
| 2017-04-09 19:27:23.8660988 -07:00 |
Load Master Result Table:Information: Post Execute phase is beginning.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
SSIS.Pipeline |
\Master\Load Results[3]\Load Master Result Table |
| 2017-04-09 19:27:23.8660988 -07:00 |
Load Master Result Table:Information: "DST - Bad" wrote 1291 rows.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
SSIS.Pipeline |
\Master\Load Results[3]\Load Master Result Table |
| 2017-04-09 19:27:23.8660988 -07:00 |
Load Master Result Table:Information: "DST - Good" wrote 353 rows.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
SSIS.Pipeline |
\Master\Load Results[3]\Load Master Result Table |
| 2017-04-09 19:27:23.8660988 -07:00 |
Load Master Result Table:Information: Cleanup phase is beginning.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
SSIS.Pipeline |
\Master\Load Results[3]\Load Master Result Table |
| 2017-04-09 19:27:23.8660988 -07:00 |
Load Master Result Table:Finished, 19:27:23, Elapsed time: 00:00:00.125. |
Master.dtsx |
\Package\Load Results\Load Master Result Table |
None |
\Master\Load Results[3]\Load Master Result Table |
| 2017-04-09 19:27:23.8660988 -07:00 |
Do Stuff:Start, 19:27:23. |
Master.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Load Results[3]\Do Stuff |
| 2017-04-09 19:27:23.8660988 -07:00 |
Do Stuff:Validation has started. |
Master.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Load Results[3]\Do Stuff |
| 2017-04-09 19:27:23.8660988 -07:00 |
Do Stuff:Validation is complete. |
Master.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Load Results[3]\Do Stuff |
| 2017-04-09 19:27:23.8660988 -07:00 |
Do Stuff:Finished, 19:27:23, Elapsed time: 00:00:00.000. |
Master.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Load Results[3]\Do Stuff |
| 2017-04-09 19:27:23.7415533 -07:00 |
SQL Task B:Finished, 19:27:23, Elapsed time: 00:00:23.016. |
Master.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Load Results[2]\SQL Task B |
| 2017-04-09 19:27:23.8660988 -07:00 |
SQL Task B:Start, 19:27:23. |
Master.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Load Results[3]\SQL Task B |
| 2017-04-09 19:27:23.8660988 -07:00 |
SQL Task B:Validation has started. |
Master.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Load Results[3]\SQL Task B |
| 2017-04-09 19:27:23.8660988 -07:00 |
SQL Task B:Validation is complete. |
Master.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Load Results[3]\SQL Task B |
| 2017-04-09 19:27:56.8852441 -07:00 |
Load Master Result Table:Start, 19:27:56. |
Master.dtsx |
\Package\Load Results\Load Master Result Table |
None |
\Master\Load Results[4]\Load Master Result Table |
| 2017-04-09 19:27:56.8852441 -07:00 |
Load Master Result Table:Validation has started. |
Master.dtsx |
\Package\Load Results\Load Master Result Table |
None |
\Master\Load Results[4]\Load Master Result Table |
| 2017-04-09 19:27:56.8852441 -07:00 |
Load Master Result Table:Information: Validation phase is beginning.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
SSIS.Pipeline |
\Master\Load Results[4]\Load Master Result Table |
| 2017-04-09 19:27:56.9472554 -07:00 |
Load Master Result Table:Validation is complete. |
Master.dtsx |
\Package\Load Results\Load Master Result Table |
None |
\Master\Load Results[4]\Load Master Result Table |
| 2017-04-09 19:27:56.9472554 -07:00 |
Load Master Result Table:Warning: The output column "my_id" (59) on output "Lookup Match Output" (58) and component "Lookup" (40) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
SSIS.Pipeline |
\Master\Load Results[4]\Load Master Result Table |
| 2017-04-09 19:27:56.9472554 -07:00 |
Load Master Result Table:Information: Prepare for Execute phase is beginning.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
SSIS.Pipeline |
\Master\Load Results[4]\Load Master Result Table |
| 2017-04-09 19:27:56.9628792 -07:00 |
Load Master Result Table:Information: Pre-Execute phase is beginning.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
SSIS.Pipeline |
\Master\Load Results[4]\Load Master Result Table |
| 2017-04-09 19:27:57.1816942 -07:00 |
Load Master Result Table:Information: The final commit for the data insertion in "DST - Good" has started.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
DST - Good [21] |
\Master\Load Results[4]\Load Master Result Table |
| 2017-04-09 19:27:57.1816942 -07:00 |
Load Master Result Table:Information: The final commit for the data insertion in "DST - Good" has ended.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
DST - Good [21] |
\Master\Load Results[4]\Load Master Result Table |
| 2017-04-09 19:27:57.1976692 -07:00 |
Do Stuff:Validation is complete. |
Master.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Load Results[4]\Do Stuff |
| 2017-04-09 19:27:57.1976692 -07:00 |
Do Stuff:Finished, 19:27:57, Elapsed time: 00:00:00.000. |
Master.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Load Results[4]\Do Stuff |
| 2017-04-09 19:27:56.8852441 -07:00 |
SQL Task B:Finished, 19:27:56, Elapsed time: 00:00:33.016. |
Master.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Load Results[3]\SQL Task B |
| 2017-04-09 19:27:57.1816942 -07:00 |
Load Master Result Table:Information: The final commit for the data insertion in "DST - Bad" has started.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
DST - Bad [2] |
\Master\Load Results[4]\Load Master Result Table |
| 2017-04-09 19:27:57.1816942 -07:00 |
Load Master Result Table:Information: The final commit for the data insertion in "DST - Bad" has ended.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
DST - Bad [2] |
\Master\Load Results[4]\Load Master Result Table |
| 2017-04-09 19:27:57.1976692 -07:00 |
SQL Task B:Start, 19:27:57. |
Master.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Load Results[4]\SQL Task B |
| 2017-04-09 19:27:57.1976692 -07:00 |
SQL Task B:Validation has started. |
Master.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Load Results[4]\SQL Task B |
| 2017-04-09 19:27:57.1976692 -07:00 |
SQL Task B:Validation is complete. |
Master.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Load Results[4]\SQL Task B |
| 2017-04-09 19:27:57.1662234 -07:00 |
Load Master Result Table:Information: Lookup has cached 505 rows.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
Lookup [40] |
\Master\Load Results[4]\Load Master Result Table |
| 2017-04-09 19:27:57.1662234 -07:00 |
Load Master Result Table:Information: Lookup has cached a total of 505 rows.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
Lookup [40] |
\Master\Load Results[4]\Load Master Result Table |
| 2017-04-09 19:27:57.1662234 -07:00 |
Load Master Result Table:Warning: The Lookup encountered duplicate reference key values when caching reference data. This error occurs in Full Cache mode only. Either remove the duplicate key values, or change the cache mode to PARTIAL or NO_CACHE.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
Lookup [40] |
\Master\Load Results[4]\Load Master Result Table |
| 2017-04-09 19:27:57.1662234 -07:00 |
Load Master Result Table:Information: The number of unique rows added to the cache is 504.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
Lookup [40] |
\Master\Load Results[4]\Load Master Result Table |
| 2017-04-09 19:27:57.1662234 -07:00 |
Load Master Result Table:Information: The Lookup processed 505 rows in the cache. The processing time was 0.016 seconds. The cache used 20200 bytes of memory.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
Lookup [40] |
\Master\Load Results[4]\Load Master Result Table |
| 2017-04-09 19:27:57.1816942 -07:00 |
Load Master Result Table:Information: Execute phase is beginning.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
SSIS.Pipeline |
\Master\Load Results[4]\Load Master Result Table |
| 2017-04-09 19:27:57.1816942 -07:00 |
Load Master Result Table:Information: Post Execute phase is beginning.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
SSIS.Pipeline |
\Master\Load Results[4]\Load Master Result Table |
| 2017-04-09 19:27:57.1816942 -07:00 |
Load Master Result Table:Information: "DST - Bad" wrote 1284 rows.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
SSIS.Pipeline |
\Master\Load Results[4]\Load Master Result Table |
| 2017-04-09 19:27:57.1816942 -07:00 |
Load Master Result Table:Information: "DST - Good" wrote 360 rows.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
SSIS.Pipeline |
\Master\Load Results[4]\Load Master Result Table |
| 2017-04-09 19:27:57.1976692 -07:00 |
Load Master Result Table:Information: Cleanup phase is beginning.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
SSIS.Pipeline |
\Master\Load Results[4]\Load Master Result Table |
| 2017-04-09 19:27:57.1976692 -07:00 |
Load Master Result Table:Finished, 19:27:57, Elapsed time: 00:00:00.312. |
Master.dtsx |
\Package\Load Results\Load Master Result Table |
None |
\Master\Load Results[4]\Load Master Result Table |
| 2017-04-09 19:28:40.2139336 -07:00 |
Load Master Result Table:Start, 19:28:40. |
Master.dtsx |
\Package\Load Results\Load Master Result Table |
None |
\Master\Load Results[5]\Load Master Result Table |
| 2017-04-09 19:28:40.2139336 -07:00 |
Load Master Result Table:Validation has started. |
Master.dtsx |
\Package\Load Results\Load Master Result Table |
None |
\Master\Load Results[5]\Load Master Result Table |
| 2017-04-09 19:28:40.2139336 -07:00 |
Load Master Result Table:Information: Validation phase is beginning.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
SSIS.Pipeline |
\Master\Load Results[5]\Load Master Result Table |
| 2017-04-09 19:28:40.2139336 -07:00 |
SQL Task B:Finished, 19:28:40, Elapsed time: 00:00:43.016. |
Master.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Load Results[4]\SQL Task B |
| 2017-04-09 19:28:40.3381224 -07:00 |
Load Master Result Table:Validation is complete. |
Master.dtsx |
\Package\Load Results\Load Master Result Table |
None |
\Master\Load Results[5]\Load Master Result Table |
| 2017-04-09 19:28:40.3381224 -07:00 |
Load Master Result Table:Warning: The output column "my_id" (59) on output "Lookup Match Output" (58) and component "Lookup" (40) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
SSIS.Pipeline |
\Master\Load Results[5]\Load Master Result Table |
| 2017-04-09 19:28:40.3381224 -07:00 |
Load Master Result Table:Information: Prepare for Execute phase is beginning.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
SSIS.Pipeline |
\Master\Load Results[5]\Load Master Result Table |
| 2017-04-09 19:28:40.4013703 -07:00 |
Load Master Result Table:Information: Pre-Execute phase is beginning.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
SSIS.Pipeline |
\Master\Load Results[5]\Load Master Result Table |
| 2017-04-09 19:28:40.8535726 -07:00 |
Load Master Result Table:Information: Lookup has cached 505 rows.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
Lookup [40] |
\Master\Load Results[5]\Load Master Result Table |
| 2017-04-09 19:28:40.8535726 -07:00 |
Load Master Result Table:Information: Lookup has cached a total of 505 rows.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
Lookup [40] |
\Master\Load Results[5]\Load Master Result Table |
| 2017-04-09 19:28:40.8535726 -07:00 |
Load Master Result Table:Warning: The Lookup encountered duplicate reference key values when caching reference data. This error occurs in Full Cache mode only. Either remove the duplicate key values, or change the cache mode to PARTIAL or NO_CACHE.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
Lookup [40] |
\Master\Load Results[5]\Load Master Result Table |
| 2017-04-09 19:28:40.8535726 -07:00 |
Load Master Result Table:Information: The number of unique rows added to the cache is 504.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
Lookup [40] |
\Master\Load Results[5]\Load Master Result Table |
| 2017-04-09 19:28:40.8535726 -07:00 |
Load Master Result Table:Information: The Lookup processed 505 rows in the cache. The processing time was 0.187 seconds. The cache used 20200 bytes of memory.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
Lookup [40] |
\Master\Load Results[5]\Load Master Result Table |
| 2017-04-09 19:28:40.9162372 -07:00 |
Do Stuff:Start, 19:28:40. |
Master.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Load Results[5]\Do Stuff |
| 2017-04-09 19:28:40.9162372 -07:00 |
Do Stuff:Validation has started. |
Master.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Load Results[5]\Do Stuff |
| 2017-04-09 19:28:40.9162372 -07:00 |
Do Stuff:Validation is complete. |
Master.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Load Results[5]\Do Stuff |
| 2017-04-09 19:28:40.9162372 -07:00 |
Do Stuff:Finished, 19:28:40, Elapsed time: 00:00:00.000. |
Master.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Load Results[5]\Do Stuff |
| 2017-04-09 19:28:40.9162372 -07:00 |
SQL Task B:Start, 19:28:40. |
Master.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Load Results[5]\SQL Task B |
| 2017-04-09 19:28:40.9162372 -07:00 |
SQL Task B:Validation has started. |
Master.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Load Results[5]\SQL Task B |
| 2017-04-09 19:28:40.9162372 -07:00 |
SQL Task B:Validation is complete. |
Master.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Load Results[5]\SQL Task B |
| 2017-04-09 19:28:40.9004831 -07:00 |
Load Master Result Table:Information: The final commit for the data insertion in "DST - Bad" has started.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
DST - Bad [2] |
\Master\Load Results[5]\Load Master Result Table |
| 2017-04-09 19:28:40.9004831 -07:00 |
Load Master Result Table:Information: The final commit for the data insertion in "DST - Bad" has ended.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
DST - Bad [2] |
\Master\Load Results[5]\Load Master Result Table |
| 2017-04-09 19:28:40.9162372 -07:00 |
Load Master Result Table:Information: The final commit for the data insertion in "DST - Good" has started.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
DST - Good [21] |
\Master\Load Results[5]\Load Master Result Table |
| 2017-04-09 19:28:40.9162372 -07:00 |
Load Master Result Table:Information: The final commit for the data insertion in "DST - Good" has ended.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
DST - Good [21] |
\Master\Load Results[5]\Load Master Result Table |
| 2017-04-09 19:28:40.9004831 -07:00 |
Load Master Result Table:Information: Execute phase is beginning.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
SSIS.Pipeline |
\Master\Load Results[5]\Load Master Result Table |
| 2017-04-09 19:28:40.9162372 -07:00 |
Load Master Result Table:Information: Post Execute phase is beginning.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
SSIS.Pipeline |
\Master\Load Results[5]\Load Master Result Table |
| 2017-04-09 19:28:40.9162372 -07:00 |
Load Master Result Table:Information: "DST - Bad" wrote 1431 rows.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
SSIS.Pipeline |
\Master\Load Results[5]\Load Master Result Table |
| 2017-04-09 19:28:40.9162372 -07:00 |
Load Master Result Table:Information: "DST - Good" wrote 435 rows.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
SSIS.Pipeline |
\Master\Load Results[5]\Load Master Result Table |
| 2017-04-09 19:28:40.9162372 -07:00 |
Load Master Result Table:Information: Cleanup phase is beginning.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
SSIS.Pipeline |
\Master\Load Results[5]\Load Master Result Table |
| 2017-04-09 19:28:40.9162372 -07:00 |
Load Master Result Table:Finished, 19:28:40, Elapsed time: 00:00:00.703. |
Master.dtsx |
\Package\Load Results\Load Master Result Table |
None |
\Master\Load Results[5]\Load Master Result Table |
| 2017-04-09 19:29:33.9993566 -07:00 |
Load Results:Finished, 19:29:33, Elapsed time: 00:02:46.656. |
Master.dtsx |
\Package\Load Results |
None |
\Master\Load Results |
| 2017-04-09 19:29:34.0304064 -07:00 |
Say Bye:Start, 19:29:34. |
Master.dtsx |
\Package\SayBye\Say Bye |
None |
\Master\SayBye\Say Bye |
| 2017-04-09 19:29:34.0304064 -07:00 |
Say Bye:Validation has started. |
Master.dtsx |
\Package\SayBye\Say Bye |
None |
\Master\SayBye\Say Bye |
| 2017-04-09 19:29:34.0304064 -07:00 |
Say Bye:Validation is complete. |
Master.dtsx |
\Package\SayBye\Say Bye |
None |
\Master\SayBye\Say Bye |
| 2017-04-09 19:29:34.0304064 -07:00 |
Say Bye:Information: Package executed, bye! |
Master.dtsx |
\Package\SayBye\Say Bye |
None |
\Master\SayBye\Say Bye |
| 2017-04-09 19:29:34.0304064 -07:00 |
Say Bye:Finished, 19:29:34, Elapsed time: 00:00:00.000. |
Master.dtsx |
\Package\SayBye\Say Bye |
None |
\Master\SayBye\Say Bye |
| 2017-04-09 19:29:34.0304064 -07:00 |
SayBye:Finished, 19:29:34, Elapsed time: 00:00:00.015. |
Master.dtsx |
\Package\SayBye |
None |
\Master\SayBye |
| 2017-04-09 19:29:34.0304064 -07:00 |
Master:Finished, 19:29:34, Elapsed time: 00:03:07.375. |
Master.dtsx |
\Package |
None |
\Master |
| 2017-04-09 19:29:33.9993566 -07:00 |
Drop Results Table:Start, 19:29:33. |
Master.dtsx |
\Package\Drop Results Table |
None |
\Master\Drop Results Table |
| 2017-04-09 19:29:33.9993566 -07:00 |
Drop Results Table:Validation has started. |
Master.dtsx |
\Package\Drop Results Table |
None |
\Master\Drop Results Table |
| 2017-04-09 19:29:33.9993566 -07:00 |
Drop Results Table:Validation is complete. |
Master.dtsx |
\Package\Drop Results Table |
None |
\Master\Drop Results Table |
| 2017-04-09 19:29:34.0148761 -07:00 |
Drop Results Table:Finished, 19:29:34, Elapsed time: 00:00:00.016. |
Master.dtsx |
\Package\Drop Results Table |
None |
\Master\Drop Results Table |
| 2017-04-09 19:29:34.0148761 -07:00 |
SayBye:Start, 19:29:34. |
Master.dtsx |
\Package\SayBye |
None |
\Master\SayBye |
| 2017-04-09 19:29:34.0304064 -07:00 |
Say Bye Once More:Start, 19:29:34. |
Master.dtsx |
\Package\SayBye\Say Bye Once More |
None |
\Master\SayBye\Say Bye Once More |
| 2017-04-09 19:29:34.0304064 -07:00 |
Say Bye Once More:Validation has started. |
Master.dtsx |
\Package\SayBye\Say Bye Once More |
None |
\Master\SayBye\Say Bye Once More |
| 2017-04-09 19:29:34.0304064 -07:00 |
Say Bye Once More:Validation is complete. |
Master.dtsx |
\Package\SayBye\Say Bye Once More |
None |
\Master\SayBye\Say Bye Once More |
| 2017-04-09 19:29:34.0304064 -07:00 |
Say Bye Once More:Information: And bye again! |
Master.dtsx |
\Package\SayBye\Say Bye Once More |
None |
\Master\SayBye\Say Bye Once More |
| 2017-04-09 19:29:34.0304064 -07:00 |
Say Bye Once More:Finished, 19:29:34, Elapsed time: 00:00:00.000. |
Master.dtsx |
\Package\SayBye\Say Bye Once More |
None |
\Master\SayBye\Say Bye Once More |
| 2017-04-09 19:29:33.9993566 -07:00 |
SQL Task B:Finished, 19:29:33, Elapsed time: 00:00:53.078. |
Master.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Load Results[5]\SQL Task B |
