Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Other SQL Server 2008 Topics
 Stored Procedure - Security - Sql Job - SSIS

Author  Topic 

sbrazier
Starting Member

19 Posts

Posted - 2011-11-23 : 11:11:34
Sorry not sure if I'm in the right topic.
VS 2008 & SQL Server 2008
I created a stored procedure that creates a SQL Agent Job.
This job will execuite an SSIS package. I can run this sp in SQL and it runs fine. However, I know that security has changed in SQL 2008. What I want to be able to do is have a user execute this stored procedure from a windows application. What security issues should I be aware of.

johntech
Yak Posting Veteran

51 Posts

Posted - 2011-11-28 : 09:05:37
check below link
http://www.codeproject.com/KB/database/Call_SSIS_from_SP.aspx
http://www.mssqltips.com/sqlservertip/1840/sql-server-integration-services-ssis-best-practices/
Go to Top of Page
   

- Advertisement -