Running a SSIS package as myself via SQL Agent (2012)

  • this is driving me bonkers. I know I should not do it but this is not an enterprise solution I just need to be able to run a 2012 SQL Agent job to execute a package as ME rather than as the SQL Server Agent Service.

    Why ?

    Thats because by the time I get the service permission to access the folders I need I might as well give up.

    This is just a noddy job and if I leave nobody else cares about the job.

    Cant see any other way in the SQL Server Agent job to do this so thoughts would be good.

    Cheers

    E

  • Create an SQL Agent SSIS proxy with a Credential using your ID.

    --

    SQLBuddy

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply