Lynn Pettis (10/28/2016)
Luis Cazares (10/28/2016)
Why aren't you using flat files to transfer the data so you don't have to deal with additional storage needed by spreadsheets?Also, depending on the driver, you can get a lower row limit when using Excel as a destination.
Call it lazy, he doesn't want to create 107 separate extracts, he just wanted to write one data transfer process. Due to the issues with using Excel he is going to try using Access.
Weird, i would think that it's easier to output to flat files. I would generate bcp code with T-SQL by querying sys.tables and use a bat file to run it from the local machine (assuming they don't want to run it from the server). A similar option could be done for the import.
I guess everyone has their preferred methods. I just wanted to offer an option.