SQL Server Performance

Access to SQL transfer automated

Discussion in 'SQL Server DTS-Related Questions' started by ramya_rav2000, May 24, 2006.

  1. ramya_rav2000 New Member

    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!
  2. smy New Member

    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

Share This Page