| 2017-04-14 15:08:00.0426110 -07:00 |
Handle Error:Validation is complete. |
Master.dtsx |
\Package\Handle Error |
None |
\Master\Handle Error |
| 2017-04-14 15:08:00.0426110 -07:00 |
Do Stuff:Validation has started. |
Master.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Load Results\Do Stuff |
| 2017-04-14 15:08:00.0426110 -07:00 |
Load Results:Validation has started. |
Master.dtsx |
\Package\Load Results |
None |
\Master\Load Results |
| 2017-04-14 15:08:00.0426110 -07:00 |
Do Stuff:Validation is complete. |
Master.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Load Results\Do Stuff |
| 2017-04-14 15:08:00.0426110 -07:00 |
Write Message:Validation is complete. |
Master.dtsx |
\Package\Write Message |
None |
\Master\Write Message |
| 2017-04-14 15:08:00.0426110 -07:00 |
Master:Validation is complete. |
Master.dtsx |
\Package |
None |
\Master |
| 2017-04-14 15:08:00.3708744 -07:00 |
Master:Start, 15:08:00. |
Master.dtsx |
\Package |
None |
\Master |
| 2017-04-14 15:08:00.0113983 -07:00 |
Master:Validation has started. |
Master.dtsx |
\Package |
None |
\Master |
| 2017-04-14 15:08:00.0275990 -07:00 |
Create Results Table:Validation has started. |
Master.dtsx |
\Package\Create Results Table |
None |
\Master\Create Results Table |
| 2017-04-14 15:08:00.0275990 -07:00 |
Create Results Table:Validation is complete. |
Master.dtsx |
\Package\Create Results Table |
None |
\Master\Create Results Table |
| 2017-04-14 15:08:00.0275990 -07:00 |
Drop Results Table:Validation has started. |
Master.dtsx |
\Package\Drop Results Table |
None |
\Master\Drop Results Table |
| 2017-04-14 15:08:00.0275990 -07:00 |
Drop Results Table:Validation is complete. |
Master.dtsx |
\Package\Drop Results Table |
None |
\Master\Drop Results Table |
| 2017-04-14 15:08:00.0275990 -07:00 |
Execute Child Package:Validation has started. |
Master.dtsx |
\Package\Execute Child Package |
None |
\Master\Execute Child Package |
| 2017-04-14 15:08:00.0275990 -07:00 |
Execute Child Package:Validation is complete. |
Master.dtsx |
\Package\Execute Child Package |
None |
\Master\Execute Child Package |
| 2017-04-14 15:08:00.0426110 -07:00 |
Handle Error:Validation has started. |
Master.dtsx |
\Package\Handle Error |
None |
\Master\Handle Error |
| 2017-04-14 15:08:00.0426110 -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-14 15:08:00.0426110 -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-14 15:08:00.0426110 -07:00 |
Load Results:Validation is complete. |
Master.dtsx |
\Package\Load Results |
None |
\Master\Load Results |
| 2017-04-14 15:08:00.0426110 -07:00 |
SayBye:Validation has started. |
Master.dtsx |
\Package\SayBye |
None |
\Master\SayBye |
| 2017-04-14 15:08:00.0426110 -07:00 |
Say Bye:Validation has started. |
Master.dtsx |
\Package\SayBye\Say Bye |
None |
\Master\SayBye\Say Bye |
| 2017-04-14 15:08:00.0426110 -07:00 |
Say Bye:Validation is complete. |
Master.dtsx |
\Package\SayBye\Say Bye |
None |
\Master\SayBye\Say Bye |
| 2017-04-14 15:08:00.0426110 -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-14 15:08:00.0426110 -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-14 15:08:00.0426110 -07:00 |
SayBye:Validation is complete. |
Master.dtsx |
\Package\SayBye |
None |
\Master\SayBye |
| 2017-04-14 15:08:00.0426110 -07:00 |
SQL Task A:Validation has started. |
Master.dtsx |
\Package\SQL Task A |
None |
\Master\SQL Task A |
| 2017-04-14 15:08:00.0426110 -07:00 |
SQL Task A:Validation is complete. |
Master.dtsx |
\Package\SQL Task A |
None |
\Master\SQL Task A |
| 2017-04-14 15:08:00.0426110 -07:00 |
Write Message:Validation has started. |
Master.dtsx |
\Package\Write Message |
None |
\Master\Write Message |
| 2017-04-14 15:08:00.4018135 -07:00 |
Create Results Table:Start, 15:08:00. |
Master.dtsx |
\Package\Create Results Table |
None |
\Master\Create Results Table |
| 2017-04-14 15:08:00.4018135 -07:00 |
Create Results Table:Validation has started. |
Master.dtsx |
\Package\Create Results Table |
None |
\Master\Create Results Table |
| 2017-04-14 15:08:00.4018135 -07:00 |
Create Results Table:Validation is complete. |
Master.dtsx |
\Package\Create Results Table |
None |
\Master\Create Results Table |
| 2017-04-14 15:08:00.4018135 -07:00 |
SQL Task A:Start, 15:08:00. |
Master.dtsx |
\Package\SQL Task A |
None |
\Master\SQL Task A |
| 2017-04-14 15:08:00.4018135 -07:00 |
SQL Task A:Validation has started. |
Master.dtsx |
\Package\SQL Task A |
None |
\Master\SQL Task A |
| 2017-04-14 15:08:00.4018135 -07:00 |
SQL Task A:Validation is complete. |
Master.dtsx |
\Package\SQL Task A |
None |
\Master\SQL Task A |
| 2017-04-14 15:08:00.8550049 -07:00 |
Create Results Table:Finished, 15:08:00, Elapsed time: 00:00:00.437. |
Master.dtsx |
\Package\Create Results Table |
None |
\Master\Create Results Table |
| 2017-04-14 15:08:00.8550049 -07:00 |
Write Message:Start, 15:08:00. |
Master.dtsx |
\Package\Write Message |
None |
\Master\Write Message |
| 2017-04-14 15:08:01.0742805 -07:00 |
Write Message:Validation has started. |
Master.dtsx |
\Package\Write Message |
None |
\Master\Write Message |
| 2017-04-14 15:08:01.0742805 -07:00 |
Write Message:Validation is complete. |
Master.dtsx |
\Package\Write Message |
None |
\Master\Write Message |
| 2017-04-14 15:08:02.1365794 -07:00 |
Write Message:Information: Hi there, this is Sample 1 |
Master.dtsx |
\Package\Write Message |
None |
\Master\Write Message |
| 2017-04-14 15:08:02.1525237 -07:00 |
Write Message:Finished, 15:08:02, Elapsed time: 00:00:01.297. |
Master.dtsx |
\Package\Write Message |
None |
\Master\Write Message |
| 2017-04-14 15:08:02.1525237 -07:00 |
Execute Child Package:Start, 15:08:02. |
Master.dtsx |
\Package\Execute Child Package |
None |
\Master\Execute Child Package |
| 2017-04-14 15:08:02.1525237 -07:00 |
Execute Child Package:Validation has started. |
Master.dtsx |
\Package\Execute Child Package |
None |
\Master\Execute Child Package |
| 2017-04-14 15:08:02.1525237 -07:00 |
Execute Child Package:Validation is complete. |
Master.dtsx |
\Package\Execute Child Package |
None |
\Master\Execute Child Package |
| 2017-04-14 15:08:02.2300267 -07:00 |
Child:Validation has started. |
Child.dtsx |
\Package |
None |
\Master\Execute Child Package\Child |
| 2017-04-14 15:08:02.2300267 -07:00 |
Call Grandchild:Validation has started. |
Child.dtsx |
\Package\Call Grandchild |
None |
\Master\Execute Child Package\Child\Call Grandchild |
| 2017-04-14 15:08:02.2300267 -07:00 |
Call Grandchild:Validation is complete. |
Child.dtsx |
\Package\Call Grandchild |
None |
\Master\Execute Child Package\Child\Call Grandchild |
| 2017-04-14 15:08:02.2300267 -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-14 15:08:02.2300267 -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-14 15:08:02.2300267 -07:00 |
Load Results:Validation has started. |
Child.dtsx |
\Package\Load Results |
None |
\Master\Execute Child Package\Child\Load Results |
| 2017-04-14 15:08:02.2300267 -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-14 15:08:02.2300267 -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-14 15:08:02.2300267 -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-14 15:08:02.2300267 -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-14 15:08:02.2300267 -07:00 |
Load Results:Validation is complete. |
Child.dtsx |
\Package\Load Results |
None |
\Master\Execute Child Package\Child\Load Results |
| 2017-04-14 15:08:02.2300267 -07:00 |
Child:Validation is complete. |
Child.dtsx |
\Package |
None |
\Master\Execute Child Package\Child |
| 2017-04-14 15:08:02.2300267 -07:00 |
Child:Validation has started. |
Child.dtsx |
\Package |
None |
\Master\Execute Child Package\Child |
| 2017-04-14 15:08:02.2300267 -07:00 |
Call Grandchild:Validation has started. |
Child.dtsx |
\Package\Call Grandchild |
None |
\Master\Execute Child Package\Child\Call Grandchild |
| 2017-04-14 15:08:02.2300267 -07:00 |
Call Grandchild:Validation is complete. |
Child.dtsx |
\Package\Call Grandchild |
None |
\Master\Execute Child Package\Child\Call Grandchild |
| 2017-04-14 15:08:02.2456723 -07:00 |
Child:Start, 15:08:02. |
Child.dtsx |
\Package |
None |
\Master\Execute Child Package\Child |
| 2017-04-14 15:08:02.2456723 -07:00 |
Create Results Table:Start, 15:08:02. |
Child.dtsx |
\Package\Create Results Table |
None |
\Master\Execute Child Package\Child\Create Results Table |
| 2017-04-14 15:08:02.2456723 -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-14 15:08:02.2456723 -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-14 15:08:02.2613161 -07:00 |
Create Results Table:Finished, 15:08:02, Elapsed time: 00:00:00.016. |
Child.dtsx |
\Package\Create Results Table |
None |
\Master\Execute Child Package\Child\Create Results Table |
| 2017-04-14 15:08:02.2613161 -07:00 |
Load Results:Start, 15:08:02. |
Child.dtsx |
\Package\Load Results |
None |
\Master\Execute Child Package\Child\Load Results |
| 2017-04-14 15:08:02.2613161 -07:00 |
Load Child Results Table:Start, 15:08:02. |
Child.dtsx |
\Package\Load Results\Load Child Results Table |
None |
\Master\Execute Child Package\Child\Load Results[1]\Load Child Results Table |
| 2017-04-14 15:08:02.2613161 -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-14 15:08:02.3401814 -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-14 15:08:02.2613161 -07:00 |
Call Grandchild:Start, 15:08:02. |
Child.dtsx |
\Package\Call Grandchild |
None |
\Master\Execute Child Package\Child\Call Grandchild |
| 2017-04-14 15:08:02.2613161 -07:00 |
Call Grandchild:Validation has started. |
Child.dtsx |
\Package\Call Grandchild |
None |
\Master\Execute Child Package\Child\Call Grandchild |
| 2017-04-14 15:08:02.2613161 -07:00 |
Call Grandchild:Validation is complete. |
Child.dtsx |
\Package\Call Grandchild |
None |
\Master\Execute Child Package\Child\Call Grandchild |
| 2017-04-14 15:08:02.2770911 -07:00 |
Grandchild:Validation has started. |
Grandchild.dtsx |
\Package |
None |
\Master\Execute Child Package\Child\Call Grandchild\Grandchild |
| 2017-04-14 15:08:02.2770911 -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-14 15:08:02.2770911 -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-14 15:08:02.2770911 -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-14 15:08:02.2770911 -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-14 15:08:02.2770911 -07:00 |
Grandchild:Validation is complete. |
Grandchild.dtsx |
\Package |
None |
\Master\Execute Child Package\Child\Call Grandchild\Grandchild |
| 2017-04-14 15:08:02.2932537 -07:00 |
Grandchild:Validation has started. |
Grandchild.dtsx |
\Package |
None |
\Master\Execute Child Package\Child\Call Grandchild\Grandchild |
| 2017-04-14 15:08:02.2932537 -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-14 15:08:02.2932537 -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-14 15:08:02.2932537 -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-14 15:08:02.2932537 -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-14 15:08:02.2932537 -07:00 |
Grandchild:Validation is complete. |
Grandchild.dtsx |
\Package |
None |
\Master\Execute Child Package\Child\Call Grandchild\Grandchild |
| 2017-04-14 15:08:02.3401814 -07:00 |
Grandchild:Start, 15:08:02. |
Grandchild.dtsx |
\Package |
None |
\Master\Execute Child Package\Child\Call Grandchild\Grandchild |
| 2017-04-14 15:08:02.2300267 -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-14 15:08:02.2300267 -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-14 15:08:02.2300267 -07:00 |
Load Results:Validation has started. |
Child.dtsx |
\Package\Load Results |
None |
\Master\Execute Child Package\Child\Load Results |
| 2017-04-14 15:08:02.2300267 -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-14 15:08:02.2300267 -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-14 15:08:02.2300267 -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-14 15:08:02.2300267 -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-14 15:08:02.2300267 -07:00 |
Load Results:Validation is complete. |
Child.dtsx |
\Package\Load Results |
None |
\Master\Execute Child Package\Child\Load Results |
| 2017-04-14 15:08:02.2300267 -07:00 |
Child:Validation is complete. |
Child.dtsx |
\Package |
None |
\Master\Execute Child Package\Child |
| 2017-04-14 15:08:02.3401814 -07:00 |
Do Something:Start, 15:08:02. |
Grandchild.dtsx |
\Package\Do Something |
None |
\Master\Execute Child Package\Child\Call Grandchild\Grandchild\Do Something |
| 2017-04-14 15:08:02.3401814 -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-14 15:08:02.3401814 -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-14 15:08:02.3549161 -07:00 |
Do Something:Finished, 15:08:02, Elapsed time: 00:00:00.016. |
Grandchild.dtsx |
\Package\Do Something |
None |
\Master\Execute Child Package\Child\Call Grandchild\Grandchild\Do Something |
| 2017-04-14 15:08:02.3549161 -07:00 |
Play with Username:Start, 15:08:02. |
Grandchild.dtsx |
\Package\Play with Username |
None |
\Master\Execute Child Package\Child\Call Grandchild\Grandchild\Play with Username |
| 2017-04-14 15:08:02.3549161 -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-14 15:08:02.3549161 -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-14 15:08:02.3549161 -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-14 15:08:02.8395640 -07:00 |
SQL Task A:Finished, 15:08:02, Elapsed time: 00:00:02.437. |
Master.dtsx |
\Package\SQL Task A |
None |
\Master\SQL Task A |
| 2017-04-14 15:08:02.9647679 -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-14 15:08:02.9647679 -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-14 15:08:02.9647679 -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-14 15:08:02.9647679 -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-14 15:08:02.9647679 -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-14 15:08:02.9799367 -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-14 15:08:03.0268164 -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-14 15:08:03.2455491 -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-14 15:08:03.2455491 -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-14 15:08:03.2455491 -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-14 15:08:03.2455491 -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-14 15:08:03.2614478 -07:00 |
Load Child Results Table:Information: The Lookup B processed 55 rows in the cache. The processing time was 0.203 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-14 15:08:03.2767957 -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-14 15:08:03.2767957 -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-14 15:08:03.2767957 -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-14 15:08:03.2924446 -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-14 15:08:03.2924446 -07:00 |
Load Child Results Table:Information: The Lookup C processed 505 rows in the cache. The processing time was 0.031 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-14 15:08:03.3238304 -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-14 15:08:03.3238304 -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-14 15:08:03.3238304 -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-14 15:08:03.3238304 -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-14 15:08:03.3238304 -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[1]\Load Child Results Table |
| 2017-04-14 15:08:03.4017930 -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-14 15:08:03.4017930 -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-14 15:08:03.4017930 -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-14 15:08:03.4017930 -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-14 15:08:03.3707567 -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-14 15:08:03.4174233 -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-14 15:08:03.4330723 -07:00 |
Load Child Results Table:Information: "DST - Bad" wrote 1767 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-14 15:08:03.4491134 -07:00 |
Load Child Results Table:Information: "DST - Good" wrote 500 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-14 15:08:03.4491134 -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-14 15:08:03.4956805 -07:00 |
Do Stuff:Start, 15:08:03. |
Child.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Execute Child Package\Child\Load Results[1]\Do Stuff |
| 2017-04-14 15:08:03.4956805 -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-14 15:08:03.4956805 -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-14 15:08:03.4956805 -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-14 15:08:03.4956805 -07:00 |
Do Stuff:Finished, 15:08:03, Elapsed time: 00:00:00.015. |
Child.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Execute Child Package\Child\Load Results[1]\Do Stuff |
| 2017-04-14 15:08:03.4799650 -07:00 |
Load Child Results Table:Finished, 15:08:03, Elapsed time: 00:00:01.219. |
Child.dtsx |
\Package\Load Results\Load Child Results Table |
None |
\Master\Execute Child Package\Child\Load Results[1]\Load Child Results Table |
| 2017-04-14 15:08:03.4956805 -07:00 |
SQL Task B:Start, 15:08:03. |
Child.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Execute Child Package\Child\Load Results[1]\SQL Task B |
| 2017-04-14 15:08:03.4956805 -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-14 15:08:03.4956805 -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-14 15:08:04.5121636 -07:00 |
Load Child Results Table:Start, 15:08:04. |
Child.dtsx |
\Package\Load Results\Load Child Results Table |
None |
\Master\Execute Child Package\Child\Load Results[2]\Load Child Results Table |
| 2017-04-14 15:08:04.5121636 -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-14 15:08:04.5121636 -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-14 15:08:04.5121636 -07:00 |
SQL Task B:Finished, 15:08:04, Elapsed time: 00:00:01.031. |
Child.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Execute Child Package\Child\Load Results[1]\SQL Task B |
| 2017-04-14 15:08:04.6678288 -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-14 15:08:04.6678288 -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-14 15:08:04.6678288 -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-14 15:08:04.6678288 -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-14 15:08:04.6678288 -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-14 15:08:04.7456803 -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-14 15:08:04.7771158 -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-14 15:08:04.7771158 -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-14 15:08:04.7771158 -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-14 15:08:04.7771158 -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[2]\Load Child Results Table |
| 2017-04-14 15:08:04.8080526 -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-14 15:08:04.8080526 -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-14 15:08:04.8080526 -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-14 15:08:04.8080526 -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[2]\Load Child Results Table |
| 2017-04-14 15:08:04.8554548 -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-14 15:08:04.8554548 -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-14 15:08:04.8554548 -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-14 15:08:04.8554548 -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-14 15:08:04.9023774 -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-14 15:08:04.9177462 -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-14 15:08:04.9177462 -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-14 15:08:04.9177462 -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-14 15:08:04.9177462 -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-14 15:08:04.9333305 -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-14 15:08:04.9799367 -07:00 |
Load Child Results Table:Information: "DST - Bad" wrote 1289 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-14 15:08:04.9799367 -07:00 |
Load Child Results Table:Information: "DST - Good" wrote 356 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-14 15:08:04.9799367 -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-14 15:08:04.9956712 -07:00 |
SQL Task B:Start, 15:08:04. |
Child.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Execute Child Package\Child\Load Results[2]\SQL Task B |
| 2017-04-14 15:08:04.9956712 -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-14 15:08:04.9956712 -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-14 15:08:04.9956712 -07:00 |
Do Stuff:Start, 15:08:04. |
Child.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Execute Child Package\Child\Load Results[2]\Do Stuff |
| 2017-04-14 15:08:04.9956712 -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-14 15:08:04.9956712 -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-14 15:08:04.9956712 -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-14 15:08:04.9956712 -07:00 |
Do Stuff:Finished, 15:08:04, 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-14 15:08:04.9956712 -07:00 |
Load Child Results Table:Finished, 15:08:04, Elapsed time: 00:00:00.484. |
Child.dtsx |
\Package\Load Results\Load Child Results Table |
None |
\Master\Execute Child Package\Child\Load Results[2]\Load Child Results Table |
| 2017-04-14 15:08:07.0270127 -07:00 |
Load Child Results Table:Start, 15:08:07. |
Child.dtsx |
\Package\Load Results\Load Child Results Table |
None |
\Master\Execute Child Package\Child\Load Results[3]\Load Child Results Table |
| 2017-04-14 15:08:07.0270127 -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-14 15:08:07.0425165 -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-14 15:08:07.0270127 -07:00 |
SQL Task B:Finished, 15:08:07, Elapsed time: 00:00:02.032. |
Child.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Execute Child Package\Child\Load Results[2]\SQL Task B |
| 2017-04-14 15:08:07.2299620 -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-14 15:08:07.2299620 -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-14 15:08:07.2299620 -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-14 15:08:07.2459329 -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-14 15:08:07.2459329 -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-14 15:08:07.3083536 -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-14 15:08:07.3393053 -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-14 15:08:07.3393053 -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-14 15:08:07.3393053 -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-14 15:08:07.3393053 -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[3]\Load Child Results Table |
| 2017-04-14 15:08:07.3552804 -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-14 15:08:07.3712619 -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-14 15:08:07.3712619 -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-14 15:08:07.3712619 -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[3]\Load Child Results Table |
| 2017-04-14 15:08:07.4025914 -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-14 15:08:07.3862032 -07:00 |
Call Grandchild:Finished, 15:08:07, Elapsed time: 00:00:05.125. |
Child.dtsx |
\Package\Call Grandchild |
None |
\Master\Execute Child Package\Child\Call Grandchild |
| 2017-04-14 15:08:07.3712619 -07:00 |
Grandchild:Finished, 15:08:07, Elapsed time: 00:00:05.078. |
Grandchild.dtsx |
\Package |
None |
\Master\Execute Child Package\Child\Call Grandchild\Grandchild |
| 2017-04-14 15:08:07.3712619 -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-14 15:08:07.3712619 -07:00 |
Play with Username:Finished, 15:08:07, Elapsed time: 00:00:05.015. |
Grandchild.dtsx |
\Package\Play with Username |
None |
\Master\Execute Child Package\Child\Call Grandchild\Grandchild\Play with Username |
| 2017-04-14 15:08:07.4025914 -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-14 15:08:07.4176262 -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-14 15:08:07.4176262 -07:00 |
Load Child Results Table:Information: The Lookup A processed 1505 rows in the cache. The processing time was 0.031 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-14 15:08:07.4645343 -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-14 15:08:07.4955777 -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-14 15:08:07.4955777 -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-14 15:08:07.4955777 -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-14 15:08:07.4955777 -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-14 15:08:07.5112582 -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-14 15:08:07.5582622 -07:00 |
Load Child Results Table:Information: "DST - Bad" wrote 1280 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-14 15:08:07.5582622 -07:00 |
Load Child Results Table:Information: "DST - Good" wrote 365 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-14 15:08:07.5582622 -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-14 15:08:07.5893358 -07:00 |
SQL Task B:Start, 15:08:07. |
Child.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Execute Child Package\Child\Load Results[3]\SQL Task B |
| 2017-04-14 15:08:07.5893358 -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-14 15:08:07.5893358 -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-14 15:08:07.5893358 -07:00 |
Do Stuff:Start, 15:08:07. |
Child.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Execute Child Package\Child\Load Results[3]\Do Stuff |
| 2017-04-14 15:08:07.5893358 -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-14 15:08:07.5893358 -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-14 15:08:07.5893358 -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-14 15:08:07.5893358 -07:00 |
Do Stuff:Finished, 15:08:07, Elapsed time: 00:00:00.000. |
Child.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Execute Child Package\Child\Load Results[3]\Do Stuff |
| 2017-04-14 15:08:07.5893358 -07:00 |
Load Child Results Table:Finished, 15:08:07, Elapsed time: 00:00:00.562. |
Child.dtsx |
\Package\Load Results\Load Child Results Table |
None |
\Master\Execute Child Package\Child\Load Results[3]\Load Child Results Table |
| 2017-04-14 15:08:10.6206243 -07:00 |
Load Child Results Table:Start, 15:08:10. |
Child.dtsx |
\Package\Load Results\Load Child Results Table |
None |
\Master\Execute Child Package\Child\Load Results[4]\Load Child Results Table |
| 2017-04-14 15:08:10.6206243 -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-14 15:08:10.6206243 -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-14 15:08:10.6206243 -07:00 |
SQL Task B:Finished, 15:08:10, Elapsed time: 00:00:03.031. |
Child.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Execute Child Package\Child\Load Results[3]\SQL Task B |
| 2017-04-14 15:08:10.7929583 -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-14 15:08:10.8089138 -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-14 15:08:10.8089138 -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-14 15:08:10.8089138 -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-14 15:08:10.8089138 -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-14 15:08:10.8706301 -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-14 15:08:10.9022974 -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-14 15:08:10.9022974 -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-14 15:08:10.9022974 -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-14 15:08:10.9022974 -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-14 15:08:10.9022974 -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-14 15:08:10.9330760 -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-14 15:08:10.9330760 -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-14 15:08:10.9330760 -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-14 15:08:10.9330760 -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-14 15:08:10.9330760 -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[4]\Load Child Results Table |
| 2017-04-14 15:08:10.9646981 -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-14 15:08:10.9646981 -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-14 15:08:10.9806922 -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-14 15:08:10.9806922 -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-14 15:08:10.9806922 -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[4]\Load Child Results Table |
| 2017-04-14 15:08:11.0270011 -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-14 15:08:11.0424393 -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-14 15:08:11.0424393 -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-14 15:08:11.0424393 -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-14 15:08:11.0424393 -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-14 15:08:11.0424393 -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-14 15:08:11.0894349 -07:00 |
Load Child Results Table:Information: "DST - Bad" wrote 975 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-14 15:08:11.1054039 -07:00 |
Load Child Results Table:Information: "DST - Good" wrote 269 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-14 15:08:11.1054039 -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-14 15:08:11.1213892 -07:00 |
SQL Task B:Start, 15:08:11. |
Child.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Execute Child Package\Child\Load Results[4]\SQL Task B |
| 2017-04-14 15:08:11.1213892 -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-14 15:08:11.1361932 -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-14 15:08:11.1213892 -07:00 |
Do Stuff:Start, 15:08:11. |
Child.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Execute Child Package\Child\Load Results[4]\Do Stuff |
| 2017-04-14 15:08:11.1213892 -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-14 15:08:11.1361932 -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-14 15:08:11.1361932 -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-14 15:08:11.1361932 -07:00 |
Do Stuff:Finished, 15:08:11, Elapsed time: 00:00:00.016. |
Child.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Execute Child Package\Child\Load Results[4]\Do Stuff |
| 2017-04-14 15:08:11.1213892 -07:00 |
Load Child Results Table:Finished, 15:08:11, Elapsed time: 00:00:00.500. |
Child.dtsx |
\Package\Load Results\Load Child Results Table |
None |
\Master\Execute Child Package\Child\Load Results[4]\Load Child Results Table |
| 2017-04-14 15:08:15.1527233 -07:00 |
Load Child Results Table:Start, 15:08:15. |
Child.dtsx |
\Package\Load Results\Load Child Results Table |
None |
\Master\Execute Child Package\Child\Load Results[5]\Load Child Results Table |
| 2017-04-14 15:08:15.1527233 -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-14 15:08:15.1677037 -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-14 15:08:15.1527233 -07:00 |
SQL Task B:Finished, 15:08:15, Elapsed time: 00:00:04.032. |
Child.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Execute Child Package\Child\Load Results[4]\SQL Task B |
| 2017-04-14 15:08:15.3239220 -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-14 15:08:15.3239220 -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-14 15:08:15.3239220 -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-14 15:08:15.3398585 -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-14 15:08:15.3398585 -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-14 15:08:15.4018717 -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-14 15:08:15.4177420 -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-14 15:08:15.4177420 -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-14 15:08:15.4177420 -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-14 15:08:15.4337027 -07:00 |
Load Child Results Table:Information: The Lookup B processed 55 rows in the cache. The processing time was 0.001 seconds. The cache used 2200 bytes of memory.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
Lookup B [65] |
\Master\Execute Child Package\Child\Load Results[5]\Load Child Results Table |
| 2017-04-14 15:08:15.4496451 -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-14 15:08:15.4496451 -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-14 15:08:15.4496451 -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-14 15:08:15.4496451 -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[5]\Load Child Results Table |
| 2017-04-14 15:08:15.4955777 -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-14 15:08:15.4955777 -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-14 15:08:15.4955777 -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-14 15:08:15.4955777 -07:00 |
Load Child Results Table:Information: The Lookup A processed 1505 rows in the cache. The processing time was 0.015 seconds. The cache used 60200 bytes of memory.
|
Child.dtsx |
\Package\Load Results\Load Child Results Table |
Lookup A [40] |
\Master\Execute Child Package\Child\Load Results[5]\Load Child Results Table |
| 2017-04-14 15:08:15.5424881 -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-14 15:08:15.5739372 -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-14 15:08:15.5739372 -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-14 15:08:15.5739372 -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-14 15:08:15.5893972 -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-14 15:08:15.5893972 -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-14 15:08:15.6363384 -07:00 |
Load Child Results Table:Information: "DST - Bad" wrote 1458 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-14 15:08:15.6519561 -07:00 |
Load Child Results Table:Information: "DST - Good" wrote 408 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-14 15:08:15.6519561 -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-14 15:08:15.6676199 -07:00 |
SQL Task B:Start, 15:08:15. |
Child.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Execute Child Package\Child\Load Results[5]\SQL Task B |
| 2017-04-14 15:08:15.6833930 -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-14 15:08:15.6833930 -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-14 15:08:15.6676199 -07:00 |
Do Stuff:Start, 15:08:15. |
Child.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Execute Child Package\Child\Load Results[5]\Do Stuff |
| 2017-04-14 15:08:15.6833930 -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-14 15:08:15.6833930 -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-14 15:08:15.6833930 -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-14 15:08:15.6833930 -07:00 |
Do Stuff:Finished, 15:08:15, Elapsed time: 00:00:00.016. |
Child.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Execute Child Package\Child\Load Results[5]\Do Stuff |
| 2017-04-14 15:08:15.6676199 -07:00 |
Load Child Results Table:Finished, 15:08:15, Elapsed time: 00:00:00.515. |
Child.dtsx |
\Package\Load Results\Load Child Results Table |
None |
\Master\Execute Child Package\Child\Load Results[5]\Load Child Results Table |
| 2017-04-14 15:08:20.6994556 -07:00 |
Load Results:Finished, 15:08:20, Elapsed time: 00:00:18.437. |
Child.dtsx |
\Package\Load Results |
None |
\Master\Execute Child Package\Child\Load Results |
| 2017-04-14 15:08:20.6994556 -07:00 |
Child:Finished, 15:08:20, Elapsed time: 00:00:18.453. |
Child.dtsx |
\Package |
None |
\Master\Execute Child Package\Child |
| 2017-04-14 15:08:20.6994556 -07:00 |
SQL Task B:Finished, 15:08:20, Elapsed time: 00:00:05.031. |
Child.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Execute Child Package\Child\Load Results[5]\SQL Task B |
| 2017-04-14 15:08:20.7144248 -07:00 |
Execute Child Package:Finished, 15:08:20, Elapsed time: 00:00:18.562. |
Master.dtsx |
\Package\Execute Child Package |
None |
\Master\Execute Child Package |
| 2017-04-14 15:08:20.7144248 -07:00 |
Load Results:Start, 15:08:20. |
Master.dtsx |
\Package\Load Results |
None |
\Master\Load Results |
| 2017-04-14 15:08:20.7144248 -07:00 |
Load Master Result Table:Start, 15:08:20. |
Master.dtsx |
\Package\Load Results\Load Master Result Table |
None |
\Master\Load Results[1]\Load Master Result Table |
| 2017-04-14 15:08:20.7144248 -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-14 15:08:20.7144248 -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-14 15:08:20.8237118 -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-14 15:08:20.8237118 -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-14 15:08:20.8237118 -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-14 15:08:20.9018698 -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-14 15:08:20.9487258 -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-14 15:08:20.9487258 -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-14 15:08:20.9487258 -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-14 15:08:20.9487258 -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-14 15:08:20.9487258 -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-14 15:08:20.9643361 -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-14 15:08:20.9800237 -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-14 15:08:20.9800237 -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-14 15:08:20.9958898 -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-14 15:08:20.9800237 -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-14 15:08:20.9800237 -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-14 15:08:21.0112257 -07:00 |
Do Stuff:Start, 15:08:21. |
Master.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Load Results[1]\Do Stuff |
| 2017-04-14 15:08:21.0112257 -07:00 |
Do Stuff:Validation has started. |
Master.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Load Results[1]\Do Stuff |
| 2017-04-14 15:08:21.0112257 -07:00 |
Do Stuff:Validation is complete. |
Master.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Load Results[1]\Do Stuff |
| 2017-04-14 15:08:21.0268304 -07:00 |
Do Stuff:Error: Exception has been thrown by the target of an invocation. |
Master.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Load Results[1]\Do Stuff |
| 2017-04-14 15:08:21.0428068 -07:00 |
Do Stuff:The task, 'Do Stuff', failed. |
Master.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Load Results[1]\Do Stuff |
| 2017-04-14 15:08:21.0428068 -07:00 |
Do Stuff:Finished, 15:08:21, Elapsed time: 00:00:00.031. |
Master.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Load Results[1]\Do Stuff |
| 2017-04-14 15:08:21.0428068 -07:00 |
Load Results:Warning: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
|
Master.dtsx |
\Package\Load Results |
None |
\Master\Load Results[1] |
| 2017-04-14 15:08:21.0112257 -07:00 |
Load Master Result Table:Information: "DST - Bad" wrote 1767 rows.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
SSIS.Pipeline |
\Master\Load Results[1]\Load Master Result Table |
| 2017-04-14 15:08:21.0112257 -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-14 15:08:21.0112257 -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-14 15:08:21.0112257 -07:00 |
Load Master Result Table:Finished, 15:08:21, Elapsed time: 00:00:00.297. |
Master.dtsx |
\Package\Load Results\Load Master Result Table |
None |
\Master\Load Results[1]\Load Master Result Table |
| 2017-04-14 15:08:21.0112257 -07:00 |
SQL Task B:Start, 15:08:21. |
Master.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Load Results[1]\SQL Task B |
| 2017-04-14 15:08:21.0112257 -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-14 15:08:21.0112257 -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-14 15:08:34.2298452 -07:00 |
Load Results:Finished, 15:08:34, Elapsed time: 00:00:13.516. |
Master.dtsx |
\Package\Load Results |
None |
\Master\Load Results |
| 2017-04-14 15:08:34.2298452 -07:00 |
Master:Warning: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
|
Master.dtsx |
\Package |
None |
\Master |
| 2017-04-14 15:08:34.2455625 -07:00 |
Say Bye:Start, 15:08:34. |
Master.dtsx |
\Package\SayBye\Say Bye |
None |
\Master\SayBye\Say Bye |
| 2017-04-14 15:08:34.2455625 -07:00 |
Say Bye:Validation has started. |
Master.dtsx |
\Package\SayBye\Say Bye |
None |
\Master\SayBye\Say Bye |
| 2017-04-14 15:08:34.2455625 -07:00 |
Say Bye:Validation is complete. |
Master.dtsx |
\Package\SayBye\Say Bye |
None |
\Master\SayBye\Say Bye |
| 2017-04-14 15:08:34.2455625 -07:00 |
Say Bye:Information: Package executed, bye! |
Master.dtsx |
\Package\SayBye\Say Bye |
None |
\Master\SayBye\Say Bye |
| 2017-04-14 15:08:34.2455625 -07:00 |
Say Bye:Finished, 15:08:34, Elapsed time: 00:00:00.000. |
Master.dtsx |
\Package\SayBye\Say Bye |
None |
\Master\SayBye\Say Bye |
| 2017-04-14 15:08:34.2611045 -07:00 |
SayBye:Finished, 15:08:34, Elapsed time: 00:00:00.016. |
Master.dtsx |
\Package\SayBye |
None |
\Master\SayBye |
| 2017-04-14 15:08:34.2611045 -07:00 |
Master:Finished, 15:08:34, Elapsed time: 00:00:34.203. |
Master.dtsx |
\Package |
None |
\Master |
| 2017-04-14 15:08:34.2298452 -07:00 |
SQL Task B:Finished, 15:08:34, Elapsed time: 00:00:13.219. |
Master.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Load Results[1]\SQL Task B |
| 2017-04-14 15:08:34.2298452 -07:00 |
Handle Error:Start, 15:08:34. |
Master.dtsx |
\Package\Handle Error |
None |
\Master\Handle Error |
| 2017-04-14 15:08:34.2298452 -07:00 |
Handle Error:Validation has started. |
Master.dtsx |
\Package\Handle Error |
None |
\Master\Handle Error |
| 2017-04-14 15:08:34.2298452 -07:00 |
Handle Error:Validation is complete. |
Master.dtsx |
\Package\Handle Error |
None |
\Master\Handle Error |
| 2017-04-14 15:08:34.2455625 -07:00 |
Handle Error:Finished, 15:08:34, Elapsed time: 00:00:00.015. |
Master.dtsx |
\Package\Handle Error |
None |
\Master\Handle Error |
| 2017-04-14 15:08:34.2455625 -07:00 |
SayBye:Start, 15:08:34. |
Master.dtsx |
\Package\SayBye |
None |
\Master\SayBye |
| 2017-04-14 15:08:34.2455625 -07:00 |
Say Bye Once More:Start, 15:08:34. |
Master.dtsx |
\Package\SayBye\Say Bye Once More |
None |
\Master\SayBye\Say Bye Once More |
| 2017-04-14 15:08:34.2455625 -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-14 15:08:34.2455625 -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-14 15:08:34.2611045 -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-14 15:08:34.2611045 -07:00 |
Say Bye Once More:Finished, 15:08:34, Elapsed time: 00:00:00.016. |
Master.dtsx |
\Package\SayBye\Say Bye Once More |
None |
\Master\SayBye\Say Bye Once More |
