I was having problem in getting data from different server, a hugh data millions of records that i have to import.
I tried lots of methods but its very difficult to get it done.
I found some solution for such hugh task.
Have a look @ Different Options for Importing Data into SQL Server.
21 hours ago