DTS in SQL 2005

Not sure why Microsoft would remove from SQL 2005 DTS import data
sources all the default drivers available to ODBC but they did. In SQL
2000 the drivers available to ODBC were by default available to DTS
import. How does one go about getting DTS to recognize these drivers
so simple data import can be accomplished.
To import from a DBF file you now have to create an ODBC data source
Every time you want to add a new file and then to add insult to injury
they make you key in all the ODBC information for the import source
instead of giving you a simple drop down.
Seems like a huge step backwards as far as user interface goes.
Hi
If I understood you correctly , you can run DTS (SS2000) from SS2005. There
is a folder called Legacy under Management folder.
<jmirsky@.hotmail.com> wrote in message
news:1139956308.785445.51930@.g43g2000cwa.googlegro ups.com...
> Not sure why Microsoft would remove from SQL 2005 DTS import data
> sources all the default drivers available to ODBC but they did. In SQL
> 2000 the drivers available to ODBC were by default available to DTS
> import. How does one go about getting DTS to recognize these drivers
> so simple data import can be accomplished.
> To import from a DBF file you now have to create an ODBC data source
> Every time you want to add a new file and then to add insult to injury
> they make you key in all the ODBC information for the import source
> instead of giving you a simple drop down.
> Seems like a huge step backwards as far as user interface goes.
>