>Mike,
>
>>>I don't believe that DTS has a "database engine" in the same sense as SQL Server or any other database product.
>
>I'm not disagreeing with you, but...
>
>You can perform SQL queries into intermediate tables and then perform subsequent set-based or row-based actions against that intermediate table. Sure sounds like a DBMS to me.
>
>As I said, I'm not disagreeing with you. Instead, I'm trying to reconcile these apparent discrepancies. Its been said "There ain't no such thing as a free lunch", but DTS sure as hell looks like a four course meal for pennies.
>
>Regards,

Thom,
DTS uses the OLE-DB/ODBC provider to handle this stuff. If you connect to a DBMS (SQL Server/MSDE/Oracle) those queries are handled by the DBMS. If you connect to a file-based system (VFP) then the machine running DTS performs those operations using the provider.

Bottom line is that DTS can only do what the provider allows.