DTS doesn''t run in a Job

  • Victor Gaspar P.

    SSC Enthusiast

    Points: 127

    Hi everyone!

    I have created a DTS to update a table in the costumers DB in our website SQL Server.

    Firs i delete * from tblSyncClientes (on website), then copy * from my local table to tblSyncClientes, update tblClientes(on website) from tblSyncClientes, add new entries and im done.

    When i go to Local Packages on my local server and right click the package ->execute package, it works just fine! But when i program this packages it fails , the server event viewer just informs me that the job fails...no other details.

    Does anyone have an idea what could i be doing wrong??

    Thanks in advance!!

    Saludos desde Guadalajara, tierra del tequila!!!

  • philcart

    SSC-Forever

    Points: 47794

    Edit the DTS package and turn on package logging.

    Then after the package is executed you can view the log by right clicking the package -> Package Logs...

     

    --------------------
    Colt 45 - the original point and click interface

  • Victor Gaspar P.

    SSC Enthusiast

    Points: 127

    Seems that package log only works for SQL Server 2000, im running SQL 7 , thanks anyway!

  • Greg Charles

    SSC-Forever

    Points: 45403

    DTS packages in scheduled jobs often fail because of security.  A package in a job executes using the security context of the login that SQL Server Agent run under.  I suggest you use the search function on this site to look for "DTS job" and look at the numerous threads dealing with this.

    Greg

    Greg

  • Victor Gaspar P.

    SSC Enthusiast

    Points: 127

    Thanks! I've been reading in the forum threads and i also think its a security issue. I havent got over it, but i'll keep on trying.

    Hasta luego!

  • philcart

    SSC-Forever

    Points: 47794

    Ok, you can still capture some of the DTS output by specifying an output file on the advanced tab of the job step.

     

    --------------------
    Colt 45 - the original point and click interface

  • mosaic-287947

    Ten Centuries

    Points: 1045

    Is your customer's db in a different domain? If so, you may have an account impersonation issue

Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply