Execute SSIS Package through Ms Access (1 Viewer)

[neoklis]

Hi all,

How can different users, execute SSIS packages to SQL 2008 through MS Access;

This is what I’ve done so far. I am asking for rour advice in case it can be done in a some other (better) way…

1.In MSDB database for the user I want, I have apply the roles: SQLAgentOperatorRole, SQLAgentReaderRole, SQLAgentUserRole
2.I have create a job that calls package
3.I have create a stored procedure that starts the job.
4.I call sp through Ms Access.

I am looking for your advice..

thank you.

 

[SQL_Hell]

I dont think there is a better way personally.....

You could just call DTEXEC through a stored procedure but then you wouldn't have all the nice things that a job gives you like exection time, duration, error logging.

Is there anything you dont like about calling an sp to execute a job?

 

[neoklis]

I was confused about the permissions and the roles i had to apply for the users i wanted to be able to execute a job.Finally i made a group on server and i added the jobs' users. I applied the roles and the permissions for that group and everything looks fine...

Thank you for your post.