Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. sponsors. rss.
SSIS AND DELETED RECORDS
 From: Yuri Rubinov
  Where is Yuri Rubinov?
 Philadelphia
 Pennsylvania - United States
 Yuri Rubinov
 Tags
Subject: SSIS and deleted records
Thread ID: 190572 Message ID: 190572 # Views: 30 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Thursday, August 21, 2008 4:35:55 PM         
   

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



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