sql server dts: help please! -- sql server dts

help please!

TC
7/28/2004 1:32:09 PM

sql server dts: Hey all,

Trying to use the import function of a dbase in enterprise manager to move a
..dbf file into the sql database. In DTS Import/Export wizard it's asking me
for a Data Source: which I'm using "Microsoft Visual FoxPro Driver." Is this
correct? The .dbf file was made useing VFP 6.0.

Also, in the "Select or create a Data Source Name..." section of the wizard,
it keeps producing an error. What dsn file do I choose?

Thanks very much!

Re: help please!

Allan Mitchell
7/28/2004 7:23:33 PM

CREATE a system DSN first using the correct driver. You can then use the
"Other Data Source" and point it to the correct DSN

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know

[quoted text, click to view]