Solved

SQL Agent running Job - SSIS package - specify with windows user account to use

Posted on 2008-10-26
3
484 Views
Last Modified: 2012-05-05
I have created a package and imported it into SQL Integration services.  I have it scheduled to run.  It runs fine under my account which is the account I need it to run under.  When it executes it runs under a different user account.  How can I specify which WINDOWS user account I want it to use on this specific job only?  

0
Comment
Question by:vzorn
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 22

Accepted Solution

by:
PedroCGD earned 500 total points
ID: 22811347
Check the Security Rules inside MSDB database.
db_dtsadmin
db_dtstduser
db_dtsoperator

The db_dtsadmin fixed database role secures the SSIS packages that are stored in the MSDB database. The members of the db_dtsadmin fixed database role have the following permissions:

Enumerate all packages.
View all packages.
Execute all packages including the packages in the SQL Server Agent.
Export all packages.
Import packages.
Delete all packages.
Change the package roles.

HELPED?
regards!
DatabaseRoles.bmp
0

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

630 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question