I have a SQL Server 2005 SSIS package that imports data from VFP tables
using the OLEDB provider into SQL tables. The package is importing
deleted records. I know that the default for the OLEDB provider is SET
DELETED ON, but the SSIS package doesn't seem to care.

I would like to use FoxPro 9 to retrieve data from a SQL database for
reporting purposes.  I know the file location, file name, and the table names
in the database, but do not know the connection string. Assuming a connection
could be made without a password, how would I attempt ...