We build a program in C# to run SSIS-packages on SQL Server 2005. This
program generates packages and starts the packages, but the execute on SQL
Server for the packages only works, then the user has the right of sysadmin
on SQL Server 2005.
We found some informations about this problem under
http://msdn2.microsoft.com/en-us/library/aa337083.aspx
but our problem still exists : We want to have an user on SQL Server with
the right only to execute the packages generated by our program.

Could your problem be the one described here?:

http://support.microsoft.com/?kbid=918760


Charles Kangai, MCT, MCDBA
Author of Learning Tree's 4-day course: "SQL Server 2005 Integration
Services" http://www.learningtree.com/courses/134.htm
Author of Learning Tree's 4-day course: "SQL Server Reporting Services"
http://www.learningtree.com/courses/523.htm
email: charles at kangai.demon.co.uk



"Joerg Kaukel" wrote:

No, sorry, It's an other problem. We have the problem by using the
functionalaty out of our program (using the .NET-Framework functionalities)
when the user is not sysadmin on our SQL Server.

"Charles Kangai" wrote: