backup of access 2003 database to sql 2008 r2
Posted on 2013-05-09
Straight Import of a access 2003 databse into sql 2008 r2 is not working and errors on the third table import
Unhandled exception at 0x75b6b760 in DTSWizard.exe: 0xE0434352: 0xe0434352.
, as there are not many tables and this is a once off to start I have imported via excel.
however I need to start running a daily job to import to our sql 2008 r2 database, what do you recommend i am importing over a network.
Do you prefer a query to be done, instead of ssis jobs.
Has anyone experienced issues of automating an import of access 2003 database to sql 2008 r2.
Its a basic database and eventually it will be upgraded.
I just need to save it now on a daily basis