Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. sponsors. rss.
 From: Yuri Rubinov
  Where is Yuri Rubinov?
 Philadelphia
 Pennsylvania - United States
 Yuri Rubinov
 To: Cetin Basoz
  Where is Cetin Basoz?
 Izmir
 Turkey
 Cetin Basoz
 Tags
Subject: RE: SSIS and deleted records
Thread ID: 190572 Message ID: 190581 # Views: 23 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Thursday, August 21, 2008 5:41:15 PM         
   


> 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?



COMPLETE THREAD
SSIS and deleted records Posted by Yuri Rubinov @ 8/21/2008 4:35:55 PM
RE: SSIS and deleted records Posted by Cetin Basoz @ 8/21/2008 5:00:41 PM
RE: SSIS and deleted records Posted by Yuri Rubinov @ 8/21/2008 5:41:15 PM
RE: SSIS and deleted records Posted by Yuri Rubinov @ 8/21/2008 6:18:39 PM
RE: SSIS and deleted records Posted by Borislav Borissov @ 8/21/2008 6:39:19 PM
RE: SSIS and deleted records Posted by Yuri Rubinov @ 8/21/2008 8:35:43 PM