thanks folks for input

i maybe have it

stopped using the full qualified name from forloop and used a variable for the path + filename

will do a little testing but...

the abc.csv is just a placeholder for variable the forloop should pass to it

if i take out the abc, i get the below error - yes i have...

ok

small progress again, firewall was blocking some ports on remote computer so i think i have passed the network access issue

now my forloop does not seem...

plus as you guys already know 🙂

it is definitly something to do with reading from the network, as locally it works fine!!

i did think using...

ok, so to try and get more info i have tried running the package via cmdshell

now i get a bit more feedback! this runs fine in vstudio, but...

yes all shares are fine, i have given the user full read/write etc
i am only using unc

the error is nothing more than "executed as user "username" the...

hi steve
i thought that to but
the agent is running on a network account, and i gave given the network account full access to the folder
i can log...

ok some progress - sort of

i changed the folder location of my my files to full unc rather than a mapped drive

now i get a failure...

hi Phil

i think you are right! got a query working to pivot my data out as i want

thanks

mal

hi John

apologies, as usual I was being dopy!

I was collating the wrong side of the joins!!

funny how quickly I find my errors after I post on here, must be...

hi Jeff

yea I have been onto the Software company already, and apparently its an issue they know about and can be fixed in the next upgrade.

Excellent ! it seems one of our applications are leaving residual transactions open that will never be killed of until sql would be rebooted!

I have now cleared the old processes,...

hi Lynn

for this db, result is

DatabaseNamelog_reuse_wait_desc

Plato CronusACTIVE_TRANSACTION

thanks Hugo

but I think I have something really weird happening, by running below (which is pretty much what I have been trying, only I was doing log backups)

USE [Plato Cronus]

CHECKPOINT

--First...