How to write Script to update the database?

Hi folks,
Do you guys know how to write the Script to update the SQL database? please help me out? For example, the script will update SQL database at 1:00 am every day...some like that?

Thanks,
Vu

I don't think you can write a perioded script in SQL. But if you write the script that shall be ran at 1:00 am every night, you can set up a scheduled task (XP) or by using at-command for earlier NT versions. I think the AT command is part of the old SDK for NT.

You could create a DTS package and schedule that to run every night at 1:00am....

There are lots of ways doing this. I think you are upto of some automation.

You can you dtsrun or dtsrunui utility by typing these commands on dos prompt. I am using 3 DTS which I want to run from a single click without loging on to servers and running one by one.

This is the script:
DTSRun /S "serverName" /N "packageName" /G "{version of package which you will get by using dtsrunui and you can generate this version from there}" /L "C:\Documents and Settings\fhanif\Desktop\dts\Error.txt" /W "0" /E

You can put the above command in a file and name it as dts.bat and schedule it to run at any time or even you can run it by double clicking on it.

So one batch file contains multiple DTS and it will start executing one by one after running dts.bat at command prompt or double clicking on the dts.bat file.

That is the best approach I have found

There are lots of ways doing this. I think you are upto of some automation.

You can you dtsrun or dtsrunui utility by typing these commands on dos prompt. I am using 3 DTS which I want to run from a single click without loging on to servers and running one by one.

This is the script:
DTSRun /S "serverName" /N "packageName" /G "{version of package which you will get by using dtsrunui and you can generate this version from there}" /L "C:\Documents and Settings\fhanif\Desktop\dts\Error.txt" /W "0" /E

You can put the above command in a file and name it as dts.bat and schedule it to run at any time or even you can run it by double clicking on it.

So one batch file contains multiple DTS and it will start executing one by one after running dts.bat at command prompt or double clicking on the dts.bat file.