I created a simple SSIS package to import VFP table to SQL Server in MS Visual Studio.

With "preview" button in design mode there are no deleted records, but when executed, deleted records appear in the SQL table.

I have tried adding Extended properties to OLE DB Data Links properties like:

DELETED=ON
DELETED=FALSE
DELETED=TRUE
SET DELETED ON

but no effect.


Is there any options in SSIS I am missing?


Thanks in advance

Yuri Rubinov