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 VFP OLEDB provider is
SET DELETED ON, but the SSIS package doesn't seem to care.

Clicking the "preview" button while designing the Copy Data task shows
preview results that exclude deleted records, but the actual execution
results in deleted records in the SQL tables.

I have tried adding an SQL task to explicitly issue "SET DELETED ON"
before the copy data tasks run, but this has no effect- either the copy
data tasks are using a different connection, or they are changing the
DELETED setting themselves.

Not sure if it's related or not, but the same package also throw a
validation warning for each table being copied:

"Validation warning. Copy Table Data: Source 47 - rating [4645]: Cannot
retrieve the column code page info from the OLE DB provider. If the
component supports the "DefaultCodePage" property, the code page from
that property will be used. Change the value of the property if the
current string code page values are incorrect. If the component does
not support the property, the code page from the component's locale ID
will be used."

Despite the warning and the deleted records issue, the rest of the
package seems to run correctly.

Anyone got a clue what's going on?