I want to transform data from sql7 to a text (or excel) file. I'm using unc filename to a shared directory with 'everyone' 'control total' rights.

running the dts from enterprise manager works
running it with dtsrun : it works
running it using vbscript and package method : it does'nt fill the result file without any error (the same method with a dts transforming data from sql7 to sql7 will work)

I think the problem is a problem of user rights ?