DTS and server threads

If I have a simple DTS package, exporting rows from a table out to a
text file, will that spawn multple threads on the server, and if so,
can it be prevented, and if so, how?

Thanks!

Josh

In message <qvqdu0h0a1rn4oi5s7arv7olc6nku6meog (AT) 4ax (DOT) com>, JRStern
<jxstern (AT) bogus (DOT) com> writes

If I have a simple DTS package, exporting rows from a table out to a
text file, will that spawn multple threads on the server, and if so,
can it be prevented, and if so, how?

Thanks!

Josh

The process will only work on one thread but a package may use one or
more in itself. To prevent this, there is a setting for parallel task
running set in package properties, which defaults to 4, although you
will not get this depending on hardware. The most important setting is
Execute on main thread which is set on a task/step level. Right-click
the task and select Workflow Properties, then Options. Check execute in
main thread and it ensures that tasks do not start another thread.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org