I have a pckage that imports data from an old Access 97 database. It imports fine, but when I export (using export wizard, access) my client program trys to connect and gives the error: "Unrecognized database format" Can SQL 05 export to Access 97? Is there something I can do to get it to recognize the old Access 97 format?qeqw

I think you just do not have the proper [Jet] MS Access driver installed or it was overwritten by a newer office installation, so please refer yourself to http://support.microsoft.com/kb/237575?wa=wsignin1.0Arthur My Blog

Not sure I follow... I install the driver and my ssis package will export the mdf in access 97 format?qeqw