| 2017-04-08 17:56:08.4245752 -07:00 |
Master:Start, 17:56:08. |
Master.dtsx |
\Package |
None |
\Master |
| 2017-04-08 17:56:08.4556451 -07:00 |
Create Results Table:Start, 17:56:08. |
Master.dtsx |
\Package\Create Results Table |
None |
\Master\Create Results Table |
| 2017-04-08 17:56:08.5963709 -07:00 |
Write Message:Start, 17:56:08. |
Master.dtsx |
\Package\Write Message |
None |
\Master\Write Message |
| 2017-04-08 17:56:08.4556451 -07:00 |
SQL Task A:Start, 17:56:08. |
Master.dtsx |
\Package\SQL Task A |
None |
\Master\SQL Task A |
| 2017-04-08 17:56:09.7524018 -07:00 |
Child:Start, 17:56:09. |
Child.dtsx |
\Package |
None |
\Master\Execute Child Package\Child |
| 2017-04-08 17:56:09.7524018 -07:00 |
Create Results Table:Start, 17:56:09. |
Child.dtsx |
\Package\Create Results Table |
None |
\Master\Execute Child Package\Child\Create Results Table |
| 2017-04-08 17:56:09.7524018 -07:00 |
Load Results:Start, 17:56:09. |
Child.dtsx |
\Package\Load Results |
None |
\Master\Execute Child Package\Child\Load Results |
| 2017-04-08 17:56:09.7524018 -07:00 |
Load Child Results Table:Start, 17:56:09. |
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:56:09.8617381 -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:56:09.8617381 -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:56:09.8617381 -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:56:09.8617381 -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:56:10.1430631 -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:56:09.7524018 -07:00 |
Call Grandchild:Start, 17:56:09. |
Child.dtsx |
\Package\Call Grandchild |
None |
\Master\Execute Child Package\Child\Call Grandchild |
| 2017-04-08 17:56:09.7835759 -07:00 |
Grandchild:Start, 17:56:09. |
Grandchild.dtsx |
\Package |
None |
\Master\Execute Child Package\Child\Call Grandchild\Grandchild |
| 2017-04-08 17:56:09.6585646 -07:00 |
Execute Child Package:Start, 17:56:09. |
Master.dtsx |
\Package\Execute Child Package |
None |
\Master\Execute Child Package |
| 2017-04-08 17:56:09.7835759 -07:00 |
Do Something:Start, 17:56:09. |
Grandchild.dtsx |
\Package\Do Something |
None |
\Master\Execute Child Package\Child\Call Grandchild\Grandchild\Do Something |
| 2017-04-08 17:56:09.8151012 -07:00 |
Play with Username:Start, 17:56:09. |
Grandchild.dtsx |
\Package\Play with Username |
None |
\Master\Execute Child Package\Child\Call Grandchild\Grandchild\Play with Username |
| 2017-04-08 17:56:10.7366794 -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:56:10.7842621 -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:56:10.8616720 -07:00 |
SQL Task B:Start, 17:56:10. |
Child.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Execute Child Package\Child\Load Results[1]\SQL Task B |
| 2017-04-08 17:56:10.8616720 -07:00 |
Do Stuff:Start, 17:56:10. |
Child.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Execute Child Package\Child\Load Results[1]\Do Stuff |
| 2017-04-08 17:56:11.8779030 -07:00 |
Load Child Results Table:Start, 17:56:11. |
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:56:11.9558461 -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:56:11.9558461 -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:56:11.9558461 -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:56:12.0179965 -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:56:12.0499629 -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:56:12.0649335 -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:56:12.1118295 -07:00 |
SQL Task B:Start, 17:56:12. |
Child.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Execute Child Package\Child\Load Results[2]\SQL Task B |
| 2017-04-08 17:56:12.1118295 -07:00 |
Do Stuff:Start, 17:56:12. |
Child.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Execute Child Package\Child\Load Results[2]\Do Stuff |
| 2017-04-08 17:56:14.1431525 -07:00 |
Load Child Results Table:Start, 17:56:14. |
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:56:14.2374442 -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:56:14.2374442 -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:56:14.2374442 -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:56:14.2993099 -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:56:14.3308785 -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:56:14.3462343 -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:56:14.3931415 -07:00 |
SQL Task B:Start, 17:56:14. |
Child.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Execute Child Package\Child\Load Results[3]\SQL Task B |
| 2017-04-08 17:56:14.3931415 -07:00 |
Do Stuff:Start, 17:56:14. |
Child.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Execute Child Package\Child\Load Results[3]\Do Stuff |
| 2017-04-08 17:56:17.4245310 -07:00 |
Load Child Results Table:Start, 17:56:17. |
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:56:17.5336063 -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:56:17.5336063 -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:56:17.5336063 -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:56:17.5961532 -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:56:17.6281149 -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:56:17.6430883 -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:56:17.6899997 -07:00 |
SQL Task B:Start, 17:56:17. |
Child.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Execute Child Package\Child\Load Results[4]\SQL Task B |
| 2017-04-08 17:56:17.6899997 -07:00 |
Do Stuff:Start, 17:56:17. |
Child.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Execute Child Package\Child\Load Results[4]\Do Stuff |
| 2017-04-08 17:56:21.7062818 -07:00 |
Load Child Results Table:Start, 17:56:21. |
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:56:21.8465023 -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:56:21.8465023 -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:56:21.8465023 -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:56:21.9093604 -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:57:36.8959302 -07:00 |
SQL Task B:Start, 17:57:36. |
Master.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Load Results[4]\SQL Task B |
| 2017-04-08 17:56:21.9402921 -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:56:21.9562578 -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:56:22.0026830 -07:00 |
SQL Task B:Start, 17:56:22. |
Child.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Execute Child Package\Child\Load Results[5]\SQL Task B |
| 2017-04-08 17:56:22.0026830 -07:00 |
Do Stuff:Start, 17:56:22. |
Child.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Execute Child Package\Child\Load Results[5]\Do Stuff |
| 2017-04-08 17:56:27.0648721 -07:00 |
Load Results:Start, 17:56:27. |
Master.dtsx |
\Package\Load Results |
None |
\Master\Load Results |
| 2017-04-08 17:56:27.0648721 -07:00 |
Load Master Result Table:Start, 17:56:27. |
Master.dtsx |
\Package\Load Results\Load Master Result Table |
None |
\Master\Load Results[1]\Load Master Result Table |
| 2017-04-08 17:56:27.0961485 -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:56:27.1281098 -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:56:27.1585781 -07:00 |
Do Stuff:Start, 17:56:27. |
Master.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Load Results[1]\Do Stuff |
| 2017-04-08 17:56:27.1585781 -07:00 |
SQL Task B:Start, 17:56:27. |
Master.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Load Results[1]\SQL Task B |
| 2017-04-08 17:56:40.1748858 -07:00 |
Load Master Result Table:Start, 17:56:40. |
Master.dtsx |
\Package\Load Results\Load Master Result Table |
None |
\Master\Load Results[2]\Load Master Result Table |
| 2017-04-08 17:56:40.2523990 -07:00 |
Load Master Result Table:Warning: The output column "my_id" (59) on output "Lookup Match Output" (58) and component "Lookup" (40) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
SSIS.Pipeline |
\Master\Load Results[2]\Load Master Result Table |
| 2017-04-08 17:56:40.3152212 -07:00 |
Load Master Result Table:Warning: The Lookup encountered duplicate reference key values when caching reference data. This error occurs in Full Cache mode only. Either remove the duplicate key values, or change the cache mode to PARTIAL or NO_CACHE.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
Lookup [40] |
\Master\Load Results[2]\Load Master Result Table |
| 2017-04-08 17:56:40.3461673 -07:00 |
Do Stuff:Start, 17:56:40. |
Master.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Load Results[2]\Do Stuff |
| 2017-04-08 17:56:40.3461673 -07:00 |
SQL Task B:Start, 17:56:40. |
Master.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Load Results[2]\SQL Task B |
| 2017-04-08 17:57:03.3932904 -07:00 |
Load Master Result Table:Start, 17:57:03. |
Master.dtsx |
\Package\Load Results\Load Master Result Table |
None |
\Master\Load Results[3]\Load Master Result Table |
| 2017-04-08 17:57:03.4243240 -07:00 |
Load Master Result Table:Warning: The output column "my_id" (59) on output "Lookup Match Output" (58) and component "Lookup" (40) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
SSIS.Pipeline |
\Master\Load Results[3]\Load Master Result Table |
| 2017-04-08 17:57:03.4714866 -07:00 |
Load Master Result Table:Warning: The Lookup encountered duplicate reference key values when caching reference data. This error occurs in Full Cache mode only. Either remove the duplicate key values, or change the cache mode to PARTIAL or NO_CACHE.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
Lookup [40] |
\Master\Load Results[3]\Load Master Result Table |
| 2017-04-08 17:57:03.5184180 -07:00 |
Do Stuff:Start, 17:57:03. |
Master.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Load Results[3]\Do Stuff |
| 2017-04-08 17:57:03.5184180 -07:00 |
SQL Task B:Start, 17:57:03. |
Master.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Load Results[3]\SQL Task B |
| 2017-04-08 17:57:36.5372599 -07:00 |
Load Master Result Table:Start, 17:57:36. |
Master.dtsx |
\Package\Load Results\Load Master Result Table |
None |
\Master\Load Results[4]\Load Master Result Table |
| 2017-04-08 17:57:36.6615505 -07:00 |
Load Master Result Table:Warning: The output column "my_id" (59) on output "Lookup Match Output" (58) and component "Lookup" (40) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
SSIS.Pipeline |
\Master\Load Results[4]\Load Master Result Table |
| 2017-04-08 17:57:36.8495827 -07:00 |
Load Master Result Table:Warning: The Lookup encountered duplicate reference key values when caching reference data. This error occurs in Full Cache mode only. Either remove the duplicate key values, or change the cache mode to PARTIAL or NO_CACHE.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
Lookup [40] |
\Master\Load Results[4]\Load Master Result Table |
| 2017-04-08 17:57:36.8959302 -07:00 |
Do Stuff:Start, 17:57:36. |
Master.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Load Results[4]\Do Stuff |
| 2017-04-08 17:58:19.8945452 -07:00 |
Load Master Result Table:Start, 17:58:19. |
Master.dtsx |
\Package\Load Results\Load Master Result Table |
None |
\Master\Load Results[5]\Load Master Result Table |
| 2017-04-08 17:58:20.0039220 -07:00 |
Load Master Result Table:Warning: The output column "my_id" (59) on output "Lookup Match Output" (58) and component "Lookup" (40) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
SSIS.Pipeline |
\Master\Load Results[5]\Load Master Result Table |
| 2017-04-08 17:58:20.3791303 -07:00 |
Load Master Result Table:Warning: The Lookup encountered duplicate reference key values when caching reference data. This error occurs in Full Cache mode only. Either remove the duplicate key values, or change the cache mode to PARTIAL or NO_CACHE.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
Lookup [40] |
\Master\Load Results[5]\Load Master Result Table |
| 2017-04-08 17:58:20.6913847 -07:00 |
Do Stuff:Start, 17:58:20. |
Master.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Load Results[5]\Do Stuff |
| 2017-04-08 17:58:20.6913847 -07:00 |
SQL Task B:Start, 17:58:20. |
Master.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Load Results[5]\SQL Task B |
| 2017-04-08 17:59:13.7135870 -07:00 |
Say Bye:Start, 17:59:13. |
Master.dtsx |
\Package\SayBye\Say Bye |
None |
\Master\SayBye\Say Bye |
| 2017-04-08 17:59:13.7135870 -07:00 |
Drop Results Table:Start, 17:59:13. |
Master.dtsx |
\Package\Drop Results Table |
None |
\Master\Drop Results Table |
| 2017-04-08 17:59:13.7135870 -07:00 |
SayBye:Start, 17:59:13. |
Master.dtsx |
\Package\SayBye |
None |
\Master\SayBye |
| 2017-04-08 17:59:13.7285097 -07:00 |
Say Bye Once More:Start, 17:59:13. |
Master.dtsx |
\Package\SayBye\Say Bye Once More |
None |
\Master\SayBye\Say Bye Once More |
