Results 1 to 2 of 2

Thread: I can't get scheduled DTS package to execute

  1. #1
    Join Date
    May 2006
    Posts
    8

    I can't get scheduled DTS package to execute

    My database resides on my ISP SQL server, in Colorado. My new data can be found as a TXT file on the C: drive of the shipping PC in my Florida office.
    I created a DTS package to import the data from the TXT file to a table in my database. The package works fine, until I schedule it to run.
    The package uses the UNC address to find the TXT file. As a result, I can go to any PC in my office and execute the package.
    But, when I schedule it to run unattended, it fails.

    Can anyone give me any advice?

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    Seems sql agent service startup account doesn't have permission to access your text file. Either starting sql agent with proper account or put file on sql server's local disk.

Posting Permissions

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