Insert Data into SharePoint List with Lookup column

As a part of migration process, how can you insert a data in to the SharePoint Lists which will be having a lookup column???
Click Here to find out the answer :)
There is an adapter of SharePoint List for SSIS is also available.
If you don't want to go with adapter this is the way how you can create your own SSIS pacakage. Only drawback is it is not talking about inserting data in to lookup columns.

There is one tool also available who can help you in data migration from Database to SharePoint Lists. Data-Synchronisation-Studio

In addition, here is a good blog to describe how to use BDC to connect to Oracle Databases