Access with SSIS problem

M

mscertified

I've no idea where else to post this....
I'm trying to create an Integrated Services package to FTP MS Access data.

I've run into the following problem and am at a complete halt.
You have to define a 'connection manager'. This allows you to select Jet
3.51 or Jet 4. I'm using Access 2003, so I chose Jet 4. The problem is that
when I do this it tries to use OLEBD provider for Access 2007
(Microsoft.ACE.OLEDB.12.0) and spews out dozens of errors which basically
mean, I don't have this on my machine. I don't see anywhere where I can
define which particular OLEDB provider to use.

Does anyone know anything about this?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top