| 2017-04-14 18:06:51.3268511 -07:00 |
Handle Error:Validation is complete. |
Master.dtsx |
\Package\Handle Error |
None |
\Master\Handle Error |
| 2017-04-14 18:06:51.3371529 -07:00 |
SQL Task A:Validation is complete. |
Master.dtsx |
\Package\SQL Task A |
None |
\Master\SQL Task A |
| 2017-04-14 18:06:51.3318775 -07:00 |
Do Stuff:Validation is complete. |
Master.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Load Results\Do Stuff |
| 2017-04-14 18:06:51.3328518 -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-14 18:06:51.3381872 -07:00 |
Write Message:Validation is complete. |
Master.dtsx |
\Package\Write Message |
None |
\Master\Write Message |
| 2017-04-14 18:06:51.3288460 -07:00 |
Load Results:Validation has started. |
Master.dtsx |
\Package\Load Results |
None |
\Master\Load Results |
| 2017-04-14 18:06:51.3268511 -07:00 |
Handle Error:Validation has started. |
Master.dtsx |
\Package\Handle Error |
None |
\Master\Handle Error |
| 2017-04-14 18:06:51.3308340 -07:00 |
Do Stuff:Validation has started. |
Master.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Load Results\Do Stuff |
| 2017-04-14 18:06:51.3381872 -07:00 |
Write Message:Validation has started. |
Master.dtsx |
\Package\Write Message |
None |
\Master\Write Message |
| 2017-04-14 18:06:51.3381872 -07:00 |
Master:Validation is complete. |
Master.dtsx |
\Package |
None |
\Master |
| 2017-04-14 18:06:51.2988927 -07:00 |
Master:Validation has started. |
Master.dtsx |
\Package |
None |
\Master |
| 2017-04-14 18:06:51.3108974 -07:00 |
Create Results Table:Validation has started. |
Master.dtsx |
\Package\Create Results Table |
None |
\Master\Create Results Table |
| 2017-04-14 18:06:51.3238814 -07:00 |
Create Results Table:Validation is complete. |
Master.dtsx |
\Package\Create Results Table |
None |
\Master\Create Results Table |
| 2017-04-14 18:06:51.3238814 -07:00 |
Drop Results Table:Validation has started. |
Master.dtsx |
\Package\Drop Results Table |
None |
\Master\Drop Results Table |
| 2017-04-14 18:06:51.3238814 -07:00 |
Drop Results Table:Validation is complete. |
Master.dtsx |
\Package\Drop Results Table |
None |
\Master\Drop Results Table |
| 2017-04-14 18:06:51.3249580 -07:00 |
Execute Child Package:Validation has started. |
Master.dtsx |
\Package\Execute Child Package |
None |
\Master\Execute Child Package |
| 2017-04-14 18:06:51.3268511 -07:00 |
Execute Child Package:Validation is complete. |
Master.dtsx |
\Package\Execute Child Package |
None |
\Master\Execute Child Package |
| 2017-04-14 18:06:51.3328518 -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-14 18:06:51.3328518 -07:00 |
Load Results:Validation is complete. |
Master.dtsx |
\Package\Load Results |
None |
\Master\Load Results |
| 2017-04-14 18:06:51.3348332 -07:00 |
SayBye:Validation has started. |
Master.dtsx |
\Package\SayBye |
None |
\Master\SayBye |
| 2017-04-14 18:06:51.3358363 -07:00 |
Say Bye:Validation has started. |
Master.dtsx |
\Package\SayBye\Say Bye |
None |
\Master\SayBye\Say Bye |
| 2017-04-14 18:06:51.3371529 -07:00 |
Say Bye:Validation is complete. |
Master.dtsx |
\Package\SayBye\Say Bye |
None |
\Master\SayBye\Say Bye |
| 2017-04-14 18:06:51.3371529 -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-14 18:06:51.3371529 -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-14 18:06:51.6048827 -07:00 |
Master:Start, 18:06:51. |
Master.dtsx |
\Package |
None |
\Master |
| 2017-04-14 18:06:51.6279299 -07:00 |
Create Results Table:Start, 18:06:51. |
Master.dtsx |
\Package\Create Results Table |
None |
\Master\Create Results Table |
| 2017-04-14 18:06:51.6308963 -07:00 |
Create Results Table:Validation has started. |
Master.dtsx |
\Package\Create Results Table |
None |
\Master\Create Results Table |
| 2017-04-14 18:06:51.6308963 -07:00 |
Create Results Table:Validation is complete. |
Master.dtsx |
\Package\Create Results Table |
None |
\Master\Create Results Table |
| 2017-04-14 18:06:51.9499679 -07:00 |
Create Results Table:Finished, 18:06:51, Elapsed time: 00:00:00.312. |
Master.dtsx |
\Package\Create Results Table |
None |
\Master\Create Results Table |
| 2017-04-14 18:06:51.9519228 -07:00 |
Write Message:Start, 18:06:51. |
Master.dtsx |
\Package\Write Message |
None |
\Master\Write Message |
| 2017-04-14 18:06:51.9519228 -07:00 |
Write Message:Validation has started. |
Master.dtsx |
\Package\Write Message |
None |
\Master\Write Message |
| 2017-04-14 18:06:51.9519228 -07:00 |
Write Message:Validation is complete. |
Master.dtsx |
\Package\Write Message |
None |
\Master\Write Message |
| 2017-04-14 18:06:51.6279299 -07:00 |
SQL Task A:Start, 18:06:51. |
Master.dtsx |
\Package\SQL Task A |
None |
\Master\SQL Task A |
| 2017-04-14 18:06:51.6289185 -07:00 |
SQL Task A:Validation has started. |
Master.dtsx |
\Package\SQL Task A |
None |
\Master\SQL Task A |
| 2017-04-14 18:06:51.6289185 -07:00 |
SQL Task A:Validation is complete. |
Master.dtsx |
\Package\SQL Task A |
None |
\Master\SQL Task A |
| 2017-04-14 18:06:51.3371529 -07:00 |
SayBye:Validation is complete. |
Master.dtsx |
\Package\SayBye |
None |
\Master\SayBye |
| 2017-04-14 18:06:51.3371529 -07:00 |
SQL Task A:Validation has started. |
Master.dtsx |
\Package\SQL Task A |
None |
\Master\SQL Task A |
| 2017-04-14 18:06:52.9800305 -07:00 |
Write Message:Information: Hi there, this is Sample 1 |
Master.dtsx |
\Package\Write Message |
None |
\Master\Write Message |
| 2017-04-14 18:06:52.9819222 -07:00 |
Write Message:Finished, 18:06:52, Elapsed time: 00:00:01.031. |
Master.dtsx |
\Package\Write Message |
None |
\Master\Write Message |
| 2017-04-14 18:06:52.9819222 -07:00 |
Execute Child Package:Start, 18:06:52. |
Master.dtsx |
\Package\Execute Child Package |
None |
\Master\Execute Child Package |
| 2017-04-14 18:06:52.9819222 -07:00 |
Execute Child Package:Validation has started. |
Master.dtsx |
\Package\Execute Child Package |
None |
\Master\Execute Child Package |
| 2017-04-14 18:06:52.9819222 -07:00 |
Execute Child Package:Validation is complete. |
Master.dtsx |
\Package\Execute Child Package |
None |
\Master\Execute Child Package |
| 2017-04-14 18:06:53.0960630 -07:00 |
Child:Validation has started. |
Child.dtsx |
\Package |
None |
\Master\Execute Child Package\Child |
| 2017-04-14 18:06:53.0970577 -07:00 |
Call Grandchild:Validation has started. |
Child.dtsx |
\Package\Call Grandchild |
None |
\Master\Execute Child Package\Child\Call Grandchild |
| 2017-04-14 18:06:53.1090252 -07:00 |
Call Grandchild:Validation is complete. |
Child.dtsx |
\Package\Call Grandchild |
None |
\Master\Execute Child Package\Child\Call Grandchild |
| 2017-04-14 18:06:53.1099571 -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-14 18:06:53.1099571 -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-14 18:06:53.1099571 -07:00 |
Load Results:Validation has started. |
Child.dtsx |
\Package\Load Results |
None |
\Master\Execute Child Package\Child\Load Results |
| 2017-04-14 18:06:53.1099571 -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-14 18:06:53.1109313 -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-14 18:06:53.1109313 -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-14 18:06:53.1109313 -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-14 18:06:53.1120232 -07:00 |
Load Results:Validation is complete. |
Child.dtsx |
\Package\Load Results |
None |
\Master\Execute Child Package\Child\Load Results |
| 2017-04-14 18:06:53.1120232 -07:00 |
Child:Validation is complete. |
Child.dtsx |
\Package |
None |
\Master\Execute Child Package\Child |
| 2017-04-14 18:06:53.1140177 -07:00 |
Child:Validation has started. |
Child.dtsx |
\Package |
None |
\Master\Execute Child Package\Child |
| 2017-04-14 18:06:53.1149687 -07:00 |
Call Grandchild:Validation has started. |
Child.dtsx |
\Package\Call Grandchild |
None |
\Master\Execute Child Package\Child\Call Grandchild |
| 2017-04-14 18:06:53.1160294 -07:00 |
Call Grandchild:Validation is complete. |
Child.dtsx |
\Package\Call Grandchild |
None |
\Master\Execute Child Package\Child\Call Grandchild |
| 2017-04-14 18:06:53.1379712 -07:00 |
Child:Start, 18:06:53. |
Child.dtsx |
\Package |
None |
\Master\Execute Child Package\Child |
| 2017-04-14 18:06:53.1409436 -07:00 |
Create Results Table:Start, 18:06:53. |
Child.dtsx |
\Package\Create Results Table |
None |
\Master\Execute Child Package\Child\Create Results Table |
| 2017-04-14 18:06:53.1409436 -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-14 18:06:53.1419639 -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-14 18:06:53.1539370 -07:00 |
Create Results Table:Finished, 18:06:53, Elapsed time: 00:00:00.000. |
Child.dtsx |
\Package\Create Results Table |
None |
\Master\Execute Child Package\Child\Create Results Table |
| 2017-04-14 18:06:53.1539370 -07:00 |
Load Results:Start, 18:06:53. |
Child.dtsx |
\Package\Load Results |
None |
\Master\Execute Child Package\Child\Load Results |
| 2017-04-14 18:06:53.1549344 -07:00 |
Load Child Results Table:Start, 18:06:53. |
Child.dtsx |
\Package\Load Results\Load Child Results Table |
None |
\Master\Execute Child Package\Child\Load Results[1]\Load Child Results Table |
| 2017-04-14 18:06:53.1559482 -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-14 18:06:53.1630334 -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-14 18:06:53.4429906 -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-14 18:06:53.4462743 -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-14 18:06:53.4500079 -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-14 18:06:53.4510551 -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-14 18:06:53.4510551 -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-14 18:06:53.4531920 -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-14 18:06:53.6509752 -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-14 18:06:54.0571268 -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-14 18:06:54.0571268 -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-14 18:06:54.0620468 -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-14 18:06:54.0620468 -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-14 18:06:54.0631280 -07:00 |
Load Child Results Table:Information: The Lookup B processed 55 rows in the cache. The processing time was 0.406 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-14 18:06:53.1549344 -07:00 |
Call Grandchild:Start, 18:06:53. |
Child.dtsx |
\Package\Call Grandchild |
None |
\Master\Execute Child Package\Child\Call Grandchild |
| 2017-04-14 18:06:53.1549344 -07:00 |
Call Grandchild:Validation has started. |
Child.dtsx |
\Package\Call Grandchild |
None |
\Master\Execute Child Package\Child\Call Grandchild |
| 2017-04-14 18:06:53.1549344 -07:00 |
Call Grandchild:Validation is complete. |
Child.dtsx |
\Package\Call Grandchild |
None |
\Master\Execute Child Package\Child\Call Grandchild |
| 2017-04-14 18:06:53.1829663 -07:00 |
Grandchild:Validation has started. |
Grandchild.dtsx |
\Package |
None |
\Master\Execute Child Package\Child\Call Grandchild\Grandchild |
| 2017-04-14 18:06:53.1829663 -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-14 18:06:53.1829663 -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-14 18:06:53.1829663 -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-14 18:06:53.1829663 -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-14 18:06:53.1829663 -07:00 |
Grandchild:Validation is complete. |
Grandchild.dtsx |
\Package |
None |
\Master\Execute Child Package\Child\Call Grandchild\Grandchild |
| 2017-04-14 18:06:53.1841829 -07:00 |
Grandchild:Validation has started. |
Grandchild.dtsx |
\Package |
None |
\Master\Execute Child Package\Child\Call Grandchild\Grandchild |
| 2017-04-14 18:06:53.1850226 -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-14 18:06:53.1850226 -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-14 18:06:53.1850226 -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-14 18:06:53.1859894 -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-14 18:06:53.1859894 -07:00 |
Grandchild:Validation is complete. |
Grandchild.dtsx |
\Package |
None |
\Master\Execute Child Package\Child\Call Grandchild\Grandchild |
| 2017-04-14 18:06:54.7250307 -07:00 |
SQL Task B:Start, 18:06:54. |
Child.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Execute Child Package\Child\Load Results[1]\SQL Task B |
| 2017-04-14 18:06:54.7263097 -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-14 18:06:54.7263097 -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-14 18:06:53.1989948 -07:00 |
Grandchild:Start, 18:06:53. |
Grandchild.dtsx |
\Package |
None |
\Master\Execute Child Package\Child\Call Grandchild\Grandchild |
| 2017-04-14 18:06:53.1160294 -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-14 18:06:53.1170139 -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-14 18:06:53.1170139 -07:00 |
Load Results:Validation has started. |
Child.dtsx |
\Package\Load Results |
None |
\Master\Execute Child Package\Child\Load Results |
| 2017-04-14 18:06:53.1180095 -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-14 18:06:53.1180095 -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-14 18:06:53.1190084 -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-14 18:06:53.1190084 -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-14 18:06:53.1199737 -07:00 |
Load Results:Validation is complete. |
Child.dtsx |
\Package\Load Results |
None |
\Master\Execute Child Package\Child\Load Results |
| 2017-04-14 18:06:53.1199737 -07:00 |
Child:Validation is complete. |
Child.dtsx |
\Package |
None |
\Master\Execute Child Package\Child |
| 2017-04-14 18:06:53.2019770 -07:00 |
Do Something:Start, 18:06:53. |
Grandchild.dtsx |
\Package\Do Something |
None |
\Master\Execute Child Package\Child\Call Grandchild\Grandchild\Do Something |
| 2017-04-14 18:06:53.2019770 -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-14 18:06:53.2029815 -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-14 18:06:53.2189672 -07:00 |
Do Something:Finished, 18:06:53, Elapsed time: 00:00:00.031. |
Grandchild.dtsx |
\Package\Do Something |
None |
\Master\Execute Child Package\Child\Call Grandchild\Grandchild\Do Something |
| 2017-04-14 18:06:53.2189672 -07:00 |
Play with Username:Start, 18:06:53. |
Grandchild.dtsx |
\Package\Play with Username |
None |
\Master\Execute Child Package\Child\Call Grandchild\Grandchild\Play with Username |
| 2017-04-14 18:06:53.2200029 -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-14 18:06:53.2200029 -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-14 18:06:53.2239737 -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-14 18:06:53.9340738 -07:00 |
SQL Task A:Finished, 18:06:53, Elapsed time: 00:00:02.297. |
Master.dtsx |
\Package\SQL Task A |
None |
\Master\SQL Task A |
| 2017-04-14 18:06:54.6934272 -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-14 18:06:54.6940297 -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-14 18:06:54.6940297 -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-14 18:06:54.6951138 -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-14 18:06:54.1399866 -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-14 18:06:54.1470327 -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-14 18:06:54.1680171 -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-14 18:06:54.1680171 -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-14 18:06:54.1698096 -07:00 |
Load Child Results Table:Information: The Lookup C processed 505 rows in the cache. The processing time was 0.031 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-14 18:06:54.6591077 -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-14 18:06:54.6601144 -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-14 18:06:54.6630748 -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-14 18:06:54.6640904 -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-14 18:06:54.6650372 -07:00 |
Load Child Results Table:Information: The Lookup A processed 1505 rows in the cache. The processing time was 0.063 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-14 18:06:54.6660970 -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-14 18:06:54.6990502 -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-14 18:06:54.7140654 -07:00 |
Load Child Results Table:Information: "DST - Bad" wrote 1281 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-14 18:06:54.7140654 -07:00 |
Load Child Results Table:Information: "DST - Good" wrote 364 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-14 18:06:54.7161306 -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-14 18:06:54.7250307 -07:00 |
Load Child Results Table:Finished, 18:06:54, Elapsed time: 00:00:01.562. |
Child.dtsx |
\Package\Load Results\Load Child Results Table |
None |
\Master\Execute Child Package\Child\Load Results[1]\Load Child Results Table |
| 2017-04-14 18:06:54.7250307 -07:00 |
Do Stuff:Start, 18:06:54. |
Child.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Execute Child Package\Child\Load Results[1]\Do Stuff |
| 2017-04-14 18:06:54.7250307 -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-14 18:06:54.7263097 -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-14 18:06:54.7282214 -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-14 18:06:54.7291309 -07:00 |
Do Stuff:Finished, 18:06:54, Elapsed time: 00:00:00.000. |
Child.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Execute Child Package\Child\Load Results[1]\Do Stuff |
| 2017-04-14 18:06:55.7590191 -07:00 |
Load Child Results Table:Start, 18:06:55. |
Child.dtsx |
\Package\Load Results\Load Child Results Table |
None |
\Master\Execute Child Package\Child\Load Results[2]\Load Child Results Table |
| 2017-04-14 18:06:55.7590191 -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-14 18:06:55.7600031 -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-14 18:06:55.7577573 -07:00 |
SQL Task B:Finished, 18:06:55, Elapsed time: 00:00:01.032. |
Child.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Execute Child Package\Child\Load Results[1]\SQL Task B |
| 2017-04-14 18:06:55.8415137 -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-14 18:06:55.8433797 -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-14 18:06:55.8440860 -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-14 18:06:55.8440860 -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-14 18:06:55.8451714 -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-14 18:06:55.8812812 -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-14 18:06:55.8951115 -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-14 18:06:55.8961109 -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-14 18:06:55.8975196 -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-14 18:06:55.8975196 -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[2]\Load Child Results Table |
| 2017-04-14 18:06:55.9211307 -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-14 18:06:55.9231140 -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-14 18:06:55.9231140 -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-14 18:06:55.9231140 -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[2]\Load Child Results Table |
| 2017-04-14 18:06:55.9706014 -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-14 18:06:55.9721814 -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-14 18:06:55.9732109 -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-14 18:06:55.9732109 -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[2]\Load Child Results Table |
| 2017-04-14 18:06:55.9745890 -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-14 18:06:55.9910958 -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-14 18:06:55.9861061 -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-14 18:06:55.9872994 -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-14 18:06:56.0072174 -07:00 |
Do Stuff:Start, 18:06:56. |
Child.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Execute Child Package\Child\Load Results[2]\Do Stuff |
| 2017-04-14 18:06:56.0082177 -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-14 18:06:56.0082177 -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-14 18:06:56.0092240 -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-14 18:06:56.0092240 -07:00 |
Do Stuff:Finished, 18:06:56, 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-14 18:06:56.0082177 -07:00 |
SQL Task B:Start, 18:06:56. |
Child.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Execute Child Package\Child\Load Results[2]\SQL Task B |
| 2017-04-14 18:06:56.0082177 -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-14 18:06:56.0082177 -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-14 18:06:55.9881871 -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-14 18:06:55.9891060 -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-14 18:06:56.0011018 -07:00 |
Load Child Results Table:Information: "DST - Bad" wrote 1767 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-14 18:06:56.0021081 -07:00 |
Load Child Results Table:Information: "DST - Good" wrote 500 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-14 18:06:56.0032480 -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-14 18:06:56.0072174 -07:00 |
Load Child Results Table:Finished, 18:06:56, Elapsed time: 00:00:00.250. |
Child.dtsx |
\Package\Load Results\Load Child Results Table |
None |
\Master\Execute Child Package\Child\Load Results[2]\Load Child Results Table |
| 2017-04-14 18:06:58.0192323 -07:00 |
Load Child Results Table:Start, 18:06:58. |
Child.dtsx |
\Package\Load Results\Load Child Results Table |
None |
\Master\Execute Child Package\Child\Load Results[3]\Load Child Results Table |
| 2017-04-14 18:06:58.0192323 -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-14 18:06:58.0203405 -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-14 18:06:58.0182818 -07:00 |
SQL Task B:Finished, 18:06:58, Elapsed time: 00:00:02.015. |
Child.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Execute Child Package\Child\Load Results[2]\SQL Task B |
| 2017-04-14 18:06:58.1523072 -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-14 18:06:58.1542440 -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-14 18:06:58.1542440 -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-14 18:06:58.1552545 -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-14 18:06:58.1572713 -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-14 18:06:58.2372466 -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-14 18:06:58.2543099 -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-14 18:06:58.2553167 -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-14 18:06:58.2562988 -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-14 18:06:58.2572828 -07:00 |
Load Child Results Table:Information: The Lookup B processed 55 rows in the cache. The processing time was 0.016 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-14 18:06:58.2882256 -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-14 18:06:58.2912544 -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-14 18:06:58.2932754 -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-14 18:06:58.2932754 -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-14 18:06:58.3683726 -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-14 18:06:58.3734438 -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-14 18:06:58.3742300 -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-14 18:06:58.3742300 -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-14 18:06:58.3763711 -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-14 18:06:58.4012355 -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-14 18:06:58.3912877 -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-14 18:06:58.3912877 -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-14 18:06:58.4272980 -07:00 |
Do Stuff:Start, 18:06:58. |
Child.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Execute Child Package\Child\Load Results[3]\Do Stuff |
| 2017-04-14 18:06:58.4272980 -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-14 18:06:58.4282703 -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-14 18:06:58.4293027 -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-14 18:06:58.4293027 -07:00 |
Do Stuff:Finished, 18:06:58, 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-14 18:06:58.2352410 -07:00 |
Call Grandchild:Finished, 18:06:58, Elapsed time: 00:00:05.094. |
Child.dtsx |
\Package\Call Grandchild |
None |
\Master\Execute Child Package\Child\Call Grandchild |
| 2017-04-14 18:06:58.4272980 -07:00 |
SQL Task B:Start, 18:06:58. |
Child.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Execute Child Package\Child\Load Results[3]\SQL Task B |
| 2017-04-14 18:06:58.4272980 -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-14 18:06:58.4282703 -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-14 18:06:58.2263609 -07:00 |
Grandchild:Finished, 18:06:58, Elapsed time: 00:00:05.031. |
Grandchild.dtsx |
\Package |
None |
\Master\Execute Child Package\Child\Call Grandchild\Grandchild |
| 2017-04-14 18:06:58.2252829 -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-14 18:06:58.2263609 -07:00 |
Play with Username:Finished, 18:06:58, Elapsed time: 00:00:05.000. |
Grandchild.dtsx |
\Package\Play with Username |
None |
\Master\Execute Child Package\Child\Call Grandchild\Grandchild\Play with Username |
| 2017-04-14 18:06:58.3962918 -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-14 18:06:58.3972805 -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-14 18:06:58.4142912 -07:00 |
Load Child Results Table:Information: "DST - Bad" wrote 1295 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-14 18:06:58.4152524 -07:00 |
Load Child Results Table:Information: "DST - Good" wrote 350 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-14 18:06:58.4172906 -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-14 18:06:58.4263023 -07:00 |
Load Child Results Table:Finished, 18:06:58, Elapsed time: 00:00:00.407. |
Child.dtsx |
\Package\Load Results\Load Child Results Table |
None |
\Master\Execute Child Package\Child\Load Results[3]\Load Child Results Table |
| 2017-04-14 18:07:01.4568460 -07:00 |
Load Child Results Table:Start, 18:07:01. |
Child.dtsx |
\Package\Load Results\Load Child Results Table |
None |
\Master\Execute Child Package\Child\Load Results[4]\Load Child Results Table |
| 2017-04-14 18:07:01.4578854 -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-14 18:07:01.4608346 -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-14 18:07:01.5825487 -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-14 18:07:01.5845604 -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-14 18:07:01.5855578 -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-14 18:07:01.5855578 -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-14 18:07:01.5864269 -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-14 18:07:01.6214774 -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-14 18:07:01.6344744 -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[4]\Load Child Results Table |
| 2017-04-14 18:07:01.6354608 -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-14 18:07:01.6364406 -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-14 18:07:01.6364406 -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-14 18:07:01.6374390 -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[4]\Load Child Results Table |
| 2017-04-14 18:07:01.6614520 -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[4]\Load Child Results Table |
| 2017-04-14 18:07:01.6614520 -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-14 18:07:01.6634126 -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-14 18:07:01.6634126 -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-14 18:07:01.6634126 -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[4]\Load Child Results Table |
| 2017-04-14 18:07:01.7108036 -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[4]\Load Child Results Table |
| 2017-04-14 18:07:01.4544877 -07:00 |
SQL Task B:Finished, 18:07:01, Elapsed time: 00:00:03.031. |
Child.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Execute Child Package\Child\Load Results[3]\SQL Task B |
| 2017-04-14 18:07:01.7234396 -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-14 18:07:01.7245157 -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-14 18:07:01.7108036 -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-14 18:07:01.7117020 -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-14 18:07:01.7127897 -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-14 18:07:01.7137858 -07:00 |
Load Child Results Table:Information: The Lookup A processed 1505 rows in the cache. The processing time was 0.016 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-14 18:07:01.7147242 -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-14 18:07:01.7245157 -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-14 18:07:01.7256839 -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-14 18:07:01.7274286 -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-14 18:07:01.7384800 -07:00 |
Load Child Results Table:Information: "DST - Bad" wrote 1271 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-14 18:07:01.7384800 -07:00 |
Load Child Results Table:Information: "DST - Good" wrote 374 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-14 18:07:01.7405085 -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-14 18:07:01.7434316 -07:00 |
Load Child Results Table:Finished, 18:07:01, Elapsed time: 00:00:00.281. |
Child.dtsx |
\Package\Load Results\Load Child Results Table |
None |
\Master\Execute Child Package\Child\Load Results[4]\Load Child Results Table |
| 2017-04-14 18:07:01.7444463 -07:00 |
Do Stuff:Start, 18:07:01. |
Child.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Execute Child Package\Child\Load Results[4]\Do Stuff |
| 2017-04-14 18:07:01.7444463 -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-14 18:07:01.7444463 -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-14 18:07:01.7444463 -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-14 18:07:01.7462398 -07:00 |
Do Stuff:Finished, 18:07:01, 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-14 18:07:01.7444463 -07:00 |
SQL Task B:Start, 18:07:01. |
Child.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Execute Child Package\Child\Load Results[4]\SQL Task B |
| 2017-04-14 18:07:01.7444463 -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-14 18:07:01.7444463 -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-14 18:07:05.7556568 -07:00 |
Load Child Results Table:Start, 18:07:05. |
Child.dtsx |
\Package\Load Results\Load Child Results Table |
None |
\Master\Execute Child Package\Child\Load Results[5]\Load Child Results Table |
| 2017-04-14 18:07:05.7569487 -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-14 18:07:05.7569487 -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-14 18:07:05.7556568 -07:00 |
SQL Task B:Finished, 18:07:05, Elapsed time: 00:00:04.016. |
Child.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Execute Child Package\Child\Load Results[4]\SQL Task B |
| 2017-04-14 18:07:05.8317789 -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-14 18:07:05.8333673 -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-14 18:07:05.8343466 -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-14 18:07:05.8346523 -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-14 18:07:05.8357270 -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-14 18:07:05.8683024 -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-14 18:07:05.8818781 -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-14 18:07:05.8818781 -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-14 18:07:05.8832646 -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-14 18:07:05.8832646 -07:00 |
Load Child Results Table:Information: The Lookup B processed 55 rows in the cache. The processing time was 0.016 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-14 18:07:05.9067179 -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-14 18:07:05.9076740 -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-14 18:07:05.9087064 -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-14 18:07:05.9087064 -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-14 18:07:05.9557108 -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-14 18:07:05.9577207 -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-14 18:07:05.9577207 -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-14 18:07:05.9597138 -07:00 |
Load Child Results Table:Information: The Lookup A processed 1505 rows in the cache. The processing time was 0.016 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-14 18:07:05.9613082 -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-14 18:07:05.9736711 -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-14 18:07:05.9916741 -07:00 |
Do Stuff:Start, 18:07:05. |
Child.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Execute Child Package\Child\Load Results[5]\Do Stuff |
| 2017-04-14 18:07:05.9916741 -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-14 18:07:05.9916741 -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-14 18:07:05.9933834 -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-14 18:07:05.9941297 -07:00 |
Do Stuff:Finished, 18:07:05, 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-14 18:07:05.9916741 -07:00 |
SQL Task B:Start, 18:07:05. |
Child.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Execute Child Package\Child\Load Results[5]\SQL Task B |
| 2017-04-14 18:07:05.9916741 -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-14 18:07:05.9916741 -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-14 18:07:05.9697030 -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-14 18:07:05.9707489 -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-14 18:07:05.9707489 -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-14 18:07:05.9716994 -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-14 18:07:05.9847085 -07:00 |
Load Child Results Table:Information: "DST - Bad" wrote 981 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-14 18:07:05.9857455 -07:00 |
Load Child Results Table:Information: "DST - Good" wrote 263 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-14 18:07:05.9877033 -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-14 18:07:05.9916741 -07:00 |
Load Child Results Table:Finished, 18:07:05, Elapsed time: 00:00:00.234. |
Child.dtsx |
\Package\Load Results\Load Child Results Table |
None |
\Master\Execute Child Package\Child\Load Results[5]\Load Child Results Table |
| 2017-04-14 18:07:11.0029646 -07:00 |
Load Results:Finished, 18:07:11, Elapsed time: 00:00:17.860. |
Child.dtsx |
\Package\Load Results |
None |
\Master\Execute Child Package\Child\Load Results |
| 2017-04-14 18:07:11.0043590 -07:00 |
Child:Finished, 18:07:11, Elapsed time: 00:00:17.875. |
Child.dtsx |
\Package |
None |
\Master\Execute Child Package\Child |
| 2017-04-14 18:07:11.0029646 -07:00 |
SQL Task B:Finished, 18:07:11, Elapsed time: 00:00:05.016. |
Child.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Execute Child Package\Child\Load Results[5]\SQL Task B |
| 2017-04-14 18:07:11.0097218 -07:00 |
Execute Child Package:Finished, 18:07:11, Elapsed time: 00:00:18.032. |
Master.dtsx |
\Package\Execute Child Package |
None |
\Master\Execute Child Package |
| 2017-04-14 18:07:11.0097218 -07:00 |
Load Results:Start, 18:07:11. |
Master.dtsx |
\Package\Load Results |
None |
\Master\Load Results |
| 2017-04-14 18:07:11.0106793 -07:00 |
Load Master Result Table:Start, 18:07:11. |
Master.dtsx |
\Package\Load Results\Load Master Result Table |
None |
\Master\Load Results[1]\Load Master Result Table |
| 2017-04-14 18:07:11.0106793 -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-14 18:07:11.0113064 -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-14 18:07:11.0512992 -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-14 18:07:11.0526014 -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-14 18:07:11.0535059 -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-14 18:07:11.0710171 -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-14 18:07:11.1109759 -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-14 18:07:11.1124731 -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-14 18:07:11.1124731 -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-14 18:07:11.1135245 -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-14 18:07:11.1135245 -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[1]\Load Master Result Table |
| 2017-04-14 18:07:11.1135245 -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-14 18:07:11.1191075 -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-14 18:07:11.1199989 -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-14 18:07:11.1209805 -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-14 18:07:11.1222413 -07:00 |
Load Master Result Table:Information: "DST - Bad" wrote 1767 rows.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
SSIS.Pipeline |
\Master\Load Results[1]\Load Master Result Table |
| 2017-04-14 18:07:11.1222413 -07:00 |
Load Master Result Table:Information: "DST - Good" wrote 500 rows.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
SSIS.Pipeline |
\Master\Load Results[1]\Load Master Result Table |
| 2017-04-14 18:07:11.1184650 -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-14 18:07:11.1184650 -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-14 18:07:11.1319984 -07:00 |
Do Stuff:Start, 18:07:11. |
Master.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Load Results[1]\Do Stuff |
| 2017-04-14 18:07:11.1319984 -07:00 |
Do Stuff:Validation has started. |
Master.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Load Results[1]\Do Stuff |
| 2017-04-14 18:07:11.1319984 -07:00 |
Do Stuff:Validation is complete. |
Master.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Load Results[1]\Do Stuff |
| 2017-04-14 18:07:11.1340790 -07:00 |
Do Stuff:Finished, 18:07:11, Elapsed time: 00:00:00.000. |
Master.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Load Results[1]\Do Stuff |
| 2017-04-14 18:07:11.1222413 -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-14 18:07:11.1319984 -07:00 |
Load Master Result Table:Finished, 18:07:11, Elapsed time: 00:00:00.125. |
Master.dtsx |
\Package\Load Results\Load Master Result Table |
None |
\Master\Load Results[1]\Load Master Result Table |
| 2017-04-14 18:07:11.1319984 -07:00 |
SQL Task B:Start, 18:07:11. |
Master.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Load Results[1]\SQL Task B |
| 2017-04-14 18:07:11.1319984 -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-14 18:07:11.1319984 -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-14 18:07:24.3147245 -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-14 18:07:24.3157331 -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-14 18:07:24.3168134 -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-14 18:07:24.3177258 -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-14 18:07:24.1452471 -07:00 |
Load Master Result Table:Start, 18:07:24. |
Master.dtsx |
\Package\Load Results\Load Master Result Table |
None |
\Master\Load Results[2]\Load Master Result Table |
| 2017-04-14 18:07:24.1452471 -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-14 18:07:24.1467294 -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-14 18:07:24.2487298 -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-14 18:07:24.2499059 -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-14 18:07:24.2508713 -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-14 18:07:24.2737170 -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-14 18:07:24.3097515 -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-14 18:07:24.3107495 -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-14 18:07:24.3107495 -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-14 18:07:24.3107495 -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-14 18:07:24.3117460 -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[2]\Load Master Result Table |
| 2017-04-14 18:07:24.3117460 -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-14 18:07:24.3197426 -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-14 18:07:24.3217208 -07:00 |
Load Master Result Table:Information: "DST - Bad" wrote 970 rows.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
SSIS.Pipeline |
\Master\Load Results[2]\Load Master Result Table |
| 2017-04-14 18:07:24.3217208 -07:00 |
Load Master Result Table:Information: "DST - Good" wrote 274 rows.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
SSIS.Pipeline |
\Master\Load Results[2]\Load Master Result Table |
| 2017-04-14 18:07:24.3217208 -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-14 18:07:24.3227555 -07:00 |
Load Master Result Table:Finished, 18:07:24, Elapsed time: 00:00:00.172. |
Master.dtsx |
\Package\Load Results\Load Master Result Table |
None |
\Master\Load Results[2]\Load Master Result Table |
| 2017-04-14 18:07:24.1438081 -07:00 |
SQL Task B:Finished, 18:07:24, Elapsed time: 00:00:13.015. |
Master.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Load Results[1]\SQL Task B |
| 2017-04-14 18:07:24.3227555 -07:00 |
SQL Task B:Start, 18:07:24. |
Master.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Load Results[2]\SQL Task B |
| 2017-04-14 18:07:24.3237176 -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-14 18:07:24.3237176 -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-14 18:07:24.3227555 -07:00 |
Do Stuff:Start, 18:07:24. |
Master.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Load Results[2]\Do Stuff |
| 2017-04-14 18:07:24.3227555 -07:00 |
Do Stuff:Validation has started. |
Master.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Load Results[2]\Do Stuff |
| 2017-04-14 18:07:24.3227555 -07:00 |
Do Stuff:Validation is complete. |
Master.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Load Results[2]\Do Stuff |
| 2017-04-14 18:07:24.3237176 -07:00 |
Do Stuff:Finished, 18:07:24, Elapsed time: 00:00:00.000. |
Master.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Load Results[2]\Do Stuff |
| 2017-04-14 18:07:47.3289856 -07:00 |
Load Master Result Table:Start, 18:07:47. |
Master.dtsx |
\Package\Load Results\Load Master Result Table |
None |
\Master\Load Results[3]\Load Master Result Table |
| 2017-04-14 18:07:47.3289856 -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-14 18:07:47.3289856 -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-14 18:07:47.3289856 -07:00 |
SQL Task B:Finished, 18:07:47, Elapsed time: 00:00:23.016. |
Master.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Load Results[2]\SQL Task B |
| 2017-04-14 18:07:47.4383842 -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-14 18:07:47.4383842 -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-14 18:07:47.4383842 -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-14 18:07:47.5012218 -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-14 18:07:48.2511369 -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-14 18:07:48.2511369 -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-14 18:07:48.2352186 -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-14 18:07:48.2352186 -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-14 18:07:48.2352186 -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-14 18:07:48.2352186 -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-14 18:07:48.2352186 -07:00 |
Load Master Result Table:Information: The Lookup processed 505 rows in the cache. The processing time was 0.219 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-14 18:07:48.2352186 -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-14 18:07:48.2511369 -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-14 18:07:48.2511369 -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-14 18:07:48.2511369 -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-14 18:07:48.2511369 -07:00 |
Load Master Result Table:Information: "DST - Bad" wrote 976 rows.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
SSIS.Pipeline |
\Master\Load Results[3]\Load Master Result Table |
| 2017-04-14 18:07:48.2511369 -07:00 |
Load Master Result Table:Information: "DST - Good" wrote 268 rows.
|
Master.dtsx |
\Package\Load Results\Load Master Result Table |
SSIS.Pipeline |
\Master\Load Results[3]\Load Master Result Table |
| 2017-04-14 18:07:48.2511369 -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-14 18:07:48.2511369 -07:00 |
Load Master Result Table:Finished, 18:07:48, Elapsed time: 00:00:00.922. |
Master.dtsx |
\Package\Load Results\Load Master Result Table |
None |
\Master\Load Results[3]\Load Master Result Table |
| 2017-04-14 18:07:48.2511369 -07:00 |
SQL Task B:Start, 18:07:48. |
Master.dtsx |
\Package\Load Results\SQL Task B |
None |
\Master\Load Results[3]\SQL Task B |
| 2017-04-14 18:07:48.2511369 -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-14 18:07:48.2511369 -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-14 18:07:48.2511369 -07:00 |
Do Stuff:Start, 18:07:48. |
Master.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Load Results[3]\Do Stuff |
| 2017-04-14 18:07:48.2511369 -07:00 |
Do Stuff:Validation has started. |
Master.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Load Results[3]\Do Stuff |
| 2017-04-14 18:07:48.2511369 -07:00 |
Do Stuff:Validation is complete. |
Master.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Load Results[3]\Do Stuff |
| 2017-04-14 18:07:48.2511369 -07:00 |
Do Stuff:Finished, 18:07:48, Elapsed time: 00:00:00.000. |
Master.dtsx |
\Package\Load Results\Do Stuff |
None |
\Master\Load Results[3]\Do Stuff |
