I have 2 database that perform activity then bulk insert into 1 table
in a 3rd database. Is there anyway to make sure that thier is not
going to be a collsion. I am wondering if I can check to see if a
bulk loading is occuring or not.

If I know that ther eis a bulk loading occuring then I could set my
ssis package to wait and check in a couple of minutes again.

Check to see the average time it takes to complete the load and then
start your SSIS PAckages...
Or you can write logs from the datapumps individually... to check the
amount each process takes.
Also, you can use Global parameters to pass between Tasks and then
send you email at the last step or Write a completion flag(bit) into a
table and your SSIS read that Flag frequently to check for the
value... and which in turn runs the SSIS if the flag(bit colum/value)
is as desired.
Some of thoughts....

Check to see the average time it takes to complete the load and then
start your SSIS PAckages...
Or you can write logs from the datapumps individually... to check the
amount each process takes.
Also, you can use Global parameters to pass between Tasks and then
send you email at the last step or Write a completion flag(bit) into a
table and your SSIS read that Flag frequently to check for the
value... and which in turn runs the SSIS if the flag(bit colum/value)
is as desired.
Some of thoughts....

Check to see the average time it takes to complete the load and then
start your SSIS PAckages...
Or you can write logs from the datapumps individually... to check the
amount each process takes.
Also, you can use Global parameters to pass between Tasks and then
send you email at the last step or Write a completion flag(bit) into a
table and your SSIS read that Flag frequently to check for the
value... and which in turn runs the SSIS if the flag(bit colum/value)
is as desired.
Some of thoughts....

Check to see the average time it takes to complete the load and then
start your SSIS PAckages...
Or you can write logs from the datapumps individually... to check the
amount each process takes.
Also, you can use Global parameters to pass between Tasks and then
send you email at the last step or Write a completion flag(bit) into a
table and your SSIS read that Flag frequently to check for the
value... and which in turn runs the SSIS if the flag(bit colum/value)
is as desired.
Some of thoughts....

Check to see the average time it takes to complete the load and then
start your SSIS PAckages...
Or you can write logs from the datapumps individually... to check the
amount each process takes.
Also, you can use Global parameters to pass between Tasks and then
send you email at the last step or Write a completion flag(bit) into a
table and your SSIS read that Flag frequently to check for the
value... and which in turn runs the SSIS if the flag(bit colum/value)
is as desired.
Some of thoughts....

Check to see the average time it takes to complete the load and then
start your SSIS PAckages...
Or you can write logs from the datapumps individually... to check the
amount each process takes.
Also, you can use Global parameters to pass between Tasks and then
send you email at the last step or Write a completion flag(bit) into a
table and your SSIS read that Flag frequently to check for the
value... and which in turn runs the SSIS if the flag(bit colum/value)
is as desired.
Some of thoughts....

Check to see the average time it takes to complete the load and then
start your SSIS PAckages...
Or you can write logs from the datapumps individually... to check the
amount each process takes.
Also, you can use Global parameters to pass between Tasks and then
send you email at the last step or Write a completion flag(bit) into a
table and your SSIS read that Flag frequently to check for the
value... and which in turn runs the SSIS if the flag(bit colum/value)
is as desired.
Some of thoughts....

Check to see the average time it takes to complete the load and then
start your SSIS PAckages...
Or you can write logs from the datapumps individually... to check the
amount each process takes.
Also, you can use Global parameters to pass between Tasks and then
send you email at the last step or Write a completion flag(bit) into a
table and your SSIS read that Flag frequently to check for the
value... and which in turn runs the SSIS if the flag(bit colum/value)
is as desired.
Some of thoughts....