UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Connecting Ssis To Access 2016 (.accdb Format), Access 2016    
 
   
MadPiet
post Feb 24 2019, 02:20 PM
Post#1



Posts: 3,367
Joined: 27-February 09



Does anybody know which provider type to use to create a functional Source for an SSIS data flow? The Jet4.0 one worked fine, but what's the ACCDB version of that? I was watching videos on Pluralsight on SSIS, but they're from maybe 2011. (Time for an update, maybe?)

I downloaded & installed the X64 Database Engine stuff, but still no joy.

(Interesting that even MSFT treats Access like some unwanted stepchild.)
Go to the top of the page
 
sumosoftware
post Apr 3 2019, 08:57 PM
Post#2



Posts: 33
Joined: 3-April 19



Did you install the correct database engine for your version of office (32 or 64 bit).

You can use an existing odbc connection or also use the OLE Provider MS Office (XX.X) Access Database Engine OLE Provider that is installed with the database engine.

I remember having to set the debugging - Run64BitRuntime to false to correct a debugging issue I was having, but this was a bug in an earlier version of SSIS.

Cheers.
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    13th December 2019 - 05:54 AM