Viewing 9 posts - 1 through 9 (of 9 total)
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...
December 13, 2012 at 7:26 am
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....
January 20, 2011 at 7:54 am
Dear Celko,
Thank you So much. I got a clear idea now on the row_number() function.
Thanks again.
January 20, 2011 at 7:36 am
@Craig Farrell
Thanks for the immediate response. Could you please be more clear on your explanation, as I am a newbie.
January 19, 2011 at 12:38 pm
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...
November 16, 2010 at 1:42 am
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...
November 15, 2010 at 3:30 pm
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...
November 15, 2010 at 3:14 pm
Viewing 9 posts - 1 through 9 (of 9 total)