• Jack Corbett (5/22/2015)


    When running in SSMS I believe it is running under the SQL Server Service account. I know it is not running under the SQL Agent Service account and that is verified by the fact that you can run this successfully in a Job.

    Gave it a go, gave the user full access, but no luck. Still receiving the same error.

    Have just editted my initial post, but it does seem to be a permission error, but I have no ideas why, as both the SSIS, and SQL Server users have access to that directory.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk