sql server dts: Can I have two servers (one 7.0 and one 2000) with
different sort orders and the same time having DTS running
which transforms informations between these two servers /

Yes

--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


[quoted text, click to view]

Sure can. SQL Server itself only holds a package's definition. At runtime,
a package executes outside of SQL Server via the client-side programs
DTSRun.exe or DTSRunUI.exe. As such, DTS can connect to any database
server, be it different versions of SQL Server or even different vendor
servers such as Oracle. The data gets extracted from the source data store,
run through the Data Pump within DTS where transformations are applied, and
then passed/inserted into the target data store.

--
--Brian
(Please reply to the newsgroups only.)


[quoted text, click to view]