SSIS with an user without sysadmin-right -- sql server dts

Joerg Kaukel
10/6/2006 2:08:01 AM

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.

Charles Kangai
10/6/2006 3:21:01 AM

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

[quoted text, click to view]

Joerg Kaukel
10/9/2006 9:41:01 PM

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.

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server dts

sql server dts : SSIS with an user without sysadmin-right