This actually works for me. Thanks guys.

Thanks for the responses. You make a great point about just grouping it. The issue however is that since the sproc is so huge, the text data is an ntext...

Thanks guys, I assure you it was not an exam. It is actually a self motivated project I am working on. I would have appreciated the answers even if it...

Very great point Jeff. here is a DDL that should be fine for all versions.

CREATE TABLE #TEMP

(ID INT, VALUE INT)

INSERT INTO #TEMP

select 0, 21 union all

select 1, 98 union...

Homework? How do you mean ?

I tried the following but the group by makes it return all the results and averages out each row separately.

select ID, AVG(value) 'avg' from...

Gift,

Thanks for the helpful link, i set up a log for the package and the same thing happened, when i run the package manually, i see the events logged bbut...

Hey Bru, thanks for that. how do i add the sql service agent account to be a member of the local admin group?

Hey Bru and gift, thx for your response. How would I enable logging of the package? Yes the package runs without any errors being reported. The run as is under...

Interesting, is there a way to fix this that you would suggest?

Thank you for taking your time to help me with this problem, sorry this response is late, your effort is well appreciated !

Thanks for your input Steve, i have never worked with expressions and variables anyway you can explain further?

Actually the filename uploaded is very consistent...i.e for today, it would be

konamifiles_transfer_2009-11-11.csv

Yesterday would be

konamifiles_transfer_2009-11-10.csv

and so on. How do I get only the file for the current...

Thanks, I just wanted to know what would happen in the other scenario for future purposes. Thanks again guys !

Thanks a lot. So what if I planned on adding more data to the database daily? What would be the best solution then?

Its a bout 50 gigs and I don't plan on adding more data. I guess I just want to know how to get the space back because deleting a table...