Hi, I am using typical stand alone system in MS-Access, but for my company....who all are users all users are using client application and the database file (.MDF) I kept in Windows 2000 Server and i mapped the folder to client systems. Now presently my requirement is .... 1) Is it possible to install SQLSERVER2008 on Windows 2000 Server? 2) how to export the data from MS-Access file (.MDF) to SQL Server 2008 by using SSIS package. Any help pls....
You cannot instal SQL 2008 on Windows 2000, you must use 2003 SP2 at least. [Link to requirements] As for importing the data, you don't need to export first, you should be able to use SSIS to connect directly to the access file and read the tables out. The drivers should be included by default, although I am not certain about 64 Bit drivers for Access. :
If I had this project I would certainly take a look at the Access Migration tool (
http://www.microsoft.com/sqlserver/2005/en/us/migration-access.aspx). It splits an access file into two, one file being the forms and reports and the other being the data objects which it then uses to create a SQL database. All via a wizard. Obviously the process can have some effects you dont want but I would recommend trying it on a copy just to see if it gets you 90% of the way... once you get the SQL Server installed of course..!