| 2017-04-08 17:11:19.5462503 -07:00 |
Handle Error:Validation has started. |
Master.dtsx |
\Package\Handle Error |
None |
\Master\Handle Error |
| 2017-04-08 17:11:20.9843031 -07:00 |
Child:Start, 17:11:20. |
Child.dtsx |
\Package |
None |
\Master\Execute Child Package\Child |
| 2017-04-08 17:11:37.8338454 -07:00 |
Do Stuff:Validation has started. |
Master.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Load Results[1]\Do Stuff |
| 2017-04-08 17:11:19.5462503 -07:00 |
Handle Error:Validation is complete. |
Master.dtsx |
\Package\Handle Error |
None |
\Master\Handle Error |
| 2017-04-08 17:11:19.5462503 -07:00 |
Load Results:Validation has started. |
Master.dtsx |
\Package\Load Results |
None |
\Master\Load Results |
| 2017-04-08 17:11:19.5153069 -07:00 |
Master:Validation has started. |
Master.dtsx |
\Package |
None |
\Master |
| 2017-04-08 17:11:19.5312904 -07:00 |
Create Results Table:Validation has started. |
Master.dtsx |
\Package\Create Results Table |
None |
\Master\Create Results Table |
| 2017-04-08 17:11:19.5462503 -07:00 |
Create Results Table:Validation is complete. |
Master.dtsx |
\Package\Create Results Table |
None |
\Master\Create Results Table |
| 2017-04-08 17:11:19.5462503 -07:00 |
Drop Results Table:Validation has started. |
Master.dtsx |
\Package\Drop Results Table |
None |
\Master\Drop Results Table |
| 2017-04-08 17:11:19.5462503 -07:00 |
Drop Results Table:Validation is complete. |
Master.dtsx |
\Package\Drop Results Table |
None |
\Master\Drop Results Table |
| 2017-04-08 17:11:19.5462503 -07:00 |
Execute Child Package:Validation has started. |
Master.dtsx |
\Package\Execute Child Package |
None |
\Master\Execute Child Package |
| 2017-04-08 17:11:19.5462503 -07:00 |
Execute Child Package:Validation is complete. |
Master.dtsx |
\Package\Execute Child Package |
None |
\Master\Execute Child Package |
| 2017-04-08 17:11:19.5462503 -07:00 |
Do Stuff:Validation has started. |
Master.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Load Results\Do Stuff |
| 2017-04-08 17:11:19.5462503 -07:00 |
Do Stuff:Validation is complete. |
Master.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Load Results\Do Stuff |
| 2017-04-08 17:11:19.5462503 -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-08 17:11:19.5462503 -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-08 17:11:19.5462503 -07:00 |
Load Results:Validation is complete. |
Master.dtsx |
\Package\Load Results |
None |
\Master\Load Results |
| 2017-04-08 17:11:19.5462503 -07:00 |
SayBye:Validation has started. |
Master.dtsx |
\Package\SayBye |
None |
\Master\SayBye |
| 2017-04-08 17:11:19.5462503 -07:00 |
Say Bye:Validation has started. |
Master.dtsx |
\Package\SayBye\Say Bye |
None |
\Master\SayBye\Say Bye |
| 2017-04-08 17:11:19.5462503 -07:00 |
Say Bye:Validation is complete. |
Master.dtsx |
\Package\SayBye\Say Bye |
None |
\Master\SayBye\Say Bye |
| 2017-04-08 17:11:19.5462503 -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-08 17:11:19.5462503 -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-08 17:11:19.5462503 -07:00 |
SayBye:Validation is complete. |
Master.dtsx |
\Package\SayBye |
None |
\Master\SayBye |
| 2017-04-08 17:11:19.5462503 -07:00 |
SQL Task A:Validation has started. |
Master.dtsx |
\Package\SQL Task A |
None |
\Master\SQL Task A |
| 2017-04-08 17:11:19.5462503 -07:00 |
SQL Task A:Validation is complete. |
Master.dtsx |
\Package\SQL Task A |
None |
\Master\SQL Task A |
| 2017-04-08 17:11:19.5462503 -07:00 |
Write Message:Validation has started. |
Master.dtsx |
\Package\Write Message |
None |
\Master\Write Message |
| 2017-04-08 17:11:19.5462503 -07:00 |
Write Message:Validation is complete. |
Master.dtsx |
\Package\Write Message |
None |
\Master\Write Message |
| 2017-04-08 17:11:19.5462503 -07:00 |
Master:Validation is complete. |
Master.dtsx |
\Package |
None |
\Master |
| 2017-04-08 17:11:19.7188968 -07:00 |
Master:Start, 17:11:19. |
Master.dtsx |
\Package |
None |
\Master |
| 2017-04-08 17:11:19.7338358 -07:00 |
Create Results Table:Start, 17:11:19. |
Master.dtsx |
\Package\Create Results Table |
None |
\Master\Create Results Table |
| 2017-04-08 17:11:19.7338358 -07:00 |
Create Results Table:Validation has started. |
Master.dtsx |
\Package\Create Results Table |
None |
\Master\Create Results Table |
| 2017-04-08 17:11:19.7338358 -07:00 |
Create Results Table:Validation is complete. |
Master.dtsx |
\Package\Create Results Table |
None |
\Master\Create Results Table |
| 2017-04-08 17:11:19.8595166 -07:00 |
Create Results Table:Finished, 17:11:19, Elapsed time: 00:00:00.125. |
Master.dtsx |
\Package\Create Results Table |
None |
\Master\Create Results Table |
| 2017-04-08 17:11:19.8595166 -07:00 |
Write Message:Start, 17:11:19. |
Master.dtsx |
\Package\Write Message |
None |
\Master\Write Message |
| 2017-04-08 17:11:19.8595166 -07:00 |
Write Message:Validation has started. |
Master.dtsx |
\Package\Write Message |
None |
\Master\Write Message |
| 2017-04-08 17:11:19.8595166 -07:00 |
Write Message:Validation is complete. |
Master.dtsx |
\Package\Write Message |
None |
\Master\Write Message |
| 2017-04-08 17:11:19.7338358 -07:00 |
SQL Task A:Start, 17:11:19. |
Master.dtsx |
\Package\SQL Task A |
None |
\Master\SQL Task A |
| 2017-04-08 17:11:19.7338358 -07:00 |
SQL Task A:Validation has started. |
Master.dtsx |
\Package\SQL Task A |
None |
\Master\SQL Task A |
| 2017-04-08 17:11:19.7338358 -07:00 |
SQL Task A:Validation is complete. |
Master.dtsx |
\Package\SQL Task A |
None |
\Master\SQL Task A |
| 2017-04-08 17:11:20.9064870 -07:00 |
Write Message:Information: Hi there, this is Sample 1 |
Master.dtsx |
\Package\Write Message |
None |
\Master\Write Message |
| 2017-04-08 17:11:20.9064870 -07:00 |
Write Message:Finished, 17:11:20, Elapsed time: 00:00:01.047. |
Master.dtsx |
\Package\Write Message |
None |
\Master\Write Message |
| 2017-04-08 17:11:20.9064870 -07:00 |
Execute Child Package:Start, 17:11:20. |
Master.dtsx |
\Package\Execute Child Package |
None |
\Master\Execute Child Package |
| 2017-04-08 17:11:20.9064870 -07:00 |
Execute Child Package:Validation has started. |
Master.dtsx |
\Package\Execute Child Package |
None |
\Master\Execute Child Package |
| 2017-04-08 17:11:20.9064870 -07:00 |
Execute Child Package:Validation is complete. |
Master.dtsx |
\Package\Execute Child Package |
None |
\Master\Execute Child Package |
| 2017-04-08 17:11:20.9683248 -07:00 |
Child:Validation has started. |
Child.dtsx |
\Package |
None |
\Master\Execute Child Package\Child |
| 2017-04-08 17:11:20.9683248 -07:00 |
Call Grandchild:Validation has started. |
Child.dtsx |
\Package\Call Grandchild |
None |
\Master\Execute Child Package\Child\Call Grandchild |
| 2017-04-08 17:11:20.9683248 -07:00 |
Call Grandchild:Validation is complete. |
Child.dtsx |
\Package\Call Grandchild |
None |
\Master\Execute Child Package\Child\Call Grandchild |
| 2017-04-08 17:11:20.9683248 -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-08 17:11:20.9683248 -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-08 17:11:20.9683248 -07:00 |
Load Results:Validation has started. |
Child.dtsx |
\Package\Load Results |
None |
\Master\Execute Child Package\Child\Load Results |
| 2017-04-08 17:11:20.9683248 -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-08 17:11:20.9683248 -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-08 17:11:20.9683248 -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-08 17:11:20.9683248 -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-08 17:11:20.9683248 -07:00 |
Load Results:Validation is complete. |
Child.dtsx |
\Package\Load Results |
None |
\Master\Execute Child Package\Child\Load Results |
| 2017-04-08 17:11:20.9683248 -07:00 |
Child:Validation is complete. |
Child.dtsx |
\Package |
None |
\Master\Execute Child Package\Child |
| 2017-04-08 17:11:20.9683248 -07:00 |
Child:Validation has started. |
Child.dtsx |
\Package |
None |
\Master\Execute Child Package\Child |
| 2017-04-08 17:11:20.9683248 -07:00 |
Call Grandchild:Validation has started. |
Child.dtsx |
\Package\Call Grandchild |
None |
\Master\Execute Child Package\Child\Call Grandchild |
| 2017-04-08 17:11:20.9683248 -07:00 |
Call Grandchild:Validation is complete. |
Child.dtsx |
\Package\Call Grandchild |
None |
\Master\Execute Child Package\Child\Call Grandchild |
| 2017-04-08 17:11:20.9843031 -07:00 |
Create Results Table:Start, 17:11:20. |
Child.dtsx |
\Package\Create Results Table |
None |
\Master\Execute Child Package\Child\Create Results Table |
| 2017-04-08 17:11:20.9843031 -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-08 17:11:20.9843031 -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-08 17:11:20.9843031 -07:00 |
Create Results Table:Finished, 17:11:20, Elapsed time: 00:00:00.000. |
Child.dtsx |
\Package\Create Results Table |
None |
\Master\Execute Child Package\Child\Create Results Table |
| 2017-04-08 17:11:20.9843031 -07:00 |
Call Grandchild:Start, 17:11:20. |
Child.dtsx |
\Package\Call Grandchild |
None |
\Master\Execute Child Package\Child\Call Grandchild |
| 2017-04-08 17:11:20.9843031 -07:00 |
Call Grandchild:Validation has started. |
Child.dtsx |
\Package\Call Grandchild |
None |
\Master\Execute Child Package\Child\Call Grandchild |
| 2017-04-08 17:11:20.9843031 -07:00 |
Call Grandchild:Validation is complete. |
Child.dtsx |
\Package\Call Grandchild |
None |
\Master\Execute Child Package\Child\Call Grandchild |
| 2017-04-08 17:11:21.0152474 -07:00 |
Grandchild:Validation has started. |
Grandchild.dtsx |
\Package |
None |
\Master\Execute Child Package\Child\Call Grandchild\Grandchild |
| 2017-04-08 17:11:21.0152474 -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-08 17:11:21.0152474 -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-08 17:11:21.0152474 -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-08 17:11:21.0152474 -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-08 17:11:21.0152474 -07:00 |
Grandchild:Validation is complete. |
Grandchild.dtsx |
\Package |
None |
\Master\Execute Child Package\Child\Call Grandchild\Grandchild |
| 2017-04-08 17:11:21.0152474 -07:00 |
Grandchild:Validation has started. |
Grandchild.dtsx |
\Package |
None |
\Master\Execute Child Package\Child\Call Grandchild\Grandchild |
| 2017-04-08 17:11:21.0152474 -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-08 17:11:21.0152474 -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-08 17:11:21.0152474 -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-08 17:11:21.0152474 -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-08 17:11:21.0152474 -07:00 |
Grandchild:Validation is complete. |
Grandchild.dtsx |
\Package |
None |
\Master\Execute Child Package\Child\Call Grandchild\Grandchild |
| 2017-04-08 17:11:20.9843031 -07:00 |
Load Results:Start, 17:11:20. |
Child.dtsx |
\Package\Load Results |
None |
\Master\Execute Child Package\Child\Load Results |
| 2017-04-08 17:11:20.9843031 -07:00 |
Load Child Results Table:Start, 17:11:20. |
Child.dtsx |
\Package\Load Results\Load Child Results Table |
None |
\Master\Execute Child Package\Child\Load Results[1]\Load Child Results Table |
| 2017-04-08 17:11:20.9843031 -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-08 17:11:20.9993714 -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-08 17:11:21.0775178 -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-08 17:11:21.0775178 -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-08 17:11:21.0932756 -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-08 17:11:21.0932756 -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-08 17:11:37.8338454 -07:00 |
Do Stuff:Start, 17:11:37. |
Master.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Load Results[1]\Do Stuff |
| 2017-04-08 17:11:21.0932756 -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-08 17:11:21.0932756 -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-08 17:11:21.1088492 -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-08 17:11:21.2964654 -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-08 17:11:21.2964654 -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-08 17:11:21.2964654 -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-08 17:11:21.2964654 -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-08 17:11:21.2964654 -07:00 |
Load Child Results Table:Information: The Lookup B processed 55 rows in the cache. The processing time was 0.172 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-08 17:11:21.3124288 -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-08 17:11:21.3124288 -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-08 17:11:21.3124288 -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-08 17:11:21.3124288 -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-08 17:11:21.0152474 -07:00 |
Grandchild:Start, 17:11:21. |
Grandchild.dtsx |
\Package |
None |
\Master\Execute Child Package\Child\Call Grandchild\Grandchild |
| 2017-04-08 17:11:20.9683248 -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-08 17:11:20.9683248 -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-08 17:11:20.9683248 -07:00 |
Load Results:Validation has started. |
Child.dtsx |
\Package\Load Results |
None |
\Master\Execute Child Package\Child\Load Results |
| 2017-04-08 17:11:20.9683248 -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-08 17:11:20.9683248 -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-08 17:11:20.9683248 -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-08 17:11:20.9683248 -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-08 17:11:20.9683248 -07:00 |
Load Results:Validation is complete. |
Child.dtsx |
\Package\Load Results |
None |
\Master\Execute Child Package\Child\Load Results |
| 2017-04-08 17:11:20.9683248 -07:00 |
Child:Validation is complete. |
Child.dtsx |
\Package |
None |
\Master\Execute Child Package\Child |
| 2017-04-08 17:11:21.0152474 -07:00 |
Do Something:Start, 17:11:21. |
Grandchild.dtsx |
\Package\Do Something |
None |
\Master\Execute Child Package\Child\Call Grandchild\Grandchild\Do Something |
| 2017-04-08 17:11:21.0152474 -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-08 17:11:21.0152474 -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-08 17:11:37.8338454 -07:00 |
Do Stuff:Validation is complete. |
Master.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Load Results[1]\Do Stuff |
| 2017-04-08 17:11:21.0312057 -07:00 |
Do Something:Finished, 17:11:21, Elapsed time: 00:00:00.015. |
Grandchild.dtsx |
\Package\Do Something |
None |
\Master\Execute Child Package\Child\Call Grandchild\Grandchild\Do Something |
| 2017-04-08 17:11:21.0312057 -07:00 |
Play with Username:Start, 17:11:21. |
Grandchild.dtsx |
\Package\Play with Username |
None |
\Master\Execute Child Package\Child\Call Grandchild\Grandchild\Play with Username |
| 2017-04-08 17:11:21.0312057 -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-08 17:11:21.0312057 -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-08 17:11:21.0312057 -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-08 17:11:50.9588353 -07:00 |
Do Stuff:Start, 17:11:50. |
Master.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Load Results[2]\Do Stuff |
| 2017-04-08 17:11:21.4688766 -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-08 17:11:21.4688766 -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-08 17:11:21.4688766 -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-08 17:11:21.4688766 -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-08 17:11:21.3124288 -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[1]\Load Child Results Table |
| 2017-04-08 17:11:21.4526187 -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-08 17:11:21.4526187 -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-08 17:11:21.4526187 -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-08 17:11:21.4526187 -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-08 17:11:21.4526187 -07:00 |
Load Child Results Table:Information: The Lookup A processed 1505 rows in the cache. The processing time was 0.016 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-08 17:11:21.4526187 -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-08 17:11:21.4688766 -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-08 17:11:21.4688766 -07:00 |
Load Child Results Table:Information: "DST - Bad" wrote 483 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-08 17:11:21.4838444 -07:00 |
Load Child Results Table:Information: "DST - Good" wrote 139 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-08 17:11:21.4838444 -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-08 17:11:21.4838444 -07:00 |
Load Child Results Table:Finished, 17:11:21, Elapsed time: 00:00:00.500. |
Child.dtsx |
\Package\Load Results\Load Child Results Table |
None |
\Master\Execute Child Package\Child\Load Results[1]\Load Child Results Table |
| 2017-04-08 17:11:21.4838444 -07:00 |
Do Stuff:Start, 17:11:21. |
Child.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Execute Child Package\Child\Load Results[1]\Do Stuff |
| 2017-04-08 17:11:21.4838444 -07:00 |
SQL Task B:Start, 17:11:21. |
Child.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Execute Child Package\Child\Load Results[1]\SQL Task B |
| 2017-04-08 17:11:21.4838444 -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-08 17:11:21.4838444 -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-08 17:11:21.4838444 -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-08 17:11:21.4838444 -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-08 17:11:21.4838444 -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-08 17:11:21.4838444 -07:00 |
Do Stuff:Finished, 17:11:21, Elapsed time: 00:00:00.000. |
Child.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Execute Child Package\Child\Load Results[1]\Do Stuff |
| 2017-04-08 17:11:21.8745295 -07:00 |
SQL Task A:Finished, 17:11:21, Elapsed time: 00:00:02.141. |
Master.dtsx |
\Package\SQL Task A |
None |
\Master\SQL Task A |
| 2017-04-08 17:11:22.5001633 -07:00 |
Load Child Results Table:Start, 17:11:22. |
Child.dtsx |
\Package\Load Results\Load Child Results Table |
None |
\Master\Execute Child Package\Child\Load Results[2]\Load Child Results Table |
| 2017-04-08 17:11:22.5001633 -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-08 17:11:22.5151297 -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-08 17:11:22.6244790 -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-08 17:11:22.6244790 -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-08 17:11:22.6244790 -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-08 17:11:22.6244790 -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-08 17:11:22.6244790 -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-08 17:11:22.6556252 -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-08 17:11:22.6877618 -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-08 17:11:22.6877618 -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-08 17:11:22.6877618 -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-08 17:11:22.6877618 -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[2]\Load Child Results Table |
| 2017-04-08 17:11:22.7026799 -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-08 17:11:22.7026799 -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-08 17:11:22.7026799 -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-08 17:11:22.7026799 -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[2]\Load Child Results Table |
| 2017-04-08 17:11:22.7652234 -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-08 17:11:22.7652234 -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-08 17:11:22.7652234 -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-08 17:11:22.5001633 -07:00 |
SQL Task B:Finished, 17:11:22, 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-08 17:11:22.7962565 -07:00 |
SQL Task B:Start, 17:11:22. |
Child.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Execute Child Package\Child\Load Results[2]\SQL Task B |
| 2017-04-08 17:11:22.7962565 -07:00 |
Do Stuff:Start, 17:11:22. |
Child.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Execute Child Package\Child\Load Results[2]\Do Stuff |
| 2017-04-08 17:11:22.7962565 -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-08 17:11:22.7962565 -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-08 17:11:22.7962565 -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-08 17:11:22.7962565 -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-08 17:11:22.7962565 -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-08 17:11:22.7962565 -07:00 |
Do Stuff:Finished, 17:11:22, 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-08 17:11:22.7808035 -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-08 17:11:22.7808035 -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-08 17:11:22.7808035 -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-08 17:11:22.7808035 -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-08 17:11:22.7652234 -07:00 |
Load Child Results Table:Information: The Lookup A processed 1505 rows in the cache. The processing time was 0.016 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-08 17:11:22.7652234 -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-08 17:11:22.7808035 -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-08 17:11:22.7962565 -07:00 |
Load Child Results Table:Information: "DST - Bad" wrote 0 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-08 17:11:22.7962565 -07:00 |
Load Child Results Table:Information: "DST - Good" wrote 0 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-08 17:11:22.7962565 -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-08 17:11:22.7962565 -07:00 |
Load Child Results Table:Finished, 17:11:22, Elapsed time: 00:00:00.297. |
Child.dtsx |
\Package\Load Results\Load Child Results Table |
None |
\Master\Execute Child Package\Child\Load Results[2]\Load Child Results Table |
| 2017-04-08 17:11:24.8275446 -07:00 |
Load Child Results Table:Start, 17:11:24. |
Child.dtsx |
\Package\Load Results\Load Child Results Table |
None |
\Master\Execute Child Package\Child\Load Results[3]\Load Child Results Table |
| 2017-04-08 17:11:24.8275446 -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-08 17:11:24.8275446 -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-08 17:11:24.8275446 -07:00 |
SQL Task B:Finished, 17:11:24, 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-08 17:11:24.9056352 -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-08 17:11:24.9056352 -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-08 17:11:24.9056352 -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-08 17:11:24.9056352 -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-08 17:11:24.9056352 -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-08 17:11:24.9526108 -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-08 17:11:24.9838998 -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-08 17:11:24.9838998 -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-08 17:11:24.9838998 -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-08 17:11:24.9838998 -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[3]\Load Child Results Table |
| 2017-04-08 17:11:25.0158261 -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-08 17:11:25.0158261 -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-08 17:11:25.0158261 -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-08 17:11:25.0158261 -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-08 17:11:25.0775076 -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-08 17:11:25.0775076 -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-08 17:11:25.0775076 -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-08 17:11:25.0775076 -07:00 |
Load Child Results Table:Information: The Lookup A processed 1505 rows in the cache. The processing time was 0.016 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-08 17:11:25.0775076 -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-08 17:11:25.0931347 -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-08 17:11:25.0931347 -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-08 17:11:25.0931347 -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-08 17:11:25.1091604 -07:00 |
Do Stuff:Start, 17:11:25. |
Child.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Execute Child Package\Child\Load Results[3]\Do Stuff |
| 2017-04-08 17:11:25.1091604 -07:00 |
SQL Task B:Start, 17:11:25. |
Child.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Execute Child Package\Child\Load Results[3]\SQL Task B |
| 2017-04-08 17:11:25.1091604 -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-08 17:11:25.1091604 -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-08 17:11:25.1091604 -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-08 17:11:25.1091604 -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-08 17:11:25.1250727 -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-08 17:11:25.1250727 -07:00 |
Do Stuff:Finished, 17:11:25, Elapsed time: 00:00:00.016. |
Child.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Execute Child Package\Child\Load Results[3]\Do Stuff |
| 2017-04-08 17:11:25.0931347 -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-08 17:11:25.0931347 -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-08 17:11:25.1091604 -07:00 |
Load Child Results Table:Information: "DST - Bad" wrote 953 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-08 17:11:25.1091604 -07:00 |
Load Child Results Table:Information: "DST - Good" wrote 291 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-08 17:11:25.1091604 -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-08 17:11:25.1091604 -07:00 |
Load Child Results Table:Finished, 17:11:25, Elapsed time: 00:00:00.281. |
Child.dtsx |
\Package\Load Results\Load Child Results Table |
None |
\Master\Execute Child Package\Child\Load Results[3]\Load Child Results Table |
| 2017-04-08 17:11:26.0462521 -07:00 |
Call Grandchild:Finished, 17:11:26, Elapsed time: 00:00:05.063. |
Child.dtsx |
\Package\Call Grandchild |
None |
\Master\Execute Child Package\Child\Call Grandchild |
| 2017-04-08 17:11:26.0462521 -07:00 |
Grandchild:Finished, 17:11:26, Elapsed time: 00:00:05.031. |
Grandchild.dtsx |
\Package |
None |
\Master\Execute Child Package\Child\Call Grandchild\Grandchild |
| 2017-04-08 17:11:26.0462521 -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-08 17:11:26.0462521 -07:00 |
Play with Username:Finished, 17:11:26, Elapsed time: 00:00:05.016. |
Grandchild.dtsx |
\Package\Play with Username |
None |
\Master\Execute Child Package\Child\Call Grandchild\Grandchild\Play with Username |
| 2017-04-08 17:11:28.1466413 -07:00 |
Load Child Results Table:Start, 17:11:28. |
Child.dtsx |
\Package\Load Results\Load Child Results Table |
None |
\Master\Execute Child Package\Child\Load Results[4]\Load Child Results Table |
| 2017-04-08 17:11:28.1466413 -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-08 17:11:28.1466413 -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-08 17:11:28.2400072 -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-08 17:11:28.2400072 -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-08 17:11:28.2400072 -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-08 17:11:28.2400072 -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-08 17:11:28.2400072 -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-08 17:11:28.2711999 -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-08 17:11:28.2868321 -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[4]\Load Child Results Table |
| 2017-04-08 17:11:28.2868321 -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-08 17:11:28.2868321 -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-08 17:11:28.3024954 -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-08 17:11:28.3024954 -07:00 |
Load Child Results Table:Information: The Lookup B processed 55 rows in the cache. The processing time was 0.016 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-08 17:11:28.3180518 -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[4]\Load Child Results Table |
| 2017-04-08 17:11:28.3180518 -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-08 17:11:28.3180518 -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-08 17:11:28.3180518 -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-08 17:11:28.3180518 -07:00 |
Load Child Results Table:Information: The Lookup C processed 505 rows in the cache. The processing time was 0.015 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-08 17:11:28.3658876 -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[4]\Load Child Results Table |
| 2017-04-08 17:11:28.3806312 -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-08 17:11:28.3806312 -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-08 17:11:28.3963154 -07:00 |
SQL Task B:Start, 17:11:28. |
Child.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Execute Child Package\Child\Load Results[4]\SQL Task B |
| 2017-04-08 17:11:28.3963154 -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-08 17:11:28.3963154 -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-08 17:11:28.1466413 -07:00 |
SQL Task B:Finished, 17:11:28, 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-08 17:11:28.3963154 -07:00 |
Do Stuff:Start, 17:11:28. |
Child.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Execute Child Package\Child\Load Results[4]\Do Stuff |
| 2017-04-08 17:11:28.3963154 -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-08 17:11:28.3963154 -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-08 17:11:28.3963154 -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-08 17:11:28.3963154 -07:00 |
Do Stuff:Finished, 17:11:28, 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-08 17:11:28.3658876 -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-08 17:11:28.3658876 -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-08 17:11:28.3658876 -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-08 17:11:28.3658876 -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[4]\Load Child Results Table |
| 2017-04-08 17:11:28.3658876 -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-08 17:11:28.3806312 -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-08 17:11:28.3806312 -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-08 17:11:28.3806312 -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-08 17:11:28.3963154 -07:00 |
Load Child Results Table:Information: "DST - Bad" wrote 806 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-08 17:11:28.3963154 -07:00 |
Load Child Results Table:Information: "DST - Good" wrote 216 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-08 17:11:28.3963154 -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-08 17:11:28.3963154 -07:00 |
Load Child Results Table:Finished, 17:11:28, 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-08 17:11:32.4275281 -07:00 |
Load Child Results Table:Start, 17:11:32. |
Child.dtsx |
\Package\Load Results\Load Child Results Table |
None |
\Master\Execute Child Package\Child\Load Results[5]\Load Child Results Table |
| 2017-04-08 17:11:32.4275281 -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-08 17:11:32.4275281 -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-08 17:11:32.5056578 -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-08 17:11:32.4275281 -07:00 |
SQL Task B:Finished, 17:11:32, 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-08 17:11:32.5213635 -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-08 17:11:32.5213635 -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-08 17:11:32.5213635 -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-08 17:11:32.5213635 -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-08 17:11:32.5528046 -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-08 17:11:32.5837158 -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-08 17:11:32.5837158 -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-08 17:11:32.5837158 -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-08 17:11:32.5837158 -07:00 |
Load Child Results Table:Information: The Lookup B processed 55 rows in the cache. The processing time was 0.016 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-08 17:11:32.5993145 -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-08 17:11:32.5993145 -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-08 17:11:32.5993145 -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-08 17:11:32.5993145 -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-08 17:11:32.6466855 -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-08 17:11:32.6466855 -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-08 17:11:32.6466855 -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-08 17:11:32.6466855 -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[5]\Load Child Results Table |
| 2017-04-08 17:11:32.6620902 -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-08 17:11:32.6620902 -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-08 17:11:32.6775070 -07:00 |
Load Child Results Table:Information: "DST - Bad" wrote 1281 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-08 17:11:32.6930740 -07:00 |
SQL Task B:Start, 17:11:32. |
Child.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Execute Child Package\Child\Load Results[5]\SQL Task B |
| 2017-04-08 17:11:32.6930740 -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-08 17:11:32.6930740 -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-08 17:11:32.6620902 -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-08 17:11:32.6620902 -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-08 17:11:32.6775070 -07:00 |
Do Stuff:Start, 17:11:32. |
Child.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Execute Child Package\Child\Load Results[5]\Do Stuff |
| 2017-04-08 17:11:32.6930740 -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-08 17:11:32.6930740 -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-08 17:11:32.6930740 -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-08 17:11:32.6930740 -07:00 |
Do Stuff:Finished, 17:11:32, Elapsed time: 00:00:00.015. |
Child.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Execute Child Package\Child\Load Results[5]\Do Stuff |
| 2017-04-08 17:11:32.6620902 -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-08 17:11:32.6620902 -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-08 17:11:32.6775070 -07:00 |
Load Child Results Table:Information: "DST - Good" wrote 363 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-08 17:11:32.6775070 -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-08 17:11:32.6775070 -07:00 |
Load Child Results Table:Finished, 17:11:32, Elapsed time: 00:00:00.250. |
Child.dtsx |
\Package\Load Results\Load Child Results Table |
None |
\Master\Execute Child Package\Child\Load Results[5]\Load Child Results Table |
| 2017-04-08 17:11:37.7250706 -07:00 |
Load Results:Finished, 17:11:37, Elapsed time: 00:00:16.735. |
Child.dtsx |
\Package\Load Results |
None |
\Master\Execute Child Package\Child\Load Results |
| 2017-04-08 17:11:37.7250706 -07:00 |
Child:Finished, 17:11:37, Elapsed time: 00:00:16.750. |
Child.dtsx |
\Package |
None |
\Master\Execute Child Package\Child |
| 2017-04-08 17:11:37.7250706 -07:00 |
SQL Task B:Finished, 17:11:37, Elapsed time: 00:00:05.047. |
Child.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Execute Child Package\Child\Load Results[5]\SQL Task B |
| 2017-04-08 17:11:37.7250706 -07:00 |
Execute Child Package:Finished, 17:11:37, Elapsed time: 00:00:16.813. |
Master.dtsx |
\Package\Execute Child Package |
None |
\Master\Execute Child Package |
| 2017-04-08 17:11:37.7250706 -07:00 |
Load Results:Start, 17:11:37. |
Master.dtsx |
\Package\Load Results |
None |
\Master\Load Results |
| 2017-04-08 17:11:37.7250706 -07:00 |
Load Master Result Table:Start, 17:11:37. |
Master.dtsx |
\Package\Load Results\Load Master Result Table |
None |
\Master\Load Results[1]\Load Master Result Table |
| 2017-04-08 17:11:37.7250706 -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-08 17:11:37.7250706 -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-08 17:11:37.7557208 -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-08 17:11:37.7557208 -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-08 17:11:37.7557208 -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-08 17:11:37.7711990 -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-08 17:11:37.8184277 -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-08 17:11:37.8184277 -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-08 17:11:37.8184277 -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-08 17:11:37.8184277 -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-08 17:11:37.8184277 -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-08 17:11:37.8184277 -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-08 17:11:37.8184277 -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-08 17:11:37.8184277 -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-08 17:11:37.8184277 -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-08 17:11:37.8184277 -07:00 |
Load Master Result Table:Information: "DST - Bad" wrote 1766 rows.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
SSIS.Pipeline |
\Master\Load Results[1]\Load Master Result Table |
| 2017-04-08 17:11:37.8184277 -07:00 |
Load Master Result Table:Information: "DST - Good" wrote 500 rows.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
SSIS.Pipeline |
\Master\Load Results[1]\Load Master Result Table |
| 2017-04-08 17:11:37.8184277 -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-08 17:11:37.8184277 -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-08 17:11:37.8338454 -07:00 |
Do Stuff:Finished, 17:11:37, Elapsed time: 00:00:00.000. |
Master.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Load Results[1]\Do Stuff |
| 2017-04-08 17:11:37.8184277 -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-08 17:11:37.8338454 -07:00 |
Load Master Result Table:Finished, 17:11:37, Elapsed time: 00:00:00.109. |
Master.dtsx |
\Package\Load Results\Load Master Result Table |
None |
\Master\Load Results[1]\Load Master Result Table |
| 2017-04-08 17:11:37.8338454 -07:00 |
SQL Task B:Start, 17:11:37. |
Master.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Load Results[1]\SQL Task B |
| 2017-04-08 17:11:37.8338454 -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-08 17:11:37.8338454 -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-08 17:11:50.8655117 -07:00 |
Load Master Result Table:Start, 17:11:50. |
Master.dtsx |
\Package\Load Results\Load Master Result Table |
None |
\Master\Load Results[2]\Load Master Result Table |
| 2017-04-08 17:11:50.8655117 -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-08 17:11:50.8655117 -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-08 17:11:50.8962382 -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-08 17:11:50.8962382 -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-08 17:11:50.8962382 -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-08 17:11:50.8655117 -07:00 |
SQL Task B:Finished, 17:11:50, Elapsed time: 00:00:13.031. |
Master.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Load Results[1]\SQL Task B |
| 2017-04-08 17:11:50.9588353 -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-08 17:11:50.9588353 -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-08 17:11:50.9588353 -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-08 17:11:50.9588353 -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-08 17:11:50.9119378 -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-08 17:11:50.9588353 -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-08 17:11:50.9588353 -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-08 17:11:50.9588353 -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-08 17:11:50.9588353 -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-08 17:11:50.9588353 -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-08 17:11:50.9588353 -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-08 17:11:50.9588353 -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-08 17:11:50.9588353 -07:00 |
Load Master Result Table:Information: "DST - Bad" wrote 1452 rows.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
SSIS.Pipeline |
\Master\Load Results[2]\Load Master Result Table |
| 2017-04-08 17:11:50.9588353 -07:00 |
Load Master Result Table:Information: "DST - Good" wrote 414 rows.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
SSIS.Pipeline |
\Master\Load Results[2]\Load Master Result Table |
| 2017-04-08 17:11:50.9588353 -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-08 17:11:50.9588353 -07:00 |
Load Master Result Table:Finished, 17:11:50, Elapsed time: 00:00:00.094. |
Master.dtsx |
\Package\Load Results\Load Master Result Table |
None |
\Master\Load Results[2]\Load Master Result Table |
| 2017-04-08 17:11:50.9588353 -07:00 |
SQL Task B:Start, 17:11:50. |
Master.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Load Results[2]\SQL Task B |
| 2017-04-08 17:11:50.9588353 -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-08 17:11:50.9588353 -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-08 17:11:50.9588353 -07:00 |
Do Stuff:Validation has started. |
Master.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Load Results[2]\Do Stuff |
| 2017-04-08 17:11:50.9588353 -07:00 |
Do Stuff:Validation is complete. |
Master.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Load Results[2]\Do Stuff |
| 2017-04-08 17:11:50.9588353 -07:00 |
Do Stuff:Finished, 17:11:50, Elapsed time: 00:00:00.000. |
Master.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Load Results[2]\Do Stuff |
| 2017-04-08 17:12:14.0841662 -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-08 17:12:14.0841662 -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-08 17:12:13.9908831 -07:00 |
Load Master Result Table:Start, 17:12:13. |
Master.dtsx |
\Package\Load Results\Load Master Result Table |
None |
\Master\Load Results[3]\Load Master Result Table |
| 2017-04-08 17:12:13.9908831 -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-08 17:12:13.9908831 -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-08 17:12:47.4435362 -07:00 |
Do Stuff:Validation is complete. |
Master.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Load Results[4]\Do Stuff |
| 2017-04-08 17:12:14.0214816 -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-08 17:12:14.0214816 -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-08 17:12:14.0214816 -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-08 17:12:14.0369221 -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-08 17:12:14.0841662 -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-08 17:12:14.0841662 -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-08 17:12:14.0841662 -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-08 17:12:14.0841662 -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-08 17:12:14.0841662 -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[3]\Load Master Result Table |
| 2017-04-08 17:12:14.0841662 -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-08 17:12:14.0841662 -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-08 17:12:14.0841662 -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-08 17:12:14.0841662 -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-08 17:12:14.0841662 -07:00 |
Load Master Result Table:Information: "DST - Bad" wrote 785 rows.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
SSIS.Pipeline |
\Master\Load Results[3]\Load Master Result Table |
| 2017-04-08 17:12:14.0841662 -07:00 |
Load Master Result Table:Information: "DST - Good" wrote 237 rows.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
SSIS.Pipeline |
\Master\Load Results[3]\Load Master Result Table |
| 2017-04-08 17:12:14.0841662 -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-08 17:12:14.0841662 -07:00 |
Load Master Result Table:Finished, 17:12:14, Elapsed time: 00:00:00.094. |
Master.dtsx |
\Package\Load Results\Load Master Result Table |
None |
\Master\Load Results[3]\Load Master Result Table |
| 2017-04-08 17:12:13.9908831 -07:00 |
SQL Task B:Finished, 17:12:13, Elapsed time: 00:00:23.031. |
Master.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Load Results[2]\SQL Task B |
| 2017-04-08 17:12:14.0841662 -07:00 |
SQL Task B:Start, 17:12:14. |
Master.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Load Results[3]\SQL Task B |
| 2017-04-08 17:12:14.0841662 -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-08 17:12:14.0841662 -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-08 17:12:14.0841662 -07:00 |
Do Stuff:Start, 17:12:14. |
Master.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Load Results[3]\Do Stuff |
| 2017-04-08 17:12:14.0841662 -07:00 |
Do Stuff:Validation has started. |
Master.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Load Results[3]\Do Stuff |
| 2017-04-08 17:12:14.0841662 -07:00 |
Do Stuff:Validation is complete. |
Master.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Load Results[3]\Do Stuff |
| 2017-04-08 17:12:14.0841662 -07:00 |
Do Stuff:Finished, 17:12:14, Elapsed time: 00:00:00.000. |
Master.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Load Results[3]\Do Stuff |
| 2017-04-08 17:12:47.1159027 -07:00 |
Load Master Result Table:Start, 17:12:47. |
Master.dtsx |
\Package\Load Results\Load Master Result Table |
None |
\Master\Load Results[4]\Load Master Result Table |
| 2017-04-08 17:12:47.1159027 -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-08 17:12:47.1159027 -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-08 17:12:47.1159027 -07:00 |
SQL Task B:Finished, 17:12:47, Elapsed time: 00:00:33.031. |
Master.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Load Results[3]\SQL Task B |
| 2017-04-08 17:12:47.2088504 -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-08 17:12:47.2088504 -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-08 17:12:47.2088504 -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-08 17:12:47.2246631 -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-08 17:12:47.4277738 -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-08 17:12:47.4277738 -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-08 17:12:47.4277738 -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-08 17:12:47.4277738 -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-08 17:12:47.4277738 -07:00 |
Load Master Result Table:Information: The Lookup processed 505 rows in the cache. The processing time was 0.001 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-08 17:12:47.4277738 -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-08 17:12:47.4435362 -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-08 17:12:47.4435362 -07:00 |
Load Master Result Table:Information: "DST - Bad" wrote 1276 rows.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
SSIS.Pipeline |
\Master\Load Results[4]\Load Master Result Table |
| 2017-04-08 17:12:47.4435362 -07:00 |
Load Master Result Table:Information: "DST - Good" wrote 368 rows.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
SSIS.Pipeline |
\Master\Load Results[4]\Load Master Result Table |
| 2017-04-08 17:12:47.4435362 -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-08 17:12:47.4435362 -07:00 |
Load Master Result Table:Finished, 17:12:47, Elapsed time: 00:00:00.328. |
Master.dtsx |
\Package\Load Results\Load Master Result Table |
None |
\Master\Load Results[4]\Load Master Result Table |
| 2017-04-08 17:12:47.4277738 -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-08 17:12:47.4277738 -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-08 17:12:47.4435362 -07:00 |
SQL Task B:Start, 17:12:47. |
Master.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Load Results[4]\SQL Task B |
| 2017-04-08 17:12:47.4435362 -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-08 17:12:47.4435362 -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-08 17:12:47.4435362 -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-08 17:12:47.4435362 -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-08 17:12:47.4435362 -07:00 |
Do Stuff:Start, 17:12:47. |
Master.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Load Results[4]\Do Stuff |
| 2017-04-08 17:12:47.4435362 -07:00 |
Do Stuff:Validation has started. |
Master.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Load Results[4]\Do Stuff |
| 2017-04-08 17:12:47.4435362 -07:00 |
Do Stuff:Finished, 17:12:47, Elapsed time: 00:00:00.000. |
Master.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Load Results[4]\Do Stuff |
| 2017-04-08 17:13:30.4590595 -07:00 |
Load Master Result Table:Start, 17:13:30. |
Master.dtsx |
\Package\Load Results\Load Master Result Table |
None |
\Master\Load Results[5]\Load Master Result Table |
| 2017-04-08 17:13:30.4590595 -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-08 17:13:30.4590595 -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-08 17:13:30.5216775 -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-08 17:13:30.5216775 -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-08 17:13:30.5216775 -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-08 17:13:30.5374074 -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-08 17:13:30.4590595 -07:00 |
SQL Task B:Finished, 17:13:30, Elapsed time: 00:00:43.016. |
Master.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Load Results[4]\SQL Task B |
| 2017-04-08 17:13:30.7563912 -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-08 17:13:30.7563912 -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-08 17:13:30.7563912 -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-08 17:13:30.7563912 -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-08 17:13:30.7403999 -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-08 17:13:30.7403999 -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-08 17:13:30.7403999 -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-08 17:13:30.7403999 -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-08 17:13:30.7403999 -07:00 |
Load Master Result Table:Information: The Lookup processed 505 rows in the cache. The processing time was 0.001 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-08 17:13:30.7403999 -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-08 17:13:30.7563912 -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-08 17:13:30.7563912 -07:00 |
Load Master Result Table:Information: "DST - Bad" wrote 472 rows.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
SSIS.Pipeline |
\Master\Load Results[5]\Load Master Result Table |
| 2017-04-08 17:13:30.7563912 -07:00 |
Load Master Result Table:Information: "DST - Good" wrote 150 rows.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
SSIS.Pipeline |
\Master\Load Results[5]\Load Master Result Table |
| 2017-04-08 17:13:30.7563912 -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-08 17:13:30.7563912 -07:00 |
Load Master Result Table:Finished, 17:13:30, Elapsed time: 00:00:00.297. |
Master.dtsx |
\Package\Load Results\Load Master Result Table |
None |
\Master\Load Results[5]\Load Master Result Table |
| 2017-04-08 17:13:30.7563912 -07:00 |
SQL Task B:Start, 17:13:30. |
Master.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Load Results[5]\SQL Task B |
| 2017-04-08 17:13:30.7563912 -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-08 17:13:30.7563912 -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-08 17:13:30.7563912 -07:00 |
Do Stuff:Start, 17:13:30. |
Master.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Load Results[5]\Do Stuff |
| 2017-04-08 17:13:30.7563912 -07:00 |
Do Stuff:Validation has started. |
Master.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Load Results[5]\Do Stuff |
| 2017-04-08 17:13:30.7563912 -07:00 |
Do Stuff:Validation is complete. |
Master.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Load Results[5]\Do Stuff |
| 2017-04-08 17:13:30.7563912 -07:00 |
Do Stuff:Finished, 17:13:30, Elapsed time: 00:00:00.000. |
Master.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Load Results[5]\Do Stuff |
| 2017-04-08 17:14:23.7718545 -07:00 |
Load Results:Finished, 17:14:23, Elapsed time: 00:02:46.047. |
Master.dtsx |
\Package\Load Results |
None |
\Master\Load Results |
| 2017-04-08 17:14:23.7877617 -07:00 |
Say Bye:Start, 17:14:23. |
Master.dtsx |
\Package\SayBye\Say Bye |
None |
\Master\SayBye\Say Bye |
| 2017-04-08 17:14:23.7877617 -07:00 |
Say Bye:Validation has started. |
Master.dtsx |
\Package\SayBye\Say Bye |
None |
\Master\SayBye\Say Bye |
| 2017-04-08 17:14:23.7877617 -07:00 |
Say Bye:Validation is complete. |
Master.dtsx |
\Package\SayBye\Say Bye |
None |
\Master\SayBye\Say Bye |
| 2017-04-08 17:14:23.7877617 -07:00 |
Say Bye:Information: Package executed, bye! |
Master.dtsx |
\Package\SayBye\Say Bye |
None |
\Master\SayBye\Say Bye |
| 2017-04-08 17:14:23.7877617 -07:00 |
Say Bye:Finished, 17:14:23, Elapsed time: 00:00:00.000. |
Master.dtsx |
\Package\SayBye\Say Bye |
None |
\Master\SayBye\Say Bye |
| 2017-04-08 17:14:23.7877617 -07:00 |
SayBye:Finished, 17:14:23, Elapsed time: 00:00:00.000. |
Master.dtsx |
\Package\SayBye |
None |
\Master\SayBye |
| 2017-04-08 17:14:23.7877617 -07:00 |
Master:Finished, 17:14:23, Elapsed time: 00:03:04.234. |
Master.dtsx |
\Package |
None |
\Master |
| 2017-04-08 17:14:23.7718545 -07:00 |
SQL Task B:Finished, 17:14:23, Elapsed time: 00:00:53.016. |
Master.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Load Results[5]\SQL Task B |
| 2017-04-08 17:14:23.7718545 -07:00 |
Drop Results Table:Start, 17:14:23. |
Master.dtsx |
\Package\Drop Results Table |
None |
\Master\Drop Results Table |
| 2017-04-08 17:14:23.7718545 -07:00 |
Drop Results Table:Validation has started. |
Master.dtsx |
\Package\Drop Results Table |
None |
\Master\Drop Results Table |
| 2017-04-08 17:14:23.7718545 -07:00 |
Drop Results Table:Validation is complete. |
Master.dtsx |
\Package\Drop Results Table |
None |
\Master\Drop Results Table |
| 2017-04-08 17:14:23.7877617 -07:00 |
Drop Results Table:Finished, 17:14:23, Elapsed time: 00:00:00.015. |
Master.dtsx |
\Package\Drop Results Table |
None |
\Master\Drop Results Table |
| 2017-04-08 17:14:23.7877617 -07:00 |
SayBye:Start, 17:14:23. |
Master.dtsx |
\Package\SayBye |
None |
\Master\SayBye |
| 2017-04-08 17:14:23.7877617 -07:00 |
Say Bye Once More:Start, 17:14:23. |
Master.dtsx |
\Package\SayBye\Say Bye Once More |
None |
\Master\SayBye\Say Bye Once More |
| 2017-04-08 17:14:23.7877617 -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-08 17:14:23.7877617 -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-08 17:14:23.7877617 -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-08 17:14:23.7877617 -07:00 |
Say Bye Once More:Finished, 17:14:23, Elapsed time: 00:00:00.000. |
Master.dtsx |
\Package\SayBye\Say Bye Once More |
None |
\Master\SayBye\Say Bye Once More |
