have a SQL Server 2005 SSIS package that imports data from VFP tables
using the OLEDB provider into SQL tables. The package is importing
deleted records. I know that the default for the OLEDB provider is SET
DELETED ON, but the SSIS package doesn't seem to care.
Clicking the "preview" button while designing the Copy Data task shows
preview results that exclude deleted records, but the actual execution
results in deleted records in the SQL tables.
I have tried adding an SQL task to explicitly issue "SET DELETED ON"
before the copy data tasks run, but this has no effect- either the copy
data tasks are using a different connection, or they are changing the
DELETED setting themselves.
Anyone got a clue what's going on?
Erik Moore
Clientelligence