Hey, thanks for the reply but The result is not coming if I run this query....

the min(recid ) will always be 1

;

Hey Thanks Ed... Its really a very complex code,gr8 code, result looks good...I will have to understand it first to see how can I implement it in my actual data.

but...

yeah it won't work...

the solution may be is to do the same kind of self join as in the solution earlier,by creating one more temp table , but here I...

Hi,

Now there is a little more into this problem, now can I remove duplicates for that account num range before account number changes.....even if it is not in order...

before...

Thanks a lot Ed....great help

It works I changed inner join to Right join

select b.*

from #test3 a

right join #test3 b

on a.recid = b.recid - 1

where b.recid =...

Wow.......

Hey Thanks for quick reply, gr8 code..

Your code works like a charm....

but it is missing the first row(in bold), any idea why is it behaving like this:

Thank you...

Thats the requirement that is giving me a problem to sort it... and remove duplicates form it easily...

I need to trace every row from SRC as it comes one by...

Here is my sample data, hope this will make it clear...

23350236800003Jun 29 2010 112885AGRINPT

is duplicate here

but the same data may come again after a break

CREATE TABLE [dbo].[test3](

[Acntno]...

I dont know what your primary key is, may be you have to check the data coming from the source, what is the column you are looking up on?

you should...

ROW YIELD NO MATCH DURING LOOKUP will come when you have New rows coming from your source,

(dont do anything for Green arrow, unless you want to do updates to existing...

Thanks for your response,

I have not used NOT EXISTS before this...as my lookup table is to exclude values in a column,I will only have all the values that are...

You can use a lookup transformation to lookup on your destination table... before your destination task and try to lookup the record if it is already there in your destination...

Thanks for your reply..

So you are saying that the better way to exclude is to use lookup tables to exclude instead of doing it on direct OLE db src query?

I have not done much of FTP but did in one project like this to FTP files:

Step 1:

create a BATCH file saying:

ftp -s:D:\mypath\Myfile.txt

Step 2:

Created a .txt file specified in this...

Thanks a lot bt...

your code works like a charm...

this is exactly what I was looking for....

Thanks again...