February 2, 2010 at 4:08 am
Do I have to have MS Access installed on my server if an SSIS package opens access files and copies data into SQL server ?
February 4, 2010 at 4:47 am
You can store an Access mdb to a share that does not have Access installed on it but the host Access the mdb file must have the Acces Jet Engine installed.
If you run the SSIS Import/Export Wizard and select Microsoft Access on a machine that does not have Access Installed but has an mdf file and Access is not listed as a source then you have a problem. You can use a PC or server that has an mdb but does not have an Access installed.
Have you tried in in a Test envionment?
If so does MS Access show up as a source?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
February 5, 2010 at 7:11 am
Do you have a 64 bit version of SQL Server installed on the server?
February 5, 2010 at 7:23 am
Ive tested it and it works ok without Access actually being installed on the server
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply