Fork me on GitHub 
480
Events
41
Warnings
0
Memory Warnings
20
Duplicate Warnings
Message Time Message Package Package Path Subcomponent Name Execution Path
2017-04-08 17:11:21.0775178 -07:00 Load Child Results Table:Warning: Warning: Could not open global shared memory to communicate with performance DLL; data flow performance counters are not available. To resolve, run this package as an administrator, or on the system's console. Child.dtsx \Package\Load Results\Load Child Results Table SSIS.Pipeline \Master\Execute Child Package\Child\Load Results[1]\Load Child Results Table
2017-04-08 17:11:21.0932756 -07:00 Load Child Results Table:Warning: The output column "my_id_a" (59) on output "Lookup Match Output" (58) and component "Lookup A" (40) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance. Child.dtsx \Package\Load Results\Load Child Results Table SSIS.Pipeline \Master\Execute Child Package\Child\Load Results[1]\Load Child Results Table
2017-04-08 17:11:21.0932756 -07:00 Load Child Results Table:Warning: The output column "my_id_b" (84) on output "Lookup Match Output" (83) and component "Lookup B" (65) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance. Child.dtsx \Package\Load Results\Load Child Results Table SSIS.Pipeline \Master\Execute Child Package\Child\Load Results[1]\Load Child Results Table
2017-04-08 17:11:21.0932756 -07:00 Load Child Results Table:Warning: The output column "my_id" (109) on output "Lookup Match Output" (108) and component "Lookup C" (90) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance. Child.dtsx \Package\Load Results\Load Child Results Table SSIS.Pipeline \Master\Execute Child Package\Child\Load Results[1]\Load Child Results Table
2017-04-08 17:11:21.2964654 -07:00 Load Child Results Table:Warning: The Lookup B encountered duplicate reference key values when caching reference data. This error occurs in Full Cache mode only. Either remove the duplicate key values, or change the cache mode to PARTIAL or NO_CACHE. Child.dtsx \Package\Load Results\Load Child Results Table Lookup B [65] \Master\Execute Child Package\Child\Load Results[1]\Load Child Results Table
2017-04-08 17:11:21.3124288 -07:00 Load Child Results Table:Warning: The Lookup C encountered duplicate reference key values when caching reference data. This error occurs in Full Cache mode only. Either remove the duplicate key values, or change the cache mode to PARTIAL or NO_CACHE. Child.dtsx \Package\Load Results\Load Child Results Table Lookup C [90] \Master\Execute Child Package\Child\Load Results[1]\Load Child Results Table
2017-04-08 17:11:21.4526187 -07:00 Load Child Results Table:Warning: The Lookup A encountered duplicate reference key values when caching reference data. This error occurs in Full Cache mode only. Either remove the duplicate key values, or change the cache mode to PARTIAL or NO_CACHE. Child.dtsx \Package\Load Results\Load Child Results Table Lookup A [40] \Master\Execute Child Package\Child\Load Results[1]\Load Child Results Table
2017-04-08 17:11:22.6244790 -07:00 Load Child Results Table:Warning: The output column "my_id_a" (59) on output "Lookup Match Output" (58) and component "Lookup A" (40) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance. Child.dtsx \Package\Load Results\Load Child Results Table SSIS.Pipeline \Master\Execute Child Package\Child\Load Results[2]\Load Child Results Table
2017-04-08 17:11:22.6244790 -07:00 Load Child Results Table:Warning: The output column "my_id_b" (84) on output "Lookup Match Output" (83) and component "Lookup B" (65) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance. Child.dtsx \Package\Load Results\Load Child Results Table SSIS.Pipeline \Master\Execute Child Package\Child\Load Results[2]\Load Child Results Table
2017-04-08 17:11:22.6244790 -07:00 Load Child Results Table:Warning: The output column "my_id" (109) on output "Lookup Match Output" (108) and component "Lookup C" (90) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance. Child.dtsx \Package\Load Results\Load Child Results Table SSIS.Pipeline \Master\Execute Child Package\Child\Load Results[2]\Load Child Results Table
2017-04-08 17:11:22.6877618 -07:00 Load Child Results Table:Warning: The Lookup B encountered duplicate reference key values when caching reference data. This error occurs in Full Cache mode only. Either remove the duplicate key values, or change the cache mode to PARTIAL or NO_CACHE. Child.dtsx \Package\Load Results\Load Child Results Table Lookup B [65] \Master\Execute Child Package\Child\Load Results[2]\Load Child Results Table
2017-04-08 17:11:22.7026799 -07:00 Load Child Results Table:Warning: The Lookup C encountered duplicate reference key values when caching reference data. This error occurs in Full Cache mode only. Either remove the duplicate key values, or change the cache mode to PARTIAL or NO_CACHE. Child.dtsx \Package\Load Results\Load Child Results Table Lookup C [90] \Master\Execute Child Package\Child\Load Results[2]\Load Child Results Table
2017-04-08 17:11:22.7652234 -07:00 Load Child Results Table:Warning: The Lookup A encountered duplicate reference key values when caching reference data. This error occurs in Full Cache mode only. Either remove the duplicate key values, or change the cache mode to PARTIAL or NO_CACHE. Child.dtsx \Package\Load Results\Load Child Results Table Lookup A [40] \Master\Execute Child Package\Child\Load Results[2]\Load Child Results Table
2017-04-08 17:11:24.9056352 -07:00 Load Child Results Table:Warning: The output column "my_id_a" (59) on output "Lookup Match Output" (58) and component "Lookup A" (40) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance. Child.dtsx \Package\Load Results\Load Child Results Table SSIS.Pipeline \Master\Execute Child Package\Child\Load Results[3]\Load Child Results Table
2017-04-08 17:11:24.9056352 -07:00 Load Child Results Table:Warning: The output column "my_id_b" (84) on output "Lookup Match Output" (83) and component "Lookup B" (65) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance. Child.dtsx \Package\Load Results\Load Child Results Table SSIS.Pipeline \Master\Execute Child Package\Child\Load Results[3]\Load Child Results Table
2017-04-08 17:11:24.9056352 -07:00 Load Child Results Table:Warning: The output column "my_id" (109) on output "Lookup Match Output" (108) and component "Lookup C" (90) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance. Child.dtsx \Package\Load Results\Load Child Results Table SSIS.Pipeline \Master\Execute Child Package\Child\Load Results[3]\Load Child Results Table
2017-04-08 17:11:24.9838998 -07:00 Load Child Results Table:Warning: The Lookup B encountered duplicate reference key values when caching reference data. This error occurs in Full Cache mode only. Either remove the duplicate key values, or change the cache mode to PARTIAL or NO_CACHE. Child.dtsx \Package\Load Results\Load Child Results Table Lookup B [65] \Master\Execute Child Package\Child\Load Results[3]\Load Child Results Table
2017-04-08 17:11:25.0158261 -07:00 Load Child Results Table:Warning: The Lookup C encountered duplicate reference key values when caching reference data. This error occurs in Full Cache mode only. Either remove the duplicate key values, or change the cache mode to PARTIAL or NO_CACHE. Child.dtsx \Package\Load Results\Load Child Results Table Lookup C [90] \Master\Execute Child Package\Child\Load Results[3]\Load Child Results Table
2017-04-08 17:11:25.0775076 -07:00 Load Child Results Table:Warning: The Lookup A encountered duplicate reference key values when caching reference data. This error occurs in Full Cache mode only. Either remove the duplicate key values, or change the cache mode to PARTIAL or NO_CACHE. Child.dtsx \Package\Load Results\Load Child Results Table Lookup A [40] \Master\Execute Child Package\Child\Load Results[3]\Load Child Results Table
2017-04-08 17:11:28.2400072 -07:00 Load Child Results Table:Warning: The output column "my_id_a" (59) on output "Lookup Match Output" (58) and component "Lookup A" (40) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance. Child.dtsx \Package\Load Results\Load Child Results Table SSIS.Pipeline \Master\Execute Child Package\Child\Load Results[4]\Load Child Results Table
2017-04-08 17:11:28.2400072 -07:00 Load Child Results Table:Warning: The output column "my_id_b" (84) on output "Lookup Match Output" (83) and component "Lookup B" (65) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance. Child.dtsx \Package\Load Results\Load Child Results Table SSIS.Pipeline \Master\Execute Child Package\Child\Load Results[4]\Load Child Results Table
2017-04-08 17:11:28.2400072 -07:00 Load Child Results Table:Warning: The output column "my_id" (109) on output "Lookup Match Output" (108) and component "Lookup C" (90) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance. Child.dtsx \Package\Load Results\Load Child Results Table SSIS.Pipeline \Master\Execute Child Package\Child\Load Results[4]\Load Child Results Table
2017-04-08 17:11:28.2868321 -07:00 Load Child Results Table:Warning: The Lookup B encountered duplicate reference key values when caching reference data. This error occurs in Full Cache mode only. Either remove the duplicate key values, or change the cache mode to PARTIAL or NO_CACHE. Child.dtsx \Package\Load Results\Load Child Results Table Lookup B [65] \Master\Execute Child Package\Child\Load Results[4]\Load Child Results Table
2017-04-08 17:11:28.3180518 -07:00 Load Child Results Table:Warning: The Lookup C encountered duplicate reference key values when caching reference data. This error occurs in Full Cache mode only. Either remove the duplicate key values, or change the cache mode to PARTIAL or NO_CACHE. Child.dtsx \Package\Load Results\Load Child Results Table Lookup C [90] \Master\Execute Child Package\Child\Load Results[4]\Load Child Results Table
2017-04-08 17:11:28.3658876 -07:00 Load Child Results Table:Warning: The Lookup A encountered duplicate reference key values when caching reference data. This error occurs in Full Cache mode only. Either remove the duplicate key values, or change the cache mode to PARTIAL or NO_CACHE. Child.dtsx \Package\Load Results\Load Child Results Table Lookup A [40] \Master\Execute Child Package\Child\Load Results[4]\Load Child Results Table
2017-04-08 17:11:32.5213635 -07:00 Load Child Results Table:Warning: The output column "my_id_a" (59) on output "Lookup Match Output" (58) and component "Lookup A" (40) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance. Child.dtsx \Package\Load Results\Load Child Results Table SSIS.Pipeline \Master\Execute Child Package\Child\Load Results[5]\Load Child Results Table
2017-04-08 17:11:32.5213635 -07:00 Load Child Results Table:Warning: The output column "my_id_b" (84) on output "Lookup Match Output" (83) and component "Lookup B" (65) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance. Child.dtsx \Package\Load Results\Load Child Results Table SSIS.Pipeline \Master\Execute Child Package\Child\Load Results[5]\Load Child Results Table
2017-04-08 17:11:32.5213635 -07:00 Load Child Results Table:Warning: The output column "my_id" (109) on output "Lookup Match Output" (108) and component "Lookup C" (90) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance. Child.dtsx \Package\Load Results\Load Child Results Table SSIS.Pipeline \Master\Execute Child Package\Child\Load Results[5]\Load Child Results Table
2017-04-08 17:11:32.5837158 -07:00 Load Child Results Table:Warning: The Lookup B encountered duplicate reference key values when caching reference data. This error occurs in Full Cache mode only. Either remove the duplicate key values, or change the cache mode to PARTIAL or NO_CACHE. Child.dtsx \Package\Load Results\Load Child Results Table Lookup B [65] \Master\Execute Child Package\Child\Load Results[5]\Load Child Results Table
2017-04-08 17:11:32.5993145 -07:00 Load Child Results Table:Warning: The Lookup C encountered duplicate reference key values when caching reference data. This error occurs in Full Cache mode only. Either remove the duplicate key values, or change the cache mode to PARTIAL or NO_CACHE. Child.dtsx \Package\Load Results\Load Child Results Table Lookup C [90] \Master\Execute Child Package\Child\Load Results[5]\Load Child Results Table
2017-04-08 17:11:32.6466855 -07:00 Load Child Results Table:Warning: The Lookup A encountered duplicate reference key values when caching reference data. This error occurs in Full Cache mode only. Either remove the duplicate key values, or change the cache mode to PARTIAL or NO_CACHE. Child.dtsx \Package\Load Results\Load Child Results Table Lookup A [40] \Master\Execute Child Package\Child\Load Results[5]\Load Child Results Table
2017-04-08 17:11:37.7557208 -07:00 Load Master Result Table:Warning: The output column "my_id" (59) on output "Lookup Match Output" (58) and component "Lookup" (40) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance. Master.dtsx \Package\Load Results\Load Master Result Table SSIS.Pipeline \Master\Load Results[1]\Load Master Result Table
2017-04-08 17:11:37.8184277 -07:00 Load Master Result Table:Warning: The Lookup encountered duplicate reference key values when caching reference data. This error occurs in Full Cache mode only. Either remove the duplicate key values, or change the cache mode to PARTIAL or NO_CACHE. Master.dtsx \Package\Load Results\Load Master Result Table Lookup [40] \Master\Load Results[1]\Load Master Result Table
2017-04-08 17:11:50.8962382 -07:00 Load Master Result Table:Warning: The output column "my_id" (59) on output "Lookup Match Output" (58) and component "Lookup" (40) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance. Master.dtsx \Package\Load Results\Load Master Result Table SSIS.Pipeline \Master\Load Results[2]\Load Master Result Table
2017-04-08 17:11:50.9588353 -07:00 Load Master Result Table:Warning: The Lookup encountered duplicate reference key values when caching reference data. This error occurs in Full Cache mode only. Either remove the duplicate key values, or change the cache mode to PARTIAL or NO_CACHE. Master.dtsx \Package\Load Results\Load Master Result Table Lookup [40] \Master\Load Results[2]\Load Master Result Table
2017-04-08 17:12:14.0214816 -07:00 Load Master Result Table:Warning: The output column "my_id" (59) on output "Lookup Match Output" (58) and component "Lookup" (40) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance. Master.dtsx \Package\Load Results\Load Master Result Table SSIS.Pipeline \Master\Load Results[3]\Load Master Result Table
2017-04-08 17:12:14.0841662 -07:00 Load Master Result Table:Warning: The Lookup encountered duplicate reference key values when caching reference data. This error occurs in Full Cache mode only. Either remove the duplicate key values, or change the cache mode to PARTIAL or NO_CACHE. Master.dtsx \Package\Load Results\Load Master Result Table Lookup [40] \Master\Load Results[3]\Load Master Result Table
2017-04-08 17:12:47.2088504 -07:00 Load Master Result Table:Warning: The output column "my_id" (59) on output "Lookup Match Output" (58) and component "Lookup" (40) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance. Master.dtsx \Package\Load Results\Load Master Result Table SSIS.Pipeline \Master\Load Results[4]\Load Master Result Table
2017-04-08 17:12:47.4277738 -07:00 Load Master Result Table:Warning: The Lookup encountered duplicate reference key values when caching reference data. This error occurs in Full Cache mode only. Either remove the duplicate key values, or change the cache mode to PARTIAL or NO_CACHE. Master.dtsx \Package\Load Results\Load Master Result Table Lookup [40] \Master\Load Results[4]\Load Master Result Table
2017-04-08 17:13:30.5216775 -07:00 Load Master Result Table:Warning: The output column "my_id" (59) on output "Lookup Match Output" (58) and component "Lookup" (40) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance. Master.dtsx \Package\Load Results\Load Master Result Table SSIS.Pipeline \Master\Load Results[5]\Load Master Result Table
2017-04-08 17:13:30.7403999 -07:00 Load Master Result Table:Warning: The Lookup encountered duplicate reference key values when caching reference data. This error occurs in Full Cache mode only. Either remove the duplicate key values, or change the cache mode to PARTIAL or NO_CACHE. Master.dtsx \Package\Load Results\Load Master Result Table Lookup [40] \Master\Load Results[5]\Load Master Result Table