Access to SQL transfer automated | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Access to SQL transfer automated

Hello, I need to create a stored procedure that will run each night and dump all the data from an Access databases into the sql server database. We already have created the databases in sql and have run the dts package to import the data once. But I need to have a back up each night of all the new data. Please let me know as how I can do this. I am a newbie. Thanks!

you can put the dts package to batch file for execution..something like that..
add it in notepad
– dtsrun /F "YourFilePathYourDTSPackageName.dts" /E where E means windows authentication then save to batch file.. use Sceduled Tasks to do the execution job each night