May 15, 2015 at 3:20 pm
My goal is to use Load an Access 2013 selected tables to Sql server 2012 tables using Visual Studio to create an Integration services proejct using the following link: http://www.mssqltips.com/sqlservertip/2656/simple-step-by-step-process-to-import-ms-access-data-into-sql-server-using-ssis/. I tried to use Business Intelligence Studio 2010 and visual studio 2012, and I was able to get to the step 18 successfully.
When I tried to get to step #19 to select Native OLE DB\Microsoft Office 12.0 Access Database Engine OLE DB Provider from the In the Provider combobox, this was not an option I was able to select. (Access 2013 version 15.0) was not an option either. Some of the options I tried and did not work from the Native OLE DB list are:
1. Microsoft OLE DB Simple Provider,
2. Microsoft OLE DB Provider for Sql Server,
3. OLE DB Provider for Microsoft Directory Services,
4. Sql Server Native Client 11.0.
Thus can you tell me the following:
1. What kind of other option could I have chosen?
2. What can I do to get Access 2013 as one of the items in the provider dropdown list that I can use?
3. I could be selecting the wrong options to locate the access database as the datasource. If this is the case, would you tell me what I should do differently to be able to select the Access 2013 input data source?
May 15, 2015 at 3:42 pm
alternatively, you could push from within Access. created linked tables in Access to your SQL Server database(s). Create append queries that select data from the Access tables. Write a macro/VBA code to execute the append queries in sequence.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply