Dear all,

Currently we implement DTS package api to call DTSs stored on a SQL
Server machine. i.e. A client machine loaded DTSs from DB server and
executed locally
via DTS Package Objects. Occasionally we encountered performance
problem if the calling machine executed too many DTS concurrently.

I found out there is a new component called "DTS Server" in this
release.
I guess "DTS server" will play the role as it is named literally. i.e.
DTS will be run on the DTS server instead of the calling machine.
Am I right ?

Also, can anyone give me some clues to find out the related
information
about "DTS SERVER" ?

Thank you,

KEN

Whilst I haven't actively done anything with the DTS Service it would appear
that it is now required to execute a package, such that you won't be able to
execute packages "locally" unless you have the service installed as well. A
quick browse of Books Online lists the following-

DTS Service provides the following management capabilities:

Monitoring remote and locally running packages
Stopping remote and locally running packages
Managing package storage
Customizing storage folders

Try Books Online yourself, and for further questions about SQL Server 2005,
try the beta newsgroups, in particular microsoft.private.sqlserver2005.dts.
For more info about the beta newsgroups see-
http://communities.microsoft.com/new...r2005&slcid=us


--
Darren Green
http://www.sqldts.com

"KENNY L. CHEN" <kenny_60559 (AT) yahoo (DOT) com> wrote