Hi,
I am newbie to SSIS.
I am facing the same problem when connecting to Access 97 database.
I can't connect to the database on local machine where the SSIS is installed using File connection as well as OLEDB connection.
Any help on this will be really appreciated.
Thanks
Vik
Hi Sbastien,
My sincere appology for late response as we had long weekend (Holiday) here.
I have designed new test package for connecting to access. When I am trying to connect to local northwind Access database through OLE DB connection, I am getting this error:
Test connection failed because of an error in initializing provider. Could not attach file 'C:\Db\Access\Northwind.mdb' as database 'Northwind'.
The header for file 'C:\Db\Access\Northwind.mdb' is not a valid database file header. The FILE SIZE property is incorrect.
I followed the microsoft tutorial steps for developing this package.
I would really appreciate if you could help me in this error.
Regards
Vik.
By the way I won't try the File Connection to connect to an Access DB
Which Ole DB Provider did you tried ?
