July 15, 2015 at 3:40 pm
I have an excel spreadsheet 2013 that I want to load data into sql server 2012 for a one time load. I am going to run this load on a test server first and then into production for real later. The table that will be loaded will exist long enough to transfer the data to other permanent tables. Thus I am trying to determine what is the best way to load the data. I am going to list options and ask you to tell me what option is the preferred method and why you chose that option. Based upon the option you chose, would you give me detailed directions on how to accomplish my goal of loading data to sql server 2012?
The choices are:
1. create an ssis package and save that to the database.
2. create a package and save it to the file system.
3. Open up excel 2013 and have it load data to sql server 2013.
4. Some option I am not aware and you know exists.
July 15, 2015 at 6:18 pm
SSIS is maybe the easiest. If you save the package, you can re-run it or add a conditional split so it only imports new records.
If you saved the Excel file as a CSV file, you could use BPC, which is very fast. (Pretty sure Jeff Moden has some tutorials on that somewhere around here.)
July 15, 2015 at 10:05 pm
I Concur,
SSIS will be easiest and re-usable approach.
Good Luck.
____________________________________________________________
APJuly 19, 2015 at 11:56 pm
Hi
SSIS is maybe the easiest.
Thanks
Rambabu
July 20, 2015 at 12:14 am
before you try SSIS you might want to explore the import export wizard in SSMS since this is a one time job.
You could also use Openrowset
http://www.ashishblog.com/importexport-excel-xlsx-or-xls-file-into-sql-server/
July 20, 2015 at 12:24 am
Hi Jayanth
you are giving nice solution. thanks for sharing.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply