June 9, 2009 at 5:02 pm
I want to allow any user in a specific Windows security group to run a SSIS
package via a sql Job via a vb.net program (in order to pass some parameters in).
The VB.net program will be run from a client machine, not the sql server.
The SSIS package will reside in the File System.
It appears that a Windows Group cannot own a Job, so how may I share the ability to execute a job ?
What permissions may be required ?
Must I set up credentials and proxies ?
Can anyone describe the steps I must make to make this work ?
Thanks !
June 15, 2009 at 1:24 pm
The VB.net program will be run from a client machine, not the sql server.
The SSIS package will reside in the File System.
It appears that a Windows Group cannot own a Job, so how may I share the ability to execute a job ?
You have two problems one is your client needs an instance of SQL Server running either standard or enterprise edition running depending on what your package is doing because there is no Redist for SSIS like DTS. Two the Agent needs Admin permissions in the server with the file system used to deploy your package. I have covered the file system permissions in the thread below and Microsoft have covered the Agent related configurations in support article below.
http://www.sqlservercentral.com/Forums/Topic661486-148-1.aspx
http://support.microsoft.com/kb/918760
Kind regards,
Gift Peddie
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply