> 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
Cetin,
Thanks, but I doubt.
1. Deleted is ON by default in VFP OLE DB
2. In review mode there are no deleted records appear: it is indication that deleted is ON on the source site.
3. It looks like SSIS transfer procedure somehow ignores it.
In any case I would love to follow your advice, but I cannot see how to do it correctly. Data Flow Task looks like a black box to me, I cannot see the programm/code there. What I did, I added an Execute Sql Task, I saw it processed before Data Flow Task, but no effect at the end.
Any other hints?