Hi,

I have come across same problem last week and found a solution, Dont know this helps or not, because my Proc in the job step, Times out at a step...

Dear Celko,

Back with one more doubt. In your query your column 'i' is a PK. So no duplicates.

But the column in which i have use has duplicate values....

@GSquared

Yea,I got it. Thank you

Dear Celko,

Thank you So much. I got a clear idea now on the row_number() function.

Thanks again.

@Craig Farrell

Thanks for the immediate response. Could you please be more clear on your explanation, as I am a newbie.

thanks da zero.

I will go through the derived columns and come back to u if any doubts.

Plz tell me the books names.

Pls send links of any e-books or tutorials also.

thanks...

Thanks da-zero.

I didnt understand that how can we clean data using a derived column task.

also If possible suggest me an approach on how to cleanse data in an SQL query.

Thanks...

Thanks sharath.

Now again my doubt is which task is used to dump the source data into temp table.

and do I need to take another dataflow task to send data from...

Yes, I agree with sachin