Dave LaFlamme


MS Access database was one of the standard data connections in DTS. Excel is listed as a scourc/destination, but access is not. Question:

What is the best connection to use for MS-Access databases for output of data

We generally process the ETL in SQL server then, export to Access database.

THANKS!!

Dave





Re: ssis, How to connect to Access database?

NigelRivett


In google

ssis access database conncetion

gives as the first result

http://msdn2.microsoft.com/en-us/library/ms141013.aspx






Re: ssis, How to connect to Access database?

Dave LaFlamme

I used the data export wizard and looked at the connections used for Access.

Answer: Use "Native OLE DB\Microsoft Jet 4.0 OLE DB Provider" for the connection to Access Database.
Any of the connections containing "Microsoft Jet 4.0 OLE DB Provider" seem to work fine with Access DBs( ADO .Net, etc..).

It seems as though using the wizards and looking at the results is a great way to see "how it is done" in SSIS.

THANKS!!

Dave