October 31, 2007 at 7:27 am
Hi ,
I have creaetd on package in studio and i want to put it in MSDB now, i don't want to run as file system but rather want to use as MSDB.
also if other user wnat to create package and put it in MSDB how can i grant permission to do that for other user and how they can run other than job scheduling. what kind of rights that i need to provide them!!
I know it is confusing but i am confuse about it as well
Thanks
October 31, 2007 at 12:34 pm
From BIDS or VS you save a copy of the package to the server. You can then execute the package via DTExec and DTExecUI, or as a step in a SQL Server Agent job. Some links w/ more information -
http://www.sqlservercentral.com/articles/SQL+Server+2005+-+SSIS/2999/
http://msdn2.microsoft.com/en-us/library/ms141708.aspx
Regarding SSIS roles/security -
http://technet.microsoft.com/en-us/library/ms141053.aspx
Tommy
Follow @sqlscribeViewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply