Thank you dave, for the post, very good one.
I just went with eliminating the odds method and then I was stuck with 2 and 4, I read the deprecated features of 2012 (using local_help) and there was no hint of process failing, so I picked 4 by increasing the possibility of success rate... Bingo!!!.
...enjoyed the post.
later I came across this:
The staging process has changed since SQL Server 2008 R2. You can continue to use the SQL Server 2008 R2 process; however, the staging process is now more flexible and has better performance.
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.