| 2017-04-08 17:51:35.0454691 -07:00 |
Load Results:Start, 17:51:35. |
Master.dtsx |
\Package\Load Results |
None |
\Master\Load Results |
| 2017-04-08 17:51:35.0454691 -07:00 |
Load Master Result Table:Start, 17:51:35. |
Master.dtsx |
\Package\Load Results\Load Master Result Table |
None |
\Master\Load Results[1]\Load Master Result Table |
| 2017-04-08 17:51:35.1546547 -07:00 |
Do Stuff:Start, 17:51:35. |
Master.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Load Results[1]\Do Stuff |
| 2017-04-08 17:51:35.1707660 -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-08 17:51:17.1544463 -07:00 |
Master:Start, 17:51:17. |
Master.dtsx |
\Package |
None |
\Master |
| 2017-04-08 17:51:17.1854728 -07:00 |
SQL Task A:Start, 17:51:17. |
Master.dtsx |
\Package\SQL Task A |
None |
\Master\SQL Task A |
| 2017-04-08 17:51:17.1854728 -07:00 |
Create Results Table:Start, 17:51:17. |
Master.dtsx |
\Package\Create Results Table |
None |
\Master\Create Results Table |
| 2017-04-08 17:51:17.3260670 -07:00 |
Write Message:Start, 17:51:17. |
Master.dtsx |
\Package\Write Message |
None |
\Master\Write Message |
| 2017-04-08 17:51:18.4823947 -07:00 |
Child:Start, 17:51:18. |
Child.dtsx |
\Package |
None |
\Master\Execute Child Package\Child |
| 2017-04-08 17:51:18.4823947 -07:00 |
Create Results Table:Start, 17:51:18. |
Child.dtsx |
\Package\Create Results Table |
None |
\Master\Execute Child Package\Child\Create Results Table |
| 2017-04-08 17:51:18.4988899 -07:00 |
Load Results:Start, 17:51:18. |
Child.dtsx |
\Package\Load Results |
None |
\Master\Execute Child Package\Child\Load Results |
| 2017-04-08 17:51:18.4988899 -07:00 |
Load Child Results Table:Start, 17:51:18. |
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:51:18.5917510 -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:51:18.5917510 -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:51:18.5917510 -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:51:18.5917510 -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:51:18.4988899 -07:00 |
Call Grandchild:Start, 17:51:18. |
Child.dtsx |
\Package\Call Grandchild |
None |
\Master\Execute Child Package\Child\Call Grandchild |
| 2017-04-08 17:51:18.5291903 -07:00 |
Grandchild:Start, 17:51:18. |
Grandchild.dtsx |
\Package |
None |
\Master\Execute Child Package\Child\Call Grandchild\Grandchild |
| 2017-04-08 17:51:18.5291903 -07:00 |
Do Something:Start, 17:51:18. |
Grandchild.dtsx |
\Package\Do Something |
None |
\Master\Execute Child Package\Child\Call Grandchild\Grandchild\Do Something |
| 2017-04-08 17:51:18.5291903 -07:00 |
Play with Username:Start, 17:51:18. |
Grandchild.dtsx |
\Package\Play with Username |
None |
\Master\Execute Child Package\Child\Call Grandchild\Grandchild\Play with Username |
| 2017-04-08 17:51:18.4050853 -07:00 |
Execute Child Package:Start, 17:51:18. |
Master.dtsx |
\Package\Execute Child Package |
None |
\Master\Execute Child Package |
| 2017-04-08 17:51:18.9354461 -07:00 |
Do Stuff:Start, 17:51:18. |
Child.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Execute Child Package\Child\Load Results[1]\Do Stuff |
| 2017-04-08 17:51:18.8260819 -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:51:18.8417117 -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:51:18.8729956 -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:51:18.9354461 -07:00 |
SQL Task B:Start, 17:51:18. |
Child.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Execute Child Package\Child\Load Results[1]\SQL Task B |
| 2017-04-08 17:51:19.9667807 -07:00 |
Load Child Results Table:Start, 17:51:19. |
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:51:20.0451337 -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:51:20.0451337 -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:51:20.0451337 -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:51:20.0916933 -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:51:20.1073218 -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:51:20.1544267 -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:51:20.2013637 -07:00 |
Do Stuff:Start, 17:51:20. |
Child.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Execute Child Package\Child\Load Results[2]\Do Stuff |
| 2017-04-08 17:51:20.2013637 -07:00 |
SQL Task B:Start, 17:51:20. |
Child.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Execute Child Package\Child\Load Results[2]\SQL Task B |
| 2017-04-08 17:51:22.2332459 -07:00 |
Load Child Results Table:Start, 17:51:22. |
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:51:22.3111062 -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:51:22.3111062 -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:51:22.3111062 -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:51:22.3574872 -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:51:22.3729658 -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:51:22.4049001 -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:51:22.4668039 -07:00 |
Do Stuff:Start, 17:51:22. |
Child.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Execute Child Package\Child\Load Results[3]\Do Stuff |
| 2017-04-08 17:51:22.4668039 -07:00 |
SQL Task B:Start, 17:51:22. |
Child.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Execute Child Package\Child\Load Results[3]\SQL Task B |
| 2017-04-08 17:51:25.4827739 -07:00 |
Load Child Results Table:Start, 17:51:25. |
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:51:25.5762193 -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:51:25.5762193 -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:51:25.5762193 -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:51:25.6395454 -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:51:25.6545249 -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:51:25.6860800 -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:51:25.7329746 -07:00 |
SQL Task B:Start, 17:51:25. |
Child.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Execute Child Package\Child\Load Results[4]\SQL Task B |
| 2017-04-08 17:51:25.7329746 -07:00 |
Do Stuff:Start, 17:51:25. |
Child.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Execute Child Package\Child\Load Results[4]\Do Stuff |
| 2017-04-08 17:51:29.7798665 -07:00 |
Load Child Results Table:Start, 17:51:29. |
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:51:29.8576826 -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:51:29.8576826 -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:51:29.8576826 -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:51:29.9042185 -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:51:29.9203308 -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:51:29.9511373 -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:51:30.0141410 -07:00 |
SQL Task B:Start, 17:51:30. |
Child.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Execute Child Package\Child\Load Results[5]\SQL Task B |
| 2017-04-08 17:51:30.0141410 -07:00 |
Do Stuff:Start, 17:51:30. |
Child.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Execute Child Package\Child\Load Results[5]\Do Stuff |
| 2017-04-08 17:51:35.1856803 -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-08 17:51:35.0917450 -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:51:35.1233494 -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:51:35.1546547 -07:00 |
SQL Task B:Start, 17:51:35. |
Master.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Load Results[1]\SQL Task B |
| 2017-04-08 17:51:48.1860242 -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-08 17:51:48.1860242 -07:00 |
Say Bye:Start, 17:51:48. |
Master.dtsx |
\Package\SayBye\Say Bye |
None |
\Master\SayBye\Say Bye |
| 2017-04-08 17:51:48.1860242 -07:00 |
Handle Error:Start, 17:51:48. |
Master.dtsx |
\Package\Handle Error |
None |
\Master\Handle Error |
| 2017-04-08 17:51:48.1860242 -07:00 |
SayBye:Start, 17:51:48. |
Master.dtsx |
\Package\SayBye |
None |
\Master\SayBye |
| 2017-04-08 17:51:48.1860242 -07:00 |
Say Bye Once More:Start, 17:51:48. |
Master.dtsx |
\Package\SayBye\Say Bye Once More |
None |
\Master\SayBye\Say Bye Once More |
