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:
create an ssis package and save that to the database.
create a package and save it to the file system.
Open up excel 2013 and have it load data to sql server 2013.
Some option I am not aware and you know exists.