Hi all,

I have a DTS package with a transform data task which
takes data from a dBase III file and inserts it into an
SQL table.

The source connection is a dBase III connection.
The destination connection is a Microsoft Data Link file,
which points to an SQL 2000 server.

The task imports the rows from the DBF file fine. But I
now want it to also retrieve the deleted rows, and I can't
seem to find any option in the source connection or the
data pump task to include the deleted rows.

Is the setting hidden away somewhere, or will I need to
create an ODBC connection and set the "Deleted=0" property?

Thanks in advance,

Steve

On the driver there is a "Show deleted Rows" option I believe

Allan


"Steve" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Do you know how I can get to this option to change it?

Though the Connection Properties dialog window of the
dBase III Connection object in the DTS Package, or through
the Data Transform Data Task Properties of the Transform
Data Task?

Regards,

steve

As you set up the DSN there is a checkbox on the front screen

--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"steve" <anonymous (AT) discussions (DOT) microsoft.com> wrote

So it is not possible to set this option in the "dBase
III" connection in DTS? I *have* to create a DNS to get
this option?

I had a quick peek through the properties of the Connection and didn't see
the option. It is possible that you could do this using the Extended
properties of the driver in much the same way you would tweek with the Excel
Connection

--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

<anonymous (AT) discussions (DOT) microsoft.com> wrote