View Single Post
  #4 (permalink)  
Old April 28th, 2004, 03:39 PM
jemacc jemacc is offline
Friend of Wrox
Join Date: Nov 2003
Location: Lehigh Acres, FL, USA.
Posts: 625
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to jemacc

If your are running your SQLSERVERAGENT you set an account to run your services;under certain situation (before sp3a) this account was an admin account with server administrator role in SQL. In order for you to run execute DTS packages you must make sure the account has at least dbowner on the msdb database. Once this is done; on Enterprise Manager drill down
-->data transformation Services
-->local packages
--> right click your DTS Package
--> select schedule package
Schedule how you want in to run
Under General you should see "Owner"
select "SA" from the drop down list
That account is has the highest permission and privileges on your database.

I hope this helps. If it does not i will email you the screen shots