Results 1 to 2 of 2

Thread: Scheduling a DTS Package

  1. 03-09-2006, 06:05 PM #1
    bobkand
    bobkand is offline Registered User
    Join Date
    Sep 2005
    Posts
    43

    Question Scheduling a DTS Package

    I got a DTS package and when i schedule it to run every day it is failing....??

    When i normally run the DTS it is executing but when i click on the JOB and start the DTS it is failing.... is there any permission issues i should look at while shceduling a Job..????
    Reply With Quote Reply With Quote
  2. 03-10-2006, 09:16 AM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    If remote file involved in the package, have to start sql agent with domain account that has permission on remote file.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules