bat file to execute ssis package with run as specific user
so i am banging my head against the freaking wall over here and cant seem to get anywhere so i have decided to try a new method of executing a ssis package... I have not been able to run this SSIS package in a job even after creating a proxy acct. but it will run if executed in SSIS. http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/9eff7fbc-0af0-4f52-9f92-8c12c556dc50/ So I am wondering if i can create a bat file to run the package as a specific user.
October 11th, 2012 5:58pm
You can run a package using xp_cmd shell Try this http://www.mssqltips.com/sqlservertip/2135/run-ssis-using-xpcmdshell-in-a-sql-server-stored-procedure/Mudassar
October 11th, 2012 6:45pm
Hi, If you are tring to execute packages installed in database from job you will get this kind of error. Instaed of this create a bat file to exectue the package and you you can restrict or grant the user to execute the bat file. Batch command to execute a package from database will like shown below, DTEXEC /DTS "\MSDB\%DestinationFolder%\packagename" /SERVER %Server% /CHECKPOINTING OFF /REPORTING V To set, view, change, or remove file and folder permissions Open Windows Explorer. (Click Start, point to All Programs, point to Accessories, and then click Windows Explorer.) Locate the file or folder for which you want to set permissions. Rightclick the file or folder, click Properties, and then click the Security tab. (If you do not see the Security tab, you may not be joined to a domain. See To display the Security tab below.) Do one of the following: To set permissions for a group or user that does not appear in the Group or user names box, click Add. Type the name of the group or user you want to set permissions for and then click OK. (When adding a new user or group, by default, this user or group will have Read & Execute, List Folder Contents, and Read permissions.) To change or remove permissions from an existing group or user, click the name of the group or user. Do one of the following: To allow or deny a permission, in the Permissions for User or Group box, select the Allow or Deny check box. To remove the group or user from the Group or user names box, click Remove. If the check boxes under Permissions for user or group are shaded or if the Remove button is unavailable, then the file or folder has inherited permissions from the parent folder. To display the Security tab Open Folder Options in Control Panel. (Click Start, click Control Panel, click Appearance and Themes, and then click Folder Options.) On the View tab, under Advanced settings, clear Use simple file sharing [Recommended].
October 12th, 2012 2:07am
Thanks for the help..
October 12th, 2012 11:22am