Fork me on GitHub 
364
Events
35
Warnings
0
Memory Warnings
16
Duplicate Warnings
Message Time Message Package Package Path Subcomponent Name Execution Path
2017-04-09 19:29:57.8437327 -07:00 Load Child Results Table:Warning: Warning: Could not open global shared memory to communicate with performance DLL; data flow performance counters are not available. To resolve, run this package as an administrator, or on the system's console. Child.dtsx \Package\Load Results\Load Child Results Table SSIS.Pipeline \Master\Execute Child Package\Child\Load Results[1]\Load Child Results Table
2017-04-09 19:29:57.8437327 -07:00 Load Child Results Table:Warning: The output column "my_id_a" (59) on output "Lookup Match Output" (58) and component "Lookup A" (40) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance. Child.dtsx \Package\Load Results\Load Child Results Table SSIS.Pipeline \Master\Execute Child Package\Child\Load Results[1]\Load Child Results Table
2017-04-09 19:29:57.8437327 -07:00 Load Child Results Table:Warning: The output column "my_id_b" (84) on output "Lookup Match Output" (83) and component "Lookup B" (65) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance. Child.dtsx \Package\Load Results\Load Child Results Table SSIS.Pipeline \Master\Execute Child Package\Child\Load Results[1]\Load Child Results Table
2017-04-09 19:29:57.8437327 -07:00 Load Child Results Table:Warning: The output column "my_id" (109) on output "Lookup Match Output" (108) and component "Lookup C" (90) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance. Child.dtsx \Package\Load Results\Load Child Results Table SSIS.Pipeline \Master\Execute Child Package\Child\Load Results[1]\Load Child Results Table
2017-04-09 19:29:58.0779905 -07:00 Load Child Results Table:Warning: The Lookup B encountered duplicate reference key values when caching reference data. This error occurs in Full Cache mode only. Either remove the duplicate key values, or change the cache mode to PARTIAL or NO_CACHE. Child.dtsx \Package\Load Results\Load Child Results Table Lookup B [65] \Master\Execute Child Package\Child\Load Results[1]\Load Child Results Table
2017-04-09 19:29:58.2023449 -07:00 Load Child Results Table:Warning: The Lookup A encountered duplicate reference key values when caching reference data. This error occurs in Full Cache mode only. Either remove the duplicate key values, or change the cache mode to PARTIAL or NO_CACHE. Child.dtsx \Package\Load Results\Load Child Results Table Lookup A [40] \Master\Execute Child Package\Child\Load Results[1]\Load Child Results Table
2017-04-09 19:29:58.2179873 -07:00 Load Child Results Table:Warning: The Lookup C encountered duplicate reference key values when caching reference data. This error occurs in Full Cache mode only. Either remove the duplicate key values, or change the cache mode to PARTIAL or NO_CACHE. Child.dtsx \Package\Load Results\Load Child Results Table Lookup C [90] \Master\Execute Child Package\Child\Load Results[1]\Load Child Results Table
2017-04-09 19:29:59.4368111 -07:00 Load Child Results Table:Warning: The output column "my_id_a" (59) on output "Lookup Match Output" (58) and component "Lookup A" (40) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance. Child.dtsx \Package\Load Results\Load Child Results Table SSIS.Pipeline \Master\Execute Child Package\Child\Load Results[2]\Load Child Results Table
2017-04-09 19:29:59.4368111 -07:00 Load Child Results Table:Warning: The output column "my_id_b" (84) on output "Lookup Match Output" (83) and component "Lookup B" (65) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance. Child.dtsx \Package\Load Results\Load Child Results Table SSIS.Pipeline \Master\Execute Child Package\Child\Load Results[2]\Load Child Results Table
2017-04-09 19:29:59.4368111 -07:00 Load Child Results Table:Warning: The output column "my_id" (109) on output "Lookup Match Output" (108) and component "Lookup C" (90) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance. Child.dtsx \Package\Load Results\Load Child Results Table SSIS.Pipeline \Master\Execute Child Package\Child\Load Results[2]\Load Child Results Table
2017-04-09 19:29:59.4837072 -07:00 Load Child Results Table:Warning: The Lookup B encountered duplicate reference key values when caching reference data. This error occurs in Full Cache mode only. Either remove the duplicate key values, or change the cache mode to PARTIAL or NO_CACHE. Child.dtsx \Package\Load Results\Load Child Results Table Lookup B [65] \Master\Execute Child Package\Child\Load Results[2]\Load Child Results Table
2017-04-09 19:29:59.5151460 -07:00 Load Child Results Table:Warning: The Lookup A encountered duplicate reference key values when caching reference data. This error occurs in Full Cache mode only. Either remove the duplicate key values, or change the cache mode to PARTIAL or NO_CACHE. Child.dtsx \Package\Load Results\Load Child Results Table Lookup A [40] \Master\Execute Child Package\Child\Load Results[2]\Load Child Results Table
2017-04-09 19:29:59.5311201 -07:00 Load Child Results Table:Warning: The Lookup C encountered duplicate reference key values when caching reference data. This error occurs in Full Cache mode only. Either remove the duplicate key values, or change the cache mode to PARTIAL or NO_CACHE. Child.dtsx \Package\Load Results\Load Child Results Table Lookup C [90] \Master\Execute Child Package\Child\Load Results[2]\Load Child Results Table
2017-04-09 19:30:01.7336339 -07:00 Load Child Results Table:Warning: The output column "my_id_a" (59) on output "Lookup Match Output" (58) and component "Lookup A" (40) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance. Child.dtsx \Package\Load Results\Load Child Results Table SSIS.Pipeline \Master\Execute Child Package\Child\Load Results[3]\Load Child Results Table
2017-04-09 19:30:01.7336339 -07:00 Load Child Results Table:Warning: The output column "my_id_b" (84) on output "Lookup Match Output" (83) and component "Lookup B" (65) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance. Child.dtsx \Package\Load Results\Load Child Results Table SSIS.Pipeline \Master\Execute Child Package\Child\Load Results[3]\Load Child Results Table
2017-04-09 19:30:01.7336339 -07:00 Load Child Results Table:Warning: The output column "my_id" (109) on output "Lookup Match Output" (108) and component "Lookup C" (90) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance. Child.dtsx \Package\Load Results\Load Child Results Table SSIS.Pipeline \Master\Execute Child Package\Child\Load Results[3]\Load Child Results Table
2017-04-09 19:30:01.7805406 -07:00 Load Child Results Table:Warning: The Lookup B encountered duplicate reference key values when caching reference data. This error occurs in Full Cache mode only. Either remove the duplicate key values, or change the cache mode to PARTIAL or NO_CACHE. Child.dtsx \Package\Load Results\Load Child Results Table Lookup B [65] \Master\Execute Child Package\Child\Load Results[3]\Load Child Results Table
2017-04-09 19:30:01.8117282 -07:00 Load Child Results Table:Warning: The Lookup A encountered duplicate reference key values when caching reference data. This error occurs in Full Cache mode only. Either remove the duplicate key values, or change the cache mode to PARTIAL or NO_CACHE. Child.dtsx \Package\Load Results\Load Child Results Table Lookup A [40] \Master\Execute Child Package\Child\Load Results[3]\Load Child Results Table
2017-04-09 19:30:01.8279940 -07:00 Load Child Results Table:Warning: The Lookup C encountered duplicate reference key values when caching reference data. This error occurs in Full Cache mode only. Either remove the duplicate key values, or change the cache mode to PARTIAL or NO_CACHE. Child.dtsx \Package\Load Results\Load Child Results Table Lookup C [90] \Master\Execute Child Package\Child\Load Results[3]\Load Child Results Table
2017-04-09 19:30:05.0230984 -07:00 Load Child Results Table:Warning: The output column "my_id_a" (59) on output "Lookup Match Output" (58) and component "Lookup A" (40) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance. Child.dtsx \Package\Load Results\Load Child Results Table SSIS.Pipeline \Master\Execute Child Package\Child\Load Results[4]\Load Child Results Table
2017-04-09 19:30:05.0230984 -07:00 Load Child Results Table:Warning: The output column "my_id_b" (84) on output "Lookup Match Output" (83) and component "Lookup B" (65) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance. Child.dtsx \Package\Load Results\Load Child Results Table SSIS.Pipeline \Master\Execute Child Package\Child\Load Results[4]\Load Child Results Table
2017-04-09 19:30:05.0230984 -07:00 Load Child Results Table:Warning: The output column "my_id" (109) on output "Lookup Match Output" (108) and component "Lookup C" (90) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance. Child.dtsx \Package\Load Results\Load Child Results Table SSIS.Pipeline \Master\Execute Child Package\Child\Load Results[4]\Load Child Results Table
2017-04-09 19:30:05.0699446 -07:00 Load Child Results Table:Warning: The Lookup B encountered duplicate reference key values when caching reference data. This error occurs in Full Cache mode only. Either remove the duplicate key values, or change the cache mode to PARTIAL or NO_CACHE. Child.dtsx \Package\Load Results\Load Child Results Table Lookup B [65] \Master\Execute Child Package\Child\Load Results[4]\Load Child Results Table
2017-04-09 19:30:05.1018794 -07:00 Load Child Results Table:Warning: The Lookup A encountered duplicate reference key values when caching reference data. This error occurs in Full Cache mode only. Either remove the duplicate key values, or change the cache mode to PARTIAL or NO_CACHE. Child.dtsx \Package\Load Results\Load Child Results Table Lookup A [40] \Master\Execute Child Package\Child\Load Results[4]\Load Child Results Table
2017-04-09 19:30:05.1168788 -07:00 Load Child Results Table:Warning: The Lookup C encountered duplicate reference key values when caching reference data. This error occurs in Full Cache mode only. Either remove the duplicate key values, or change the cache mode to PARTIAL or NO_CACHE. Child.dtsx \Package\Load Results\Load Child Results Table Lookup C [90] \Master\Execute Child Package\Child\Load Results[4]\Load Child Results Table
2017-04-09 19:30:09.3198276 -07:00 Load Child Results Table:Warning: The output column "my_id_a" (59) on output "Lookup Match Output" (58) and component "Lookup A" (40) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance. Child.dtsx \Package\Load Results\Load Child Results Table SSIS.Pipeline \Master\Execute Child Package\Child\Load Results[5]\Load Child Results Table
2017-04-09 19:30:09.3198276 -07:00 Load Child Results Table:Warning: The output column "my_id_b" (84) on output "Lookup Match Output" (83) and component "Lookup B" (65) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance. Child.dtsx \Package\Load Results\Load Child Results Table SSIS.Pipeline \Master\Execute Child Package\Child\Load Results[5]\Load Child Results Table
2017-04-09 19:30:09.3198276 -07:00 Load Child Results Table:Warning: The output column "my_id" (109) on output "Lookup Match Output" (108) and component "Lookup C" (90) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance. Child.dtsx \Package\Load Results\Load Child Results Table SSIS.Pipeline \Master\Execute Child Package\Child\Load Results[5]\Load Child Results Table
2017-04-09 19:30:09.3829983 -07:00 Load Child Results Table:Warning: The Lookup B encountered duplicate reference key values when caching reference data. This error occurs in Full Cache mode only. Either remove the duplicate key values, or change the cache mode to PARTIAL or NO_CACHE. Child.dtsx \Package\Load Results\Load Child Results Table Lookup B [65] \Master\Execute Child Package\Child\Load Results[5]\Load Child Results Table
2017-04-09 19:30:09.4137016 -07:00 Load Child Results Table:Warning: The Lookup A encountered duplicate reference key values when caching reference data. This error occurs in Full Cache mode only. Either remove the duplicate key values, or change the cache mode to PARTIAL or NO_CACHE. Child.dtsx \Package\Load Results\Load Child Results Table Lookup A [40] \Master\Execute Child Package\Child\Load Results[5]\Load Child Results Table
2017-04-09 19:30:09.4299446 -07:00 Load Child Results Table:Warning: The Lookup C encountered duplicate reference key values when caching reference data. This error occurs in Full Cache mode only. Either remove the duplicate key values, or change the cache mode to PARTIAL or NO_CACHE. Child.dtsx \Package\Load Results\Load Child Results Table Lookup C [90] \Master\Execute Child Package\Child\Load Results[5]\Load Child Results Table
2017-04-09 19:30:14.5859774 -07:00 Load Master Result Table:Warning: The output column "my_id" (59) on output "Lookup Match Output" (58) and component "Lookup" (40) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance. Master.dtsx \Package\Load Results\Load Master Result Table SSIS.Pipeline \Master\Load Results[1]\Load Master Result Table
2017-04-09 19:30:14.6170119 -07:00 Load Master Result Table:Warning: The Lookup encountered duplicate reference key values when caching reference data. This error occurs in Full Cache mode only. Either remove the duplicate key values, or change the cache mode to PARTIAL or NO_CACHE. Master.dtsx \Package\Load Results\Load Master Result Table Lookup [40] \Master\Load Results[1]\Load Master Result Table
2017-04-09 19:30:14.8520825 -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-09 19:30:27.6796485 -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