Thanks for replying.

i am pulling ext from the MySQL view which in also in the EMP SQL table.

Based on the EXT i need to get dept, fname, lname, empum...

TY!!

thanks for posting this, in my environment it would be helpful, Unfortunately i am new to development and SSIS. You have provided in detail all the steps and content except...