> 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

Yuri,
I didn't create an SSIS package but I think you would find a place to execute this (maybe in flow control?):

con.Execute('set deleted on')

Cetin Basoz