Muchas gracias por su ayuda y estar alli cuando mas los necesitamos!

UNA MUY FELIZ NAVIDAD PARA TODOS!

Excellent Christmas Wish!

Thanks everybody for your responses

I don't wish to give db_owner role as I don't want the user to change/modify the objects structure (tables, sp, fn). But anyway I have also...

I had the same problem, the first thing that I looked for was the table or tables where the DTS was failing. It was pretty easy as I just had...

Talking only within the given scenario ie without thinking about another better solution or table structure... Solution 1 is the best one... why?

By using SET SHOWPLAN_ALL ON we can get...