All this time the solution was under my nose. SSIS pakage can do the required job. It works great!
Thanks again rmiao!