I want to skip the last n records which could be last 3 or 4 records.

How can I do this.

Thanks
Karen

Karen,

You can do it in two different ways. You can create a staging table with an
identity column, load into it, and delete 3 rows with the identity greater
then count(*) - 4. Or you can open the file with File System Object, get the
number of rows, and specify Last Row in your Data Pump/Bulk Load Task.

Ilya

<karenmiddleol (AT) yahoo (DOT) com> wrote

Karen,

First, I would load the entire file into a table that contains an IDENTITY
column.
After that I would use an 'Execute SQL task' to delete the last 4 rows in the
table. Something like:

DELETE DestTable
WHERE IdColumn IN
( SELECT TOP 4 IdColumn
FROM DestTable (Nolock)
ORDER BY IdColumn DESC )

Let us know how you make out.

Thomas Bradshaw
MyWebGrocer.com
Data Integration Services


--
Message posted via http://www.sqlmonster.com