Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2003
    Location
    Valley City, OH
    Posts
    18

    Unanswered: Shopping for DTS Package Scheduling Help

    Good Afternoon

    First time shopper on this board...hopefully you can help me.

    I am trying to figure out how to schedule a DTS package located on a Server to run at a certain time. The DTS package will contain the path to a V/B 6 executable file residing on the same server.

    So to test my methodology, I made a package on a server with code to run the V/B 6 executable off of my local machine. When executing the
    package manually it works fine. However, when I schedule it the job does not start. I could not find a way to edit the job I had previously scheduled so I made another one in case I "fat fingered" something.
    The same thing happens...no job starts.

    Any ideas?

    Thanks,
    Ed

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    I'd be inclined to guess that you haven't got SQL installed on the server, or that you don't have the DLL files needed to support DTS on it. My suggestion would be to schedule the job using the SQL Agent, it makes everything so much easier when working with DTS!

    -PatP

  3. #3
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    SQLAgent service account needs to have permissions to access the file location.

  4. #4
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    As always I refer this KBA http://support.microsoft.com/default...;EN-US;Q269074 to accomplish the task.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

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