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
Free Windows Admin Tool Kit Click here and download it now
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..
Free Windows Admin Tool Kit Click here and download it now
October 12th, 2012 11:22am