MS SQL Server - Batch scripts

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Batch scripts

kailash

2006-11-16, 7:12 pm

Hi All,

Could you please provide me brief description of batch process.
What is batch process?
How to run batch process ? with example

John Bell

2006-11-16, 7:12 pm

Hi

This really depends on your system and what you are trying to achieve. If
you are trying to load a number of files into tables and then manipulate that
data, or just manipulate a large amount of data already in the database at a
given time of day (say overnight) then you may want to look at DTS in SQL
2000 and SSIS in SQL 2005. If you want top schedule these jobs then check out
SQL Agent.

HTH

John

"kailash" wrote:

> Hi All,
>
> Could you please provide me brief description of batch process.
> What is batch process?
> How to run batch process ? with example

Sponsored Links