View Single Post
  #2 (permalink)  
Old April 27th, 2004, 04:40 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
Default

When you schedule a package make sure you use your services account that has the right permission to execute DTS packages. Make sure that account has access to the msdb database. On the job "Owner" name select the account which will run your job ( which I suggest "SA".