Hello,

Is it true that Data Transformation Services (DTS) uses the Microsoft
Jet Database Engine?

I have a DBA that has set up a daily job that parses, slices/dices raw
data using Microsoft Access and then DTS' it into SQL Server. It works
and has worked without incident, but I'm just curious to know why he
couldn't do it using DTS exclusively.

Thanks for any suggestions,

RBollinger

You will have to ask the DBA why he did not use DTS. DTS has no store per
se. It sources and deposits data wherever you tell it. Maybe the DBA is
happier in Access.

Allan


"robboll" <robboll (AT) hotmail (DOT) com> wrote

Still looking for the answer to: Does DTS use the Microsoft Jet
Database Engine. Also -- I'm trying to find out if DTS going away?
What technology is Microsoft going to to replace DTS?

robboll wrote:

Depends what you mean by "uses the Jet Database Engine". DTS will use
the Jet OLEDB provider if the source or target connection is Jet but it
doesn't otherwise access the Jet engine internally AFAIK.

DTS is superseded by Integration Services in SQL Server 2005.
Integration Services is based on .NET rather than COM.

--
David Portas
SQL Server MVP
--