Fork me on GitHub 
483
Events
41
Warnings
0
Memory Warnings
20
Duplicate Warnings
Message Time Message Package Package Path Subcomponent Name Execution Path
2017-04-09 19:26:28.0539914 -07:00 Child:Start, 19:26:28. Child.dtsx \Package None \Master\Execute Child Package\Child
2017-04-09 19:26:26.6317150 -07:00 Master:Validation has started. Master.dtsx \Package None \Master
2017-04-09 19:26:26.6317150 -07:00 Create Results Table:Validation has started. Master.dtsx \Package\Create Results Table None \Master\Create Results Table
2017-04-09 19:26:26.6476728 -07:00 Create Results Table:Validation is complete. Master.dtsx \Package\Create Results Table None \Master\Create Results Table
2017-04-09 19:26:26.6476728 -07:00 Drop Results Table:Validation has started. Master.dtsx \Package\Drop Results Table None \Master\Drop Results Table
2017-04-09 19:26:26.6476728 -07:00 Drop Results Table:Validation is complete. Master.dtsx \Package\Drop Results Table None \Master\Drop Results Table
2017-04-09 19:26:26.6476728 -07:00 Execute Child Package:Validation has started. Master.dtsx \Package\Execute Child Package None \Master\Execute Child Package
2017-04-09 19:26:26.6476728 -07:00 Execute Child Package:Validation is complete. Master.dtsx \Package\Execute Child Package None \Master\Execute Child Package
2017-04-09 19:26:26.6476728 -07:00 Handle Error:Validation has started. Master.dtsx \Package\Handle Error None \Master\Handle Error
2017-04-09 19:26:26.6476728 -07:00 Handle Error:Validation is complete. Master.dtsx \Package\Handle Error None \Master\Handle Error
2017-04-09 19:26:26.6476728 -07:00 Load Results:Validation has started. Master.dtsx \Package\Load Results None \Master\Load Results
2017-04-09 19:26:26.6476728 -07:00 Do Stuff:Validation has started. Master.dtsx \Package\Load Results\Do Stuff None \Master\Load Results\Do Stuff
2017-04-09 19:26:26.6476728 -07:00 Do Stuff:Validation is complete. Master.dtsx \Package\Load Results\Do Stuff None \Master\Load Results\Do Stuff
2017-04-09 19:26:26.6476728 -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-09 19:26:26.6476728 -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-09 19:26:26.6476728 -07:00 Load Results:Validation is complete. Master.dtsx \Package\Load Results None \Master\Load Results
2017-04-09 19:26:26.6476728 -07:00 SayBye:Validation has started. Master.dtsx \Package\SayBye None \Master\SayBye
2017-04-09 19:26:26.6476728 -07:00 Say Bye:Validation has started. Master.dtsx \Package\SayBye\Say Bye None \Master\SayBye\Say Bye
2017-04-09 19:26:26.6476728 -07:00 Say Bye:Validation is complete. Master.dtsx \Package\SayBye\Say Bye None \Master\SayBye\Say Bye
2017-04-09 19:26:26.6476728 -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-09 19:26:26.6476728 -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-09 19:26:26.6476728 -07:00 SayBye:Validation is complete. Master.dtsx \Package\SayBye None \Master\SayBye
2017-04-09 19:26:26.6476728 -07:00 SQL Task A:Validation has started. Master.dtsx \Package\SQL Task A None \Master\SQL Task A
2017-04-09 19:26:26.6476728 -07:00 SQL Task A:Validation is complete. Master.dtsx \Package\SQL Task A None \Master\SQL Task A
2017-04-09 19:26:26.6476728 -07:00 Write Message:Validation has started. Master.dtsx \Package\Write Message None \Master\Write Message
2017-04-09 19:26:26.6476728 -07:00 Write Message:Validation is complete. Master.dtsx \Package\Write Message None \Master\Write Message
2017-04-09 19:26:26.6476728 -07:00 Master:Validation is complete. Master.dtsx \Package None \Master
2017-04-09 19:26:26.8040336 -07:00 Master:Start, 19:26:26. Master.dtsx \Package None \Master
2017-04-09 19:26:26.8191809 -07:00 Create Results Table:Start, 19:26:26. Master.dtsx \Package\Create Results Table None \Master\Create Results Table
2017-04-09 19:26:26.8191809 -07:00 Create Results Table:Validation has started. Master.dtsx \Package\Create Results Table None \Master\Create Results Table
2017-04-09 19:26:26.8191809 -07:00 Create Results Table:Validation is complete. Master.dtsx \Package\Create Results Table None \Master\Create Results Table
2017-04-09 19:26:26.9445933 -07:00 Create Results Table:Finished, 19:26:26, Elapsed time: 00:00:00.125. Master.dtsx \Package\Create Results Table None \Master\Create Results Table
2017-04-09 19:26:26.9445933 -07:00 Write Message:Start, 19:26:26. Master.dtsx \Package\Write Message None \Master\Write Message
2017-04-09 19:26:26.9445933 -07:00 Write Message:Validation has started. Master.dtsx \Package\Write Message None \Master\Write Message
2017-04-09 19:26:26.9445933 -07:00 Write Message:Validation is complete. Master.dtsx \Package\Write Message None \Master\Write Message
2017-04-09 19:26:26.8191809 -07:00 SQL Task A:Start, 19:26:26. Master.dtsx \Package\SQL Task A None \Master\SQL Task A
2017-04-09 19:26:26.8191809 -07:00 SQL Task A:Validation has started. Master.dtsx \Package\SQL Task A None \Master\SQL Task A
2017-04-09 19:26:26.8191809 -07:00 SQL Task A:Validation is complete. Master.dtsx \Package\SQL Task A None \Master\SQL Task A
2017-04-09 19:26:27.9756641 -07:00 Write Message:Information: Hi there, this is Sample 1 Master.dtsx \Package\Write Message None \Master\Write Message
2017-04-09 19:26:27.9756641 -07:00 Write Message:Finished, 19:26:27, Elapsed time: 00:00:01.031. Master.dtsx \Package\Write Message None \Master\Write Message
2017-04-09 19:26:27.9756641 -07:00 Execute Child Package:Start, 19:26:27. Master.dtsx \Package\Execute Child Package None \Master\Execute Child Package
2017-04-09 19:26:27.9756641 -07:00 Execute Child Package:Validation has started. Master.dtsx \Package\Execute Child Package None \Master\Execute Child Package
2017-04-09 19:26:27.9756641 -07:00 Execute Child Package:Validation is complete. Master.dtsx \Package\Execute Child Package None \Master\Execute Child Package
2017-04-09 19:26:28.0379643 -07:00 Child:Validation has started. Child.dtsx \Package None \Master\Execute Child Package\Child
2017-04-09 19:26:28.0379643 -07:00 Call Grandchild:Validation has started. Child.dtsx \Package\Call Grandchild None \Master\Execute Child Package\Child\Call Grandchild
2017-04-09 19:26:28.0379643 -07:00 Call Grandchild:Validation is complete. Child.dtsx \Package\Call Grandchild None \Master\Execute Child Package\Child\Call Grandchild
2017-04-09 19:26:28.0379643 -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-09 19:26:28.0379643 -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-09 19:26:28.0379643 -07:00 Load Results:Validation has started. Child.dtsx \Package\Load Results None \Master\Execute Child Package\Child\Load Results
2017-04-09 19:26:28.0379643 -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-09 19:26:28.0379643 -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-09 19:26:28.0379643 -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-09 19:26:28.0379643 -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-09 19:26:28.0379643 -07:00 Load Results:Validation is complete. Child.dtsx \Package\Load Results None \Master\Execute Child Package\Child\Load Results
2017-04-09 19:26:28.0379643 -07:00 Child:Validation is complete. Child.dtsx \Package None \Master\Execute Child Package\Child
2017-04-09 19:26:28.0379643 -07:00 Child:Validation has started. Child.dtsx \Package None \Master\Execute Child Package\Child
2017-04-09 19:26:28.0379643 -07:00 Call Grandchild:Validation has started. Child.dtsx \Package\Call Grandchild None \Master\Execute Child Package\Child\Call Grandchild
2017-04-09 19:26:28.0379643 -07:00 Call Grandchild:Validation is complete. Child.dtsx \Package\Call Grandchild None \Master\Execute Child Package\Child\Call Grandchild
2017-04-09 19:26:28.0539914 -07:00 Create Results Table:Start, 19:26:28. Child.dtsx \Package\Create Results Table None \Master\Execute Child Package\Child\Create Results Table
2017-04-09 19:26:28.0539914 -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-09 19:26:28.0539914 -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-09 19:26:28.0690937 -07:00 Create Results Table:Finished, 19:26:28, Elapsed time: 00:00:00.015. Child.dtsx \Package\Create Results Table None \Master\Execute Child Package\Child\Create Results Table
2017-04-09 19:26:28.0690937 -07:00 Load Results:Start, 19:26:28. Child.dtsx \Package\Load Results None \Master\Execute Child Package\Child\Load Results
2017-04-09 19:26:28.0690937 -07:00 Load Child Results Table:Start, 19:26:28. Child.dtsx \Package\Load Results\Load Child Results Table None \Master\Execute Child Package\Child\Load Results[1]\Load Child Results Table
2017-04-09 19:26:28.0690937 -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-09 19:26:28.0690937 -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-09 19:26:28.2880431 -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-09 19:26:28.2880431 -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:26:28.3035162 -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:26:28.3035162 -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:26:28.3035162 -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:26:28.3035162 -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-09 19:26:28.3195020 -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-09 19:26:28.5539673 -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-09 19:26:28.5539673 -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-09 19:26:28.5539673 -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:26:28.5539673 -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-09 19:26:28.5539673 -07:00 Load Child Results Table:Information: The Lookup C processed 505 rows in the cache. The processing time was 0.219 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-09 19:26:28.0690937 -07:00 Call Grandchild:Start, 19:26:28. Child.dtsx \Package\Call Grandchild None \Master\Execute Child Package\Child\Call Grandchild
2017-04-09 19:26:28.0690937 -07:00 Call Grandchild:Validation has started. Child.dtsx \Package\Call Grandchild None \Master\Execute Child Package\Child\Call Grandchild
2017-04-09 19:26:28.0690937 -07:00 Call Grandchild:Validation is complete. Child.dtsx \Package\Call Grandchild None \Master\Execute Child Package\Child\Call Grandchild
2017-04-09 19:26:28.1003334 -07:00 Grandchild:Validation has started. Grandchild.dtsx \Package None \Master\Execute Child Package\Child\Call Grandchild\Grandchild
2017-04-09 19:26:28.1003334 -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-09 19:26:28.1003334 -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-09 19:26:28.1003334 -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-09 19:26:28.1003334 -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-09 19:26:28.1003334 -07:00 Grandchild:Validation is complete. Grandchild.dtsx \Package None \Master\Execute Child Package\Child\Call Grandchild\Grandchild
2017-04-09 19:26:28.1003334 -07:00 Grandchild:Validation has started. Grandchild.dtsx \Package None \Master\Execute Child Package\Child\Call Grandchild\Grandchild
2017-04-09 19:26:28.1003334 -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-09 19:26:28.1003334 -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-09 19:26:28.1003334 -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-09 19:26:28.1003334 -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-09 19:26:28.1003334 -07:00 Grandchild:Validation is complete. Grandchild.dtsx \Package None \Master\Execute Child Package\Child\Call Grandchild\Grandchild
2017-04-09 19:26:29.7880115 -07:00 SQL Task B:Start, 19:26:29. Child.dtsx \Package\Load Results\SQL Task B None \Master\Execute Child Package\Child\Load Results[1]\SQL Task B
2017-04-09 19:26:29.7880115 -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-09 19:26:29.7880115 -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-09 19:26:28.1003334 -07:00 Grandchild:Start, 19:26:28. Grandchild.dtsx \Package None \Master\Execute Child Package\Child\Call Grandchild\Grandchild
2017-04-09 19:26:28.0379643 -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-09 19:26:28.0379643 -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-09 19:26:28.0379643 -07:00 Load Results:Validation has started. Child.dtsx \Package\Load Results None \Master\Execute Child Package\Child\Load Results
2017-04-09 19:26:28.0379643 -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-09 19:26:28.0379643 -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-09 19:26:28.0379643 -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-09 19:26:28.0379643 -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-09 19:26:28.0379643 -07:00 Load Results:Validation is complete. Child.dtsx \Package\Load Results None \Master\Execute Child Package\Child\Load Results
2017-04-09 19:26:28.0539914 -07:00 Child:Validation is complete. Child.dtsx \Package None \Master\Execute Child Package\Child
2017-04-09 19:26:28.1003334 -07:00 Do Something:Start, 19:26:28. Grandchild.dtsx \Package\Do Something None \Master\Execute Child Package\Child\Call Grandchild\Grandchild\Do Something
2017-04-09 19:26:28.1003334 -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-09 19:26:28.1003334 -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-09 19:26:28.1318536 -07:00 Do Something:Finished, 19:26:28, Elapsed time: 00:00:00.032. Grandchild.dtsx \Package\Do Something None \Master\Execute Child Package\Child\Call Grandchild\Grandchild\Do Something
2017-04-09 19:26:28.1318536 -07:00 Play with Username:Start, 19:26:28. Grandchild.dtsx \Package\Play with Username None \Master\Execute Child Package\Child\Call Grandchild\Grandchild\Play with Username
2017-04-09 19:26:28.1318536 -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-09 19:26:28.1318536 -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-09 19:26:28.1318536 -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-09 19:26:28.9284833 -07:00 SQL Task A:Finished, 19:26:28, Elapsed time: 00:00:02.110. Master.dtsx \Package\SQL Task A None \Master\SQL Task A
2017-04-09 19:26:29.7723482 -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-09 19:26:29.7723482 -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-09 19:26:29.7723482 -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-09 19:26:29.7723482 -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-09 19:26:29.2566765 -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-09 19:26:29.3817389 -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-09 19:26:29.3817389 -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:26:29.3973087 -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-09 19:26:29.3973087 -07:00 Load Child Results Table:Information: The Lookup B processed 55 rows in the cache. The processing time was 0.531 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-09 19:26:29.6632315 -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-09 19:26:29.6632315 -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-09 19:26:29.6632315 -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:26:29.6632315 -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-09 19:26:29.6632315 -07:00 Load Child Results Table:Information: The Lookup A processed 1505 rows in the cache. The processing time was 0.266 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-09 19:26:29.7575744 -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-09 19:26:29.7723482 -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-09 19:26:29.7880115 -07:00 Load Child Results Table:Information: "DST - Bad" wrote 312 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-09 19:26:29.7880115 -07:00 Load Child Results Table:Information: "DST - Good" wrote 89 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-09 19:26:29.7880115 -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-09 19:26:29.7880115 -07:00 Load Child Results Table:Finished, 19:26:29, Elapsed time: 00:00:01.719. Child.dtsx \Package\Load Results\Load Child Results Table None \Master\Execute Child Package\Child\Load Results[1]\Load Child Results Table
2017-04-09 19:26:29.7880115 -07:00 Do Stuff:Start, 19:26:29. Child.dtsx \Package\Load Results\Do Stuff None \Master\Execute Child Package\Child\Load Results[1]\Do Stuff
2017-04-09 19:26:29.7880115 -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-09 19:26:29.7880115 -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-09 19:26:29.8034832 -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-09 19:26:30.8034790 -07:00 SQL Task B:Finished, 19:26:30, Elapsed time: 00:00:01.016. Child.dtsx \Package\Load Results\SQL Task B None \Master\Execute Child Package\Child\Load Results[1]\SQL Task B
2017-04-09 19:26:30.8034790 -07:00 Load Child Results Table:Start, 19:26:30. Child.dtsx \Package\Load Results\Load Child Results Table None \Master\Execute Child Package\Child\Load Results[2]\Load Child Results Table
2017-04-09 19:26:30.8034790 -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-09 19:26:30.8034790 -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-09 19:26:31.0070875 -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-09 19:26:31.0070875 -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:26:31.0070875 -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:26:31.0070875 -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:26:31.0070875 -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-09 19:26:31.0380294 -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-09 19:26:31.2725710 -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-09 19:26:31.2725710 -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:26:31.2725710 -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-09 19:26:31.2725710 -07:00 Load Child Results Table:Information: The Lookup C processed 505 rows in the cache. The processing time was 0.218 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-09 19:26:29.8034832 -07:00 Do Stuff:Finished, 19:26:29, Elapsed time: 00:00:00.016. Child.dtsx \Package\Load Results\Do Stuff None \Master\Execute Child Package\Child\Load Results[1]\Do Stuff
2017-04-09 19:26:32.1942925 -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-09 19:26:32.1942925 -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:26:32.2097716 -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-09 19:26:32.2097716 -07:00 Load Child Results Table:Information: The Lookup B processed 55 rows in the cache. The processing time was 0.328 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-09 19:26:32.3035516 -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-09 19:26:32.3035516 -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:26:32.3035516 -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-09 19:26:32.3035516 -07:00 Load Child Results Table:Information: The Lookup A processed 1505 rows in the cache. The processing time was 0.094 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-09 19:26:32.3355100 -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-09 19:26:32.3504778 -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-09 19:26:32.3664450 -07:00 Load Child Results Table:Information: "DST - Bad" wrote 1451 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-09 19:26:32.3664450 -07:00 Load Child Results Table:Information: "DST - Good" wrote 415 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-09 19:26:32.3664450 -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-09 19:26:32.3664450 -07:00 Load Child Results Table:Finished, 19:26:32, Elapsed time: 00:00:01.562. Child.dtsx \Package\Load Results\Load Child Results Table None \Master\Execute Child Package\Child\Load Results[2]\Load Child Results Table
2017-04-09 19:26:32.3504778 -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-09 19:26:32.3504778 -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-09 19:26:32.3664450 -07:00 Do Stuff:Start, 19:26:32. Child.dtsx \Package\Load Results\Do Stuff None \Master\Execute Child Package\Child\Load Results[2]\Do Stuff
2017-04-09 19:26:32.3664450 -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-09 19:26:32.3664450 -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-09 19:26:32.3664450 -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-09 19:26:32.3664450 -07:00 Do Stuff:Finished, 19:26:32, 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-09 19:26:32.3664450 -07:00 SQL Task B:Start, 19:26:32. Child.dtsx \Package\Load Results\SQL Task B None \Master\Execute Child Package\Child\Load Results[2]\SQL Task B
2017-04-09 19:26:32.3664450 -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-09 19:26:32.3664450 -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-09 19:26:32.3504778 -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-09 19:26:32.3504778 -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-09 19:26:33.1638298 -07:00 Call Grandchild:Finished, 19:26:33, Elapsed time: 00:00:05.094. Child.dtsx \Package\Call Grandchild None \Master\Execute Child Package\Child\Call Grandchild
2017-04-09 19:26:33.1478877 -07:00 Grandchild:Finished, 19:26:33, Elapsed time: 00:00:05.047. Grandchild.dtsx \Package None \Master\Execute Child Package\Child\Call Grandchild\Grandchild
2017-04-09 19:26:33.1478877 -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-09 19:26:33.1478877 -07:00 Play with Username:Finished, 19:26:33, 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-09 19:26:34.3978912 -07:00 Load Child Results Table:Start, 19:26:34. Child.dtsx \Package\Load Results\Load Child Results Table None \Master\Execute Child Package\Child\Load Results[3]\Load Child Results Table
2017-04-09 19:26:34.3978912 -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-09 19:26:34.3978912 -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-09 19:26:34.4910124 -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-09 19:26:34.4910124 -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:27:57.1976692 -07:00 Do Stuff:Start, 19:27:57. Master.dtsx \Package\Load Results\Do Stuff None \Master\Load Results[4]\Do Stuff
2017-04-09 19:27:57.1976692 -07:00 Do Stuff:Validation has started. Master.dtsx \Package\Load Results\Do Stuff None \Master\Load Results[4]\Do Stuff
2017-04-09 19:26:34.5066130 -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:26:34.5066130 -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:26:34.5066130 -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-09 19:26:34.5378517 -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-09 19:26:34.5535127 -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[3]\Load Child Results Table
2017-04-09 19:26:34.5535127 -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-09 19:26:34.5535127 -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:26:34.5535127 -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-09 19:26:34.5535127 -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[3]\Load Child Results Table
2017-04-09 19:26:34.3978912 -07:00 SQL Task B:Finished, 19:26:34, Elapsed time: 00:00:02.031. Child.dtsx \Package\Load Results\SQL Task B None \Master\Execute Child Package\Child\Load Results[2]\SQL Task B
2017-04-09 19:26:34.6474095 -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[3]\Load Child Results Table
2017-04-09 19:26:34.6474095 -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-09 19:26:34.6474095 -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:26:34.6474095 -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-09 19:26:34.6474095 -07:00 Load Child Results Table:Information: The Lookup B processed 55 rows in the cache. The processing time was 0.031 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-09 19:26:34.6793489 -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[3]\Load Child Results Table
2017-04-09 19:26:34.6793489 -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-09 19:26:34.6793489 -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:26:34.6793489 -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-09 19:26:34.6793489 -07:00 Load Child Results Table:Information: The Lookup A processed 1505 rows in the cache. The processing time was 0.032 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-09 19:26:34.6942213 -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-09 19:26:34.7150191 -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-09 19:26:34.7256820 -07:00 Load Child Results Table:Information: "DST - Bad" wrote 1287 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-09 19:26:34.7256820 -07:00 Load Child Results Table:Information: "DST - Good" wrote 357 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-09 19:26:34.7256820 -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-09 19:26:34.7256820 -07:00 Load Child Results Table:Finished, 19:26:34, Elapsed time: 00:00:00.328. Child.dtsx \Package\Load Results\Load Child Results Table None \Master\Execute Child Package\Child\Load Results[3]\Load Child Results Table
2017-04-09 19:26:34.7256820 -07:00 Do Stuff:Start, 19:26:34. Child.dtsx \Package\Load Results\Do Stuff None \Master\Execute Child Package\Child\Load Results[3]\Do Stuff
2017-04-09 19:26:34.7256820 -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-09 19:26:34.7256820 -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-09 19:26:34.7256820 -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-09 19:26:34.7256820 -07:00 Do Stuff:Finished, 19:26:34, 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-09 19:26:34.7256820 -07:00 SQL Task B:Start, 19:26:34. Child.dtsx \Package\Load Results\SQL Task B None \Master\Execute Child Package\Child\Load Results[3]\SQL Task B
2017-04-09 19:26:34.7256820 -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-09 19:26:34.7256820 -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-09 19:26:34.7150191 -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-09 19:26:34.7150191 -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-09 19:26:34.7150191 -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-09 19:26:34.7150191 -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-09 19:26:37.7572520 -07:00 Load Child Results Table:Start, 19:26:37. Child.dtsx \Package\Load Results\Load Child Results Table None \Master\Execute Child Package\Child\Load Results[4]\Load Child Results Table
2017-04-09 19:26:37.7572520 -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-09 19:26:37.7572520 -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-09 19:26:37.8509826 -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-09 19:26:37.8509826 -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:26:37.8509826 -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:26:37.8509826 -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:26:37.8509826 -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-09 19:26:37.8817003 -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-09 19:26:37.8973897 -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-09 19:26:37.8973897 -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:26:37.8973897 -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-09 19:26:37.8973897 -07:00 Load Child Results Table:Information: The Lookup C processed 505 rows in the cache. The processing time was 0.001 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-09 19:26:37.9447259 -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-09 19:26:37.9447259 -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:26:37.9447259 -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-09 19:26:37.9447259 -07:00 Load Child Results Table:Information: The Lookup B processed 55 rows in the cache. The processing time was 0.015 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-09 19:26:37.9597695 -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-09 19:26:37.9597695 -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:26:37.9597695 -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-09 19:26:37.9911711 -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-09 19:26:37.9911711 -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-09 19:26:37.7572520 -07:00 SQL Task B:Finished, 19:26:37, Elapsed time: 00:00:03.032. Child.dtsx \Package\Load Results\SQL Task B None \Master\Execute Child Package\Child\Load Results[3]\SQL Task B
2017-04-09 19:26:37.9597695 -07:00 Load Child Results Table:Information: The Lookup A processed 1505 rows in the cache. The processing time was 0.001 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-09 19:26:37.9756110 -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-09 19:26:37.9911711 -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-09 19:26:37.9911711 -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-09 19:26:37.9911711 -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-09 19:26:38.0070973 -07:00 Load Child Results Table:Information: "DST - Bad" wrote 961 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-09 19:26:38.0070973 -07:00 Load Child Results Table:Information: "DST - Good" wrote 283 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-09 19:26:38.0070973 -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-09 19:26:38.0070973 -07:00 Load Child Results Table:Finished, 19:26:38, Elapsed time: 00:00:00.250. Child.dtsx \Package\Load Results\Load Child Results Table None \Master\Execute Child Package\Child\Load Results[4]\Load Child Results Table
2017-04-09 19:26:38.0070973 -07:00 Do Stuff:Start, 19:26:38. Child.dtsx \Package\Load Results\Do Stuff None \Master\Execute Child Package\Child\Load Results[4]\Do Stuff
2017-04-09 19:26:38.0070973 -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-09 19:26:38.0070973 -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-09 19:26:38.0070973 -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-09 19:26:38.0070973 -07:00 Do Stuff:Finished, 19:26:38, Elapsed time: 00:00:00.000. Child.dtsx \Package\Load Results\Do Stuff None \Master\Execute Child Package\Child\Load Results[4]\Do Stuff
2017-04-09 19:26:38.0070973 -07:00 SQL Task B:Start, 19:26:38. Child.dtsx \Package\Load Results\SQL Task B None \Master\Execute Child Package\Child\Load Results[4]\SQL Task B
2017-04-09 19:26:38.0070973 -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-09 19:26:38.0070973 -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-09 19:26:42.0384463 -07:00 Load Child Results Table:Start, 19:26:42. Child.dtsx \Package\Load Results\Load Child Results Table None \Master\Execute Child Package\Child\Load Results[5]\Load Child Results Table
2017-04-09 19:26:42.0384463 -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-09 19:26:42.0384463 -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-09 19:26:42.0384463 -07:00 SQL Task B:Finished, 19:26:42, Elapsed time: 00:00:04.031. Child.dtsx \Package\Load Results\SQL Task B None \Master\Execute Child Package\Child\Load Results[4]\SQL Task B
2017-04-09 19:26:42.1476277 -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-09 19:26:42.1476277 -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:26:42.1476277 -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:26:42.1476277 -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:26:42.1476277 -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-09 19:26:42.1942120 -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-09 19:26:42.1942120 -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[5]\Load Child Results Table
2017-04-09 19:26:42.1942120 -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-09 19:26:42.2105211 -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:26:42.2105211 -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-09 19:26:42.2105211 -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[5]\Load Child Results Table
2017-04-09 19:26:42.2409950 -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[5]\Load Child Results Table
2017-04-09 19:26:42.2409950 -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-09 19:26:42.2409950 -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:26:42.2409950 -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-09 19:26:42.2574343 -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-09 19:26:42.2574343 -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[5]\Load Child Results Table
2017-04-09 19:26:42.2574343 -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-09 19:26:42.2723938 -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:26:42.2723938 -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-09 19:26:42.2878696 -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-09 19:26:42.2878696 -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-09 19:26:42.2878696 -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-09 19:26:42.2878696 -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-09 19:26:42.2723938 -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-09 19:26:42.2723938 -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-09 19:26:42.2878696 -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-09 19:26:42.3034934 -07:00 Load Child Results Table:Information: "DST - Bad" wrote 1278 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-09 19:26:42.3034934 -07:00 Load Child Results Table:Information: "DST - Good" wrote 366 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-09 19:26:42.3034934 -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-09 19:26:42.3034934 -07:00 Load Child Results Table:Finished, 19:26:42, Elapsed time: 00:00:00.266. Child.dtsx \Package\Load Results\Load Child Results Table None \Master\Execute Child Package\Child\Load Results[5]\Load Child Results Table
2017-04-09 19:26:42.3034934 -07:00 Do Stuff:Start, 19:26:42. Child.dtsx \Package\Load Results\Do Stuff None \Master\Execute Child Package\Child\Load Results[5]\Do Stuff
2017-04-09 19:26:42.3034934 -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-09 19:26:42.3034934 -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-09 19:26:42.3034934 -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-09 19:26:42.3034934 -07:00 Do Stuff:Finished, 19:26:42, Elapsed time: 00:00:00.000. Child.dtsx \Package\Load Results\Do Stuff None \Master\Execute Child Package\Child\Load Results[5]\Do Stuff
2017-04-09 19:26:42.3034934 -07:00 SQL Task B:Start, 19:26:42. Child.dtsx \Package\Load Results\SQL Task B None \Master\Execute Child Package\Child\Load Results[5]\SQL Task B
2017-04-09 19:26:42.3034934 -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-09 19:26:42.3034934 -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-09 19:26:47.3193982 -07:00 Load Results:Finished, 19:26:47, Elapsed time: 00:00:19.250. Child.dtsx \Package\Load Results None \Master\Execute Child Package\Child\Load Results
2017-04-09 19:26:47.3193982 -07:00 Child:Finished, 19:26:47, Elapsed time: 00:00:19.265. Child.dtsx \Package None \Master\Execute Child Package\Child
2017-04-09 19:26:47.3193982 -07:00 SQL Task B:Finished, 19:26:47, Elapsed time: 00:00:05.015. Child.dtsx \Package\Load Results\SQL Task B None \Master\Execute Child Package\Child\Load Results[5]\SQL Task B
2017-04-09 19:26:47.3352783 -07:00 Execute Child Package:Finished, 19:26:47, Elapsed time: 00:00:19.360. Master.dtsx \Package\Execute Child Package None \Master\Execute Child Package
2017-04-09 19:26:47.3352783 -07:00 Load Results:Start, 19:26:47. Master.dtsx \Package\Load Results None \Master\Load Results
2017-04-09 19:26:47.3352783 -07:00 Load Master Result Table:Start, 19:26:47. Master.dtsx \Package\Load Results\Load Master Result Table None \Master\Load Results[1]\Load Master Result Table
2017-04-09 19:26:47.3352783 -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-09 19:26:47.3352783 -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-09 19:26:47.3973823 -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-09 19:26:47.3973823 -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:26:47.3973823 -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-09 19:26:47.4288476 -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-09 19:26:47.4757390 -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-09 19:26:47.4757390 -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-09 19:26:47.4757390 -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:26:47.4757390 -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-09 19:26:47.4757390 -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-09 19:26:47.4910301 -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-09 19:26:47.4910301 -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-09 19:26:47.4910301 -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-09 19:26:47.4910301 -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-09 19:26:47.4910301 -07:00 Load Master Result Table:Information: "DST - Bad" wrote 1453 rows. Master.dtsx \Package\Load Results\Load Master Result Table SSIS.Pipeline \Master\Load Results[1]\Load Master Result Table
2017-04-09 19:26:47.4910301 -07:00 Load Master Result Table:Information: "DST - Good" wrote 413 rows. Master.dtsx \Package\Load Results\Load Master Result Table SSIS.Pipeline \Master\Load Results[1]\Load Master Result Table
2017-04-09 19:26:47.4910301 -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-09 19:26:47.4910301 -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-09 19:26:47.5070652 -07:00 SQL Task B:Start, 19:26:47. Master.dtsx \Package\Load Results\SQL Task B None \Master\Load Results[1]\SQL Task B
2017-04-09 19:26:47.5070652 -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-09 19:26:47.5070652 -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-09 19:26:47.4910301 -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-09 19:26:47.5070652 -07:00 Load Master Result Table:Finished, 19:26:47, Elapsed time: 00:00:00.172. Master.dtsx \Package\Load Results\Load Master Result Table None \Master\Load Results[1]\Load Master Result Table
2017-04-09 19:26:47.5070652 -07:00 Do Stuff:Start, 19:26:47. Master.dtsx \Package\Load Results\Do Stuff None \Master\Load Results[1]\Do Stuff
2017-04-09 19:26:47.5070652 -07:00 Do Stuff:Validation has started. Master.dtsx \Package\Load Results\Do Stuff None \Master\Load Results[1]\Do Stuff
2017-04-09 19:26:47.5070652 -07:00 Do Stuff:Validation is complete. Master.dtsx \Package\Load Results\Do Stuff None \Master\Load Results[1]\Do Stuff
2017-04-09 19:26:47.5070652 -07:00 Do Stuff:Finished, 19:26:47, Elapsed time: 00:00:00.000. Master.dtsx \Package\Load Results\Do Stuff None \Master\Load Results[1]\Do Stuff
2017-04-09 19:27:00.7107532 -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[2]\Load Master Result Table
2017-04-09 19:27:00.7107532 -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[2]\Load Master Result Table
2017-04-09 19:27:00.7107532 -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[2]\Load Master Result Table
2017-04-09 19:27:00.7107532 -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[2]\Load Master Result Table
2017-04-09 19:27:00.5226727 -07:00 Load Master Result Table:Start, 19:27:00. Master.dtsx \Package\Load Results\Load Master Result Table None \Master\Load Results[2]\Load Master Result Table
2017-04-09 19:27:00.5226727 -07:00 Load Master Result Table:Validation has started. Master.dtsx \Package\Load Results\Load Master Result Table None \Master\Load Results[2]\Load Master Result Table
2017-04-09 19:27:00.5226727 -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[2]\Load Master Result Table
2017-04-09 19:27:00.6166639 -07:00 Load Master Result Table:Validation is complete. Master.dtsx \Package\Load Results\Load Master Result Table None \Master\Load Results[2]\Load Master Result Table
2017-04-09 19:27:00.6319038 -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-09 19:27:00.6319038 -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[2]\Load Master Result Table
2017-04-09 19:27:00.6629360 -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[2]\Load Master Result Table
2017-04-09 19:27:00.7107532 -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[2]\Load Master Result Table
2017-04-09 19:27:00.7107532 -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[2]\Load Master Result Table
2017-04-09 19:27:00.7107532 -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-09 19:27:00.7107532 -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[2]\Load Master Result Table
2017-04-09 19:27:00.7107532 -07:00 Load Master Result Table:Information: The Lookup processed 505 rows in the cache. The processing time was 0.016 seconds. The cache used 20200 bytes of memory. Master.dtsx \Package\Load Results\Load Master Result Table Lookup [40] \Master\Load Results[2]\Load Master Result Table
2017-04-09 19:27:00.7107532 -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[2]\Load Master Result Table
2017-04-09 19:27:00.7254428 -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[2]\Load Master Result Table
2017-04-09 19:27:00.7254428 -07:00 Load Master Result Table:Information: "DST - Bad" wrote 326 rows. Master.dtsx \Package\Load Results\Load Master Result Table SSIS.Pipeline \Master\Load Results[2]\Load Master Result Table
2017-04-09 19:27:00.7254428 -07:00 Load Master Result Table:Information: "DST - Good" wrote 74 rows. Master.dtsx \Package\Load Results\Load Master Result Table SSIS.Pipeline \Master\Load Results[2]\Load Master Result Table
2017-04-09 19:27:00.7254428 -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[2]\Load Master Result Table
2017-04-09 19:27:00.7254428 -07:00 Load Master Result Table:Finished, 19:27:00, Elapsed time: 00:00:00.203. Master.dtsx \Package\Load Results\Load Master Result Table None \Master\Load Results[2]\Load Master Result Table
2017-04-09 19:27:00.7254428 -07:00 Do Stuff:Start, 19:27:00. Master.dtsx \Package\Load Results\Do Stuff None \Master\Load Results[2]\Do Stuff
2017-04-09 19:27:00.7254428 -07:00 Do Stuff:Validation has started. Master.dtsx \Package\Load Results\Do Stuff None \Master\Load Results[2]\Do Stuff
2017-04-09 19:27:00.7254428 -07:00 Do Stuff:Validation is complete. Master.dtsx \Package\Load Results\Do Stuff None \Master\Load Results[2]\Do Stuff
2017-04-09 19:27:00.7254428 -07:00 Do Stuff:Finished, 19:27:00, Elapsed time: 00:00:00.000. Master.dtsx \Package\Load Results\Do Stuff None \Master\Load Results[2]\Do Stuff
2017-04-09 19:27:00.5226727 -07:00 SQL Task B:Finished, 19:27:00, Elapsed time: 00:00:13.015. Master.dtsx \Package\Load Results\SQL Task B None \Master\Load Results[1]\SQL Task B
2017-04-09 19:27:00.7254428 -07:00 SQL Task B:Start, 19:27:00. Master.dtsx \Package\Load Results\SQL Task B None \Master\Load Results[2]\SQL Task B
2017-04-09 19:27:00.7254428 -07:00 SQL Task B:Validation has started. Master.dtsx \Package\Load Results\SQL Task B None \Master\Load Results[2]\SQL Task B
2017-04-09 19:27:00.7254428 -07:00 SQL Task B:Validation is complete. Master.dtsx \Package\Load Results\SQL Task B None \Master\Load Results[2]\SQL Task B
2017-04-09 19:27:23.8508375 -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[3]\Load Master Result Table
2017-04-09 19:27:23.8508375 -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[3]\Load Master Result Table
2017-04-09 19:27:23.7415533 -07:00 Load Master Result Table:Start, 19:27:23. Master.dtsx \Package\Load Results\Load Master Result Table None \Master\Load Results[3]\Load Master Result Table
2017-04-09 19:27:23.7415533 -07:00 Load Master Result Table:Validation has started. Master.dtsx \Package\Load Results\Load Master Result Table None \Master\Load Results[3]\Load Master Result Table
2017-04-09 19:27:23.7415533 -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[3]\Load Master Result Table
2017-04-09 19:27:23.7883977 -07:00 Load Master Result Table:Validation is complete. Master.dtsx \Package\Load Results\Load Master Result Table None \Master\Load Results[3]\Load Master Result Table
2017-04-09 19:27:23.7883977 -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-09 19:27:23.7883977 -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[3]\Load Master Result Table
2017-04-09 19:27:23.8036679 -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[3]\Load Master Result Table
2017-04-09 19:27:23.8354523 -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[3]\Load Master Result Table
2017-04-09 19:27:23.8354523 -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[3]\Load Master Result Table
2017-04-09 19:27:23.8508375 -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-09 19:27:23.8508375 -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[3]\Load Master Result Table
2017-04-09 19:27:23.8508375 -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[3]\Load Master Result Table
2017-04-09 19:27:23.8508375 -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[3]\Load Master Result Table
2017-04-09 19:27:23.8508375 -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[3]\Load Master Result Table
2017-04-09 19:27:23.8508375 -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[3]\Load Master Result Table
2017-04-09 19:27:23.8660988 -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[3]\Load Master Result Table
2017-04-09 19:27:23.8660988 -07:00 Load Master Result Table:Information: "DST - Bad" wrote 1291 rows. Master.dtsx \Package\Load Results\Load Master Result Table SSIS.Pipeline \Master\Load Results[3]\Load Master Result Table
2017-04-09 19:27:23.8660988 -07:00 Load Master Result Table:Information: "DST - Good" wrote 353 rows. Master.dtsx \Package\Load Results\Load Master Result Table SSIS.Pipeline \Master\Load Results[3]\Load Master Result Table
2017-04-09 19:27:23.8660988 -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[3]\Load Master Result Table
2017-04-09 19:27:23.8660988 -07:00 Load Master Result Table:Finished, 19:27:23, Elapsed time: 00:00:00.125. Master.dtsx \Package\Load Results\Load Master Result Table None \Master\Load Results[3]\Load Master Result Table
2017-04-09 19:27:23.8660988 -07:00 Do Stuff:Start, 19:27:23. Master.dtsx \Package\Load Results\Do Stuff None \Master\Load Results[3]\Do Stuff
2017-04-09 19:27:23.8660988 -07:00 Do Stuff:Validation has started. Master.dtsx \Package\Load Results\Do Stuff None \Master\Load Results[3]\Do Stuff
2017-04-09 19:27:23.8660988 -07:00 Do Stuff:Validation is complete. Master.dtsx \Package\Load Results\Do Stuff None \Master\Load Results[3]\Do Stuff
2017-04-09 19:27:23.8660988 -07:00 Do Stuff:Finished, 19:27:23, Elapsed time: 00:00:00.000. Master.dtsx \Package\Load Results\Do Stuff None \Master\Load Results[3]\Do Stuff
2017-04-09 19:27:23.7415533 -07:00 SQL Task B:Finished, 19:27:23, Elapsed time: 00:00:23.016. Master.dtsx \Package\Load Results\SQL Task B None \Master\Load Results[2]\SQL Task B
2017-04-09 19:27:23.8660988 -07:00 SQL Task B:Start, 19:27:23. Master.dtsx \Package\Load Results\SQL Task B None \Master\Load Results[3]\SQL Task B
2017-04-09 19:27:23.8660988 -07:00 SQL Task B:Validation has started. Master.dtsx \Package\Load Results\SQL Task B None \Master\Load Results[3]\SQL Task B
2017-04-09 19:27:23.8660988 -07:00 SQL Task B:Validation is complete. Master.dtsx \Package\Load Results\SQL Task B None \Master\Load Results[3]\SQL Task B
2017-04-09 19:27:56.8852441 -07:00 Load Master Result Table:Start, 19:27:56. Master.dtsx \Package\Load Results\Load Master Result Table None \Master\Load Results[4]\Load Master Result Table
2017-04-09 19:27:56.8852441 -07:00 Load Master Result Table:Validation has started. Master.dtsx \Package\Load Results\Load Master Result Table None \Master\Load Results[4]\Load Master Result Table
2017-04-09 19:27:56.8852441 -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[4]\Load Master Result Table
2017-04-09 19:27:56.9472554 -07:00 Load Master Result Table:Validation is complete. Master.dtsx \Package\Load Results\Load Master Result Table None \Master\Load Results[4]\Load Master Result Table
2017-04-09 19:27:56.9472554 -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-09 19:27:56.9472554 -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[4]\Load Master Result Table
2017-04-09 19:27:56.9628792 -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[4]\Load Master Result Table
2017-04-09 19:27:57.1816942 -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[4]\Load Master Result Table
2017-04-09 19:27:57.1816942 -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[4]\Load Master Result Table
2017-04-09 19:27:57.1976692 -07:00 Do Stuff:Validation is complete. Master.dtsx \Package\Load Results\Do Stuff None \Master\Load Results[4]\Do Stuff
2017-04-09 19:27:57.1976692 -07:00 Do Stuff:Finished, 19:27:57, Elapsed time: 00:00:00.000. Master.dtsx \Package\Load Results\Do Stuff None \Master\Load Results[4]\Do Stuff
2017-04-09 19:27:56.8852441 -07:00 SQL Task B:Finished, 19:27:56, Elapsed time: 00:00:33.016. Master.dtsx \Package\Load Results\SQL Task B None \Master\Load Results[3]\SQL Task B
2017-04-09 19:27:57.1816942 -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[4]\Load Master Result Table
2017-04-09 19:27:57.1816942 -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[4]\Load Master Result Table
2017-04-09 19:27:57.1976692 -07:00 SQL Task B:Start, 19:27:57. Master.dtsx \Package\Load Results\SQL Task B None \Master\Load Results[4]\SQL Task B
2017-04-09 19:27:57.1976692 -07:00 SQL Task B:Validation has started. Master.dtsx \Package\Load Results\SQL Task B None \Master\Load Results[4]\SQL Task B
2017-04-09 19:27:57.1976692 -07:00 SQL Task B:Validation is complete. Master.dtsx \Package\Load Results\SQL Task B None \Master\Load Results[4]\SQL Task B
2017-04-09 19:27:57.1662234 -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[4]\Load Master Result Table
2017-04-09 19:27:57.1662234 -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[4]\Load Master Result Table
2017-04-09 19:27:57.1662234 -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-09 19:27:57.1662234 -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[4]\Load Master Result Table
2017-04-09 19:27:57.1662234 -07:00 Load Master Result Table:Information: The Lookup processed 505 rows in the cache. The processing time was 0.016 seconds. The cache used 20200 bytes of memory. Master.dtsx \Package\Load Results\Load Master Result Table Lookup [40] \Master\Load Results[4]\Load Master Result Table
2017-04-09 19:27:57.1816942 -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[4]\Load Master Result Table
2017-04-09 19:27:57.1816942 -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[4]\Load Master Result Table
2017-04-09 19:27:57.1816942 -07:00 Load Master Result Table:Information: "DST - Bad" wrote 1284 rows. Master.dtsx \Package\Load Results\Load Master Result Table SSIS.Pipeline \Master\Load Results[4]\Load Master Result Table
2017-04-09 19:27:57.1816942 -07:00 Load Master Result Table:Information: "DST - Good" wrote 360 rows. Master.dtsx \Package\Load Results\Load Master Result Table SSIS.Pipeline \Master\Load Results[4]\Load Master Result Table
2017-04-09 19:27:57.1976692 -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[4]\Load Master Result Table
2017-04-09 19:27:57.1976692 -07:00 Load Master Result Table:Finished, 19:27:57, Elapsed time: 00:00:00.312. Master.dtsx \Package\Load Results\Load Master Result Table None \Master\Load Results[4]\Load Master Result Table
2017-04-09 19:28:40.2139336 -07:00 Load Master Result Table:Start, 19:28:40. Master.dtsx \Package\Load Results\Load Master Result Table None \Master\Load Results[5]\Load Master Result Table
2017-04-09 19:28:40.2139336 -07:00 Load Master Result Table:Validation has started. Master.dtsx \Package\Load Results\Load Master Result Table None \Master\Load Results[5]\Load Master Result Table
2017-04-09 19:28:40.2139336 -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[5]\Load Master Result Table
2017-04-09 19:28:40.2139336 -07:00 SQL Task B:Finished, 19:28:40, Elapsed time: 00:00:43.016. Master.dtsx \Package\Load Results\SQL Task B None \Master\Load Results[4]\SQL Task B
2017-04-09 19:28:40.3381224 -07:00 Load Master Result Table:Validation is complete. Master.dtsx \Package\Load Results\Load Master Result Table None \Master\Load Results[5]\Load Master Result Table
2017-04-09 19:28:40.3381224 -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-09 19:28:40.3381224 -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[5]\Load Master Result Table
2017-04-09 19:28:40.4013703 -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[5]\Load Master Result Table
2017-04-09 19:28:40.8535726 -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[5]\Load Master Result Table
2017-04-09 19:28:40.8535726 -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[5]\Load Master Result Table
2017-04-09 19:28:40.8535726 -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-09 19:28:40.8535726 -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[5]\Load Master Result Table
2017-04-09 19:28:40.8535726 -07:00 Load Master Result Table:Information: The Lookup processed 505 rows in the cache. The processing time was 0.187 seconds. The cache used 20200 bytes of memory. Master.dtsx \Package\Load Results\Load Master Result Table Lookup [40] \Master\Load Results[5]\Load Master Result Table
2017-04-09 19:28:40.9162372 -07:00 Do Stuff:Start, 19:28:40. Master.dtsx \Package\Load Results\Do Stuff None \Master\Load Results[5]\Do Stuff
2017-04-09 19:28:40.9162372 -07:00 Do Stuff:Validation has started. Master.dtsx \Package\Load Results\Do Stuff None \Master\Load Results[5]\Do Stuff
2017-04-09 19:28:40.9162372 -07:00 Do Stuff:Validation is complete. Master.dtsx \Package\Load Results\Do Stuff None \Master\Load Results[5]\Do Stuff
2017-04-09 19:28:40.9162372 -07:00 Do Stuff:Finished, 19:28:40, Elapsed time: 00:00:00.000. Master.dtsx \Package\Load Results\Do Stuff None \Master\Load Results[5]\Do Stuff
2017-04-09 19:28:40.9162372 -07:00 SQL Task B:Start, 19:28:40. Master.dtsx \Package\Load Results\SQL Task B None \Master\Load Results[5]\SQL Task B
2017-04-09 19:28:40.9162372 -07:00 SQL Task B:Validation has started. Master.dtsx \Package\Load Results\SQL Task B None \Master\Load Results[5]\SQL Task B
2017-04-09 19:28:40.9162372 -07:00 SQL Task B:Validation is complete. Master.dtsx \Package\Load Results\SQL Task B None \Master\Load Results[5]\SQL Task B
2017-04-09 19:28:40.9004831 -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[5]\Load Master Result Table
2017-04-09 19:28:40.9004831 -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[5]\Load Master Result Table
2017-04-09 19:28:40.9162372 -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[5]\Load Master Result Table
2017-04-09 19:28:40.9162372 -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[5]\Load Master Result Table
2017-04-09 19:28:40.9004831 -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[5]\Load Master Result Table
2017-04-09 19:28:40.9162372 -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[5]\Load Master Result Table
2017-04-09 19:28:40.9162372 -07:00 Load Master Result Table:Information: "DST - Bad" wrote 1431 rows. Master.dtsx \Package\Load Results\Load Master Result Table SSIS.Pipeline \Master\Load Results[5]\Load Master Result Table
2017-04-09 19:28:40.9162372 -07:00 Load Master Result Table:Information: "DST - Good" wrote 435 rows. Master.dtsx \Package\Load Results\Load Master Result Table SSIS.Pipeline \Master\Load Results[5]\Load Master Result Table
2017-04-09 19:28:40.9162372 -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[5]\Load Master Result Table
2017-04-09 19:28:40.9162372 -07:00 Load Master Result Table:Finished, 19:28:40, Elapsed time: 00:00:00.703. Master.dtsx \Package\Load Results\Load Master Result Table None \Master\Load Results[5]\Load Master Result Table
2017-04-09 19:29:33.9993566 -07:00 Load Results:Finished, 19:29:33, Elapsed time: 00:02:46.656. Master.dtsx \Package\Load Results None \Master\Load Results
2017-04-09 19:29:34.0304064 -07:00 Say Bye:Start, 19:29:34. Master.dtsx \Package\SayBye\Say Bye None \Master\SayBye\Say Bye
2017-04-09 19:29:34.0304064 -07:00 Say Bye:Validation has started. Master.dtsx \Package\SayBye\Say Bye None \Master\SayBye\Say Bye
2017-04-09 19:29:34.0304064 -07:00 Say Bye:Validation is complete. Master.dtsx \Package\SayBye\Say Bye None \Master\SayBye\Say Bye
2017-04-09 19:29:34.0304064 -07:00 Say Bye:Information: Package executed, bye! Master.dtsx \Package\SayBye\Say Bye None \Master\SayBye\Say Bye
2017-04-09 19:29:34.0304064 -07:00 Say Bye:Finished, 19:29:34, Elapsed time: 00:00:00.000. Master.dtsx \Package\SayBye\Say Bye None \Master\SayBye\Say Bye
2017-04-09 19:29:34.0304064 -07:00 SayBye:Finished, 19:29:34, Elapsed time: 00:00:00.015. Master.dtsx \Package\SayBye None \Master\SayBye
2017-04-09 19:29:34.0304064 -07:00 Master:Finished, 19:29:34, Elapsed time: 00:03:07.375. Master.dtsx \Package None \Master
2017-04-09 19:29:33.9993566 -07:00 Drop Results Table:Start, 19:29:33. Master.dtsx \Package\Drop Results Table None \Master\Drop Results Table
2017-04-09 19:29:33.9993566 -07:00 Drop Results Table:Validation has started. Master.dtsx \Package\Drop Results Table None \Master\Drop Results Table
2017-04-09 19:29:33.9993566 -07:00 Drop Results Table:Validation is complete. Master.dtsx \Package\Drop Results Table None \Master\Drop Results Table
2017-04-09 19:29:34.0148761 -07:00 Drop Results Table:Finished, 19:29:34, Elapsed time: 00:00:00.016. Master.dtsx \Package\Drop Results Table None \Master\Drop Results Table
2017-04-09 19:29:34.0148761 -07:00 SayBye:Start, 19:29:34. Master.dtsx \Package\SayBye None \Master\SayBye
2017-04-09 19:29:34.0304064 -07:00 Say Bye Once More:Start, 19:29:34. Master.dtsx \Package\SayBye\Say Bye Once More None \Master\SayBye\Say Bye Once More
2017-04-09 19:29:34.0304064 -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-09 19:29:34.0304064 -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-09 19:29:34.0304064 -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-09 19:29:34.0304064 -07:00 Say Bye Once More:Finished, 19:29:34, Elapsed time: 00:00:00.000. Master.dtsx \Package\SayBye\Say Bye Once More None \Master\SayBye\Say Bye Once More
2017-04-09 19:29:33.9993566 -07:00 SQL Task B:Finished, 19:29:33, Elapsed time: 00:00:53.078. Master.dtsx \Package\Load Results\SQL Task B None \Master\Load Results[5]\SQL Task B