We are running SQL 2000 Enterprise Server Edition under Windows 2003 Server
Standard Edition. How do you schedule a batch file to run daily to export
selected records?

Thanks.

Hello Diane,

Do you mean how do you schedule a DTS package the exports rows to a text
file?

SQL Server Agent or your favourite scheduler will do the scheduling but here
is some syntax help and nuances.

http://www.sqldts.com/redir.aspx?269074

http://www.sqldts.com/default.aspx?301

Allan

Thanks very much for your information and prompt response. Is there another
way to schedule a batch file? Thanks.

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Hello Diane,

You can use Windows Scheduler, SQL Server Agent or any of the 3rd party offerings
like AutoSys. You simply call the batch file.

Where does DTS come into this? Are you using DTS to do the export? if you
are then you may want to look at the syntax for DTSRun in Books-Online

Allan

Hello Allan,

Thank you very much for your information and prompt response. I assume that
I need to use DTSRun command to setup a batch file. Then use DTS package to
schedule the job that I setup in DTSRun. Anyway, is there another way to
setup a batch job to export records besides using DTS? Thanks.

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Hello Diane,

Ok I think the terminology might be confusing here.

You can use a cmdline command in a batch file that calls

DTSRun - if you need to call a package to move the rows
bcp - if you want to move the rows to text file with no DTS package.

If you use SQL Server Agent then there is a job step that effectively gets
the cmdline for you (Operating System (CmdExec))
Most other schedulers will do that as well including Windows Scheduler.


DTSRun is a command line interface to call a DTS Package. The syntax is
straight forward.

http://www.sqldts.com/default.aspx?301


Allan

Thanks very much, Allan.

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote